Skip to Content
0
Former Member
Mar 16, 2013 at 09:36 AM

Approach to design below report in SAP BI/BW

14 Views

Hi All,

Have to design a report using Bex Query Designer in SAP 7.0. This report is using sales cube. sales cube having product and customer dimension(Master) data along with sales transaction data.

Report requirement.

Display the customer name, order,quantity and price values based on the product and theater associated to order in sales cube.

Based on sales data need to identify the low and high and current prices associated to the orders processed based on product. Product associated with order may having the multiple customers but we need one customer details that having required price. Need to get one customer details having requested prices.

Ex: Product 1 associated with customer having Prices like C1-3000,C2-3200,C3-3500,C4-4200,C5-4500,C6-3800,C7-4100,C8-3700,C9-4500 then we need to get C1 details under low price section, C5 details under high price section and C9 (having recent order creation date) details under current price section.

Can you please suggest method to implement this.

Attachments

pastedImage_2.png (18.6 kB)