Skip to Content
0
Former Member
Dec 04, 2006 at 09:10 AM

BEx issue - ranking of materials

104 Views

Hi All,

I am writing a query where I need to display the Top 10 materials (as per sales data). I did this by using condition.

Also I need to display the ranking. For this I used the same KF and displayed it as ranked list.

But now I want to create an APD and take this query as the base query.

I wanted to know if my transactional ODS will have the ranking as query data?

I would need this to write the final query where I need Branchwise YTD sales of the Top 10 ranked materials. This sales value should be displayed as the % sales of that ranked material as a percent of the total sales of the Branch.

Please advise.

Thanks and warm regards,

Sharmishtha