Skip to Content
0

Bex Design

Nov 15, 2016 at 08:33 AM

52

avatar image
Former Member
bex.jpg

Hello All,

I have a requirement to create a Report which shows last 30day how many PO created as on that date(Approval date). I have Approval date in the info Provider. I also have Count of PO
Picture 1





Info Cube contains BelowApproval DatePO Count
Total PO Created As on the given Approval : date

Picture 2

This I should get from RKF: KF=PO count, Appr Date = Less thanequal to Current Date, Approval Date Less than -1, Approval date less than -2 etc

The final Out Put should be Belwo

Picture 3

Approval DateTotal PO Created As on the given Approval date
bex.jpg (62.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Gajesh Nagesh Nov 15, 2016 at 09:01 AM
0

Hi Rupak,

One way of doing this is by storing the snapshot on daily basis to another cube/DSO.

Regards

Gajesh

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Ganesh,

Thanks for your reply

This is an option but I was looking if something can be done at Bex or Wei Level

Rupak

0
avatar image
Former Member Nov 17, 2016 at 02:14 AM
0

Hello All,

Please provide some update on the requirement

Rupal

Share
10 |10000 characters needed characters left characters exceeded
Mario Tibollo Nov 17, 2016 at 08:05 AM
0

Create a formula based on the PO count. For this new formula, go to the properties. In the tab Calculations, Local Calculations, set the flag for Cumulated.

M.

Share
10 |10000 characters needed characters left characters exceeded