Cummulated kpi which is created in BEX dssigner is not showing in WEBI Side

[former_member218377]

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

Thanks

Nishant

[former_member218377 · Accepted solution]

Hi suman,

thanks for replying above solution

i have implemented above formula in webi side but its result not cumulated properly

so can u suggest some more formula

Thanks,

Nishant

[former_member182541 · Accepted solution]

I haven't done this, have you tried with "runningsum" function also try to take the value without unit and check.

[Former Member · Accepted solution]

Hi Nishanth,

Try RunningSum(<KeyFigure>) ForEach(<Dimension>) formula.Here Dimension is ,on which characteristic you want to see the cumulative values.Below link will help on this for the same.

http://scn.sap.com/thread/1962721

Regards,

Venkat

[Former Member · Accepted solution]

Hi Nishant,

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.

Regards,

Shashikant chourasia

[former_member182541]

can you share some screenshots ?

[former_member218377]

Hi suman,

PFA attached screen shot and detail about above problem

In BEX designer side we create two KPI one is not cumulated and other one is Cumulated .but on WEBI  side ONLY ONE KPI Which is non cumulated in nature is showing and other one which is cumulated nature is not showing

For Ref purpose i have attached screen shoot

1) First pic show KPI Is  cumulated in nature

2) Second Pic KPI Is Non cumulated in nature

3) third pic show on Webi side on that side only comulative  KPI is shown

[former_member182541]

Check out the below link buddy with the point number 26. This is not supported in BO, you need to find a alternative way in BO. Hope this Helps!!!