Skip to Content
0

Report to Show Order Header level information based on Created On Date

Jan 11, 2017 at 02:06 PM

26

avatar image

Dear Team,

I have a requirement to show a report on list of orders w.r.t the Creation date of an Order.

Now i have a Cube in BW which stores both Header and Item level information. The Created On date field stores the creation of order and also the material coming from item and header flows. Now there can be situation where a material can be deleted and created again on other date in future.

If teh creation date of an order is 10.1.2016 and on same day a material is created. Now this material is deleted and created again on 11.1.2017. Hence now in cube we have records with creation date 10.1.2016 and 11.1.2017. If i execute the report with interval variable on Creation date i will get these two dates together.

But user wants to see orders in report for the variable period entry given. For example if report is executed for 01.01.2017 to 11.01.2017 this order should not show up. I am trying to know how i can achieve this requirement.

I thought to create a new report on Order header DSO and this does show right data as this DSO does not have material loaded. However this DSO does not have Net Value and other fields which user needs in report so checking i can achive in existing report/table

Please advise.

Regards

Zabi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers