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)
 SSAS 2008 - How to change dimension description wi

Author  Topic 

Gmare
Starting Member

6 Posts

Posted - 2012-06-13 : 12:27:58
Hi all,

I have a SQL Server 2008 Analysis Services installation and I'm trying to create a dimension. All seems clear, except a functionality that I had in SSAS 2000 and I can't find in this new release.

In SSAS 2000 I specified a Member Key column (example: customer ID) and a Member Name Column (example: customer ID + Customer Name + Customer Surname). In SSAS 2008 I have two similar columns (called Key Column and Name Column) , but in the Name Column I can't specify a formula (I can only specify a single field for the description).

Did someone face the same matter?

Thanks for the support!
   

- Advertisement -