January 9, 2009 at 11:30 am
not sure if this question belong here . but lets try my luck.
I created a cube in SSAS and now trying to create a Pivot table off that cube in Excel. Pivot table wizard shows you fields that you can choose from for your pivot table. I have attached a screenshot.
I would like to know if its possible to rename/relabel the 'Hierarchy' button somehow?
any ideas?
January 11, 2009 at 6:37 am
It looks like this is the Excel 2000 or 2003 edition (not that it matters). The naming of the items is coming directly from what is defined in your SSAS database. You will need to go into the dimensions in the database and rename the hierarchies that you have left as 'Hierarchy' when creating your user defined hierarchies. By default when you create hierarchies they will be named Hierarchy, Hierarchy 1, Hierarchy 2, etc. You need to rename these in the dimension designer to something meaning full like Fiscal, Calendar, Fiscal YQM, Calendar YQMD, Product Categories, Employees, Geography, etc.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply