Skip to Content
avatar image
Former Member

Bex Design

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 15, 2016 at 09:01 AM

    Hi Rupak,

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

    Regards

    Gajesh

    Add comment
    10|10000 characters needed 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

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

    Hello All,

    Please provide some update on the requirement

    Rupal

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2016 at 08:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded