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.
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.