Hi Team
When I am Running two Reports in Sap Sales performance Home Site, But Only i can see last Running Reports, example (First Am Selected test1 report and test 2 report, Next Start Report the pipeline Will executed but Result only Showing Last Reports Name)
This is my ODS Report Config File -Report Proc
Proc Code:
create procedure EXT.SP_ALL_REPORT_RUN_PROC (
IN periodSeq BIGINT
)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
DEFAULT SCHEMA EXT
AS
BEGIN
DECLARE V_Callreportname VARCHAR(2000):='';
select runparameters into V_Callreportname
from tcmp.cs_plrun m inner join tcmp.cs_stagetype d on m.stagetypeseq =d.stagetypeseq
where name = 'ODSReportsGeneration' and m.periodseq=periodSeq
and m.reporttypename='Crystal' --and m.status='Successful'
and m.starttime =(
select max(m.starttime) from tcmp.cs_plrun m inner join tcmp.cs_stagetype d on m.stagetypeseq =d.stagetypeseq
where name = 'ODSReportsGeneration' and m.periodseq=periodSeq and m.reporttypename='Crystal' --and m.status='Successful'
) ;
if INSTR(V_Callreportname,'Mob_B2B_Account_Owner')<> 0 then
call EXT.MOB_B2BEXT_SP_ACCOUNT_OWNERS_REPORT_WRITE (periodSeq);
END IF ;
if INSTR(V_Callreportname,'Mob_B2B_Product_Target')<> 0 then
call EXT.MOB_B2BEXT_SP_PRODUCTTARGETS_REPORT_WRITE (periodSeq);
END IF ;
end