Time Dimension Display Values - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Time Dimension Display Values

Author

Topic

Spica66
Starting Member

23 Posts

Posted - 2012-08-27 : 09:40:56

When I browse the time dimension in my cube, the output looks like this:
-Fiscal Year 2007
- Fiscal Quarter 1, 2007
- Fiscal Quarter 2, 2007
- Fiscal Quarter 3, 2007
- Fiscal Quarter 4, 2007
- Fiscal May, 2007
- Fiscal June, 2007
- Fiscal July, 2007

I am trying to get:

-2007
- Q1
- Q2
- Q3
- Q4
- May
- Jun
- Jul

I have tried renaming the attributes, and the hierarchies, but those are just the labels used in the dimension - they do not affect the output to the cube. Can someone PLEASE tell me how to change what the cube displays to the user?

Spica66
Starting Member

23 Posts

Posted - 2012-08-27 : 09:49:38

I should mention that I used the Dimension Wizard to create a new time table on the server.

Spica66
Starting Member

23 Posts

Posted - 2012-08-28 : 10:28:52

The answer was:
Open the dimension
Right-click on the attribute to display the properties
Select the ellipsis in the Name Column property
Select the column that has the text you wish to display

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources