SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Analysis Services (SSAS), user-defined hierarchies Rss

   Items 1 to 1 of 1   

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?   Read more...
By Additional Articles 2009/07/10 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,978 reads
   Items 1 to 1 of 1