Forum
Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server General Issues
 SQL Server Analysis Services (SSAS)
 Suppress repeating textual measures
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbooth

United Kingdom
69 Posts

Posted - 06/11/2013 :  01:07:18  Show Profile  Reply with Quote
This is a general OLAP query I'd appreciate any ideas on. It'd vastly increase uptake of OLAP reporting in our production system.

In order to improve performance of cubes with lots of textual attributes, those attributes are being enclosed in hierarchies and removed from selection as row attributes. They appear as columnar attributes instead and so aren't considered for sort candidates. This works very well until a report is designed with column attributes such as Month. All column attributes are repeated for each unique Month, cluttering up the report with duplicate static attributes.

For an example see "Product Sales Amount by Country Month and Year" on the test server. The hierarchy attribute 'Product Line' should report once for each Product Model Category, however being a columnar attribute it repeats for each Month shown. The only measure required is Internet Sales Amount.

If Product Line is shown rowwise it becomes a sort candidate, once several such attributes are selected the report's performance degrades significantly. Showing Product Line as a non-repeating column attribute would be very useful if it's feasible..
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000