Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Best practices with mutually exclusive Dimensions Expand / Collapse
Posted Friday, January 24, 2014 7:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 1,194, Visits: 3,286
I'm not sure I follow this completely, but my initial inclination would be to make this a single dimension with the initial heirachical attribute having as its data either Product or Service. If I follow this correctly, Product has more steps in the heirarchy, but you can use N/A or repeat the word Services. This allows an easy comparison between revenue for Products and Services and seems more business intuitive to me.

Post #1534486
Posted Friday, February 14, 2014 2:57 PM


Group: General Forum Members
Last Login: Friday, July 22, 2016 8:15 AM
Points: 14, Visits: 200
One final thought: Will you need to be doing a lot of cross-product analysis, or will they mostly be Line Of Business or Product Type specific?

I'm not 100% sure what you mean by cross-product analysis.

Reporting is varied. Some reports will show all Services grouped by category (i.e. there are multiple Service codes that fall under the "Tire Balances" category), another report will show Service categories as well as Product categories divided by the number of tires sold. ("Tires" would be a Product).

Hope this clarifies. I find the unknowns of what reporting will be requested to be the most challenging part of designing.

Post #1541787
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse