Hi Experts ,
I really need help at my starting stage of SAP BW .
I want to design infocube which is having 5 dimension tables with their keys mentioned .
1) Product(prod_Skey)
2) Member (Mbr_Skey)
3) Date (Dt_Skey)
4) Country (Ctr_Skey)
5) Outlet (O_Skey)
Now all these 5 dimension tables i need to link to 1 Fact table named (Fact_Transactions) using respective " xx_skeys".
this Fact table is having its own key figures like (unit price , Qty) .
Now my question is how can i design this in Infocube ??? I need steps to be followed ?
I designed it successfully in SQL 2005 (SSAS) , but dont know the stpes to follow in SAP-BW .I really got stuck in this .
Awaiting your reply ...... & thansk in advance .
Bhushan N
Start Free Trial
