Cummulated kpi which is created in BEX dssigner is not showing in WEBI Side
I am facing below issue
i have create one kpi working capital commutative in Bex designer which is cumulation .its working fine
means result is coming cummulated in bi side. but in WEBI side above kpi is NOT Showing . Already I Have allow external access to this query
Please advise me the above issue
First of all make a variable (suppose name ABC)with formula RunningSum (<Key Figure>) after that apply this formula Forcemerge ([ABC]) this will definitely give you Proper result.