Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Best practices with mutually exclusive Dimensions Expand / Collapse
Author
Message
Posted Friday, January 24, 2014 7:25 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 3:40 PM
Points: 804, Visits: 1,990
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 8:05 AM
Points: 6, Visits: 92
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