Can some give me some guidance on how to create a 'Contracted Services' Dimension?
I have the following working Dimensions:
Customers and Services
And a Fact_Service_Usage. Fact_Service_Usage has a CustomerKey and a ServiceKey. This creates a proper intersection of Services_Usage, Customer and Service.
However, in our business we need to ensure we only report on 'Contracted Services'.
So I need to create a Dimension that properly enumerates only those services for which the Customer is contracted. I have a table called DimContractedServices that holds the CustomerKey and the ServiceKey for those services for which they are contracted.
In the Data Source View I create the relationships between the respective Keys and use the Dimension Building Wizard to create the Contracted Services Dimension.
This Dimension is not working correctly.
Could someone help walk me through an example of how they would approach building this ContractedServices Dimension correctly? Perhaps someone has built a similar Dimension and can give me some hints on how to structure this so that it allows the enumeration
of the .MEMBERS for only ContractedServices.
Thanks very much for the assistance.
View Complete Post