Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

For Calculated Key figure

Dear all,

I extract the data in detail level into cube, like that,

Company Plant Mtl CalDay SalesAmount

1000 1010 5000001 20080101 5000

1000 1010 5000002 20080101 100

1000 1011 5000002 20090301 15000

Now, I need show infomation in company level,if the SalesAmount is greater than 3000 in one day,the operation day of the Plant will be added 1,but each plant can only have 1 operation day in one day. so the culumative report will be that,

Company OperationDay

1000 2

Can I implement it in QueryDesign without uploading the data to another cumulatived cube,

Any suggestion will be appreciated.

Best regards.

Tianli

Former Member
Not what you were looking for? View more on this topic or Ask a question