Dear All,
I am trying to create a report from a data source.
i have created a cube holding only 4 tables.
1. SalesOrder
2. SalesOrder-ItemDetails.
3. CustomerMaster
4. ItemMaster
All are linked with correct fields.
Now in the CUBE the SalesOrder Table is being a fact and the SalesOrder-ITemDetails being a dimension. But to my surprise i am unable to find the important fields for the report 'Customer NAme' and 'Item Name' ??
I suspect as the CustomerName & ItemName is being the join fields those didn't appear.
Hope i clearly explained the issue.
If anyone have faced such issue, please let me know the solution.
Thanks in Advance,
Meera.