Hi I am new to SSAS. I was able to build a cube if the data view includes only the clear-cut type of fact table and dimensions.
Now I am confused as what to do when thing get a little bit "complicated". Here is the made-up simplified version of the scenario.
A delivery company that deliver goods to several states. Some work orders require delivery to multiple states.
There are 3 tables:
Table 1 (a measure) - WorkOrder w/ fields: workOrderId (pk), Amount.
Example: WorkOrderId Amount
View Complete Post