Hi everyone, I'm new to the world of Analysis Services, so I might make a stupid question.
I searched over the web, but I haven't found an answer.
- Microsoft SQL Server Analysis Server 9.00.4035.00
- Microsoft Office Excel 2003 Sp3 (i have the Excel Add-in for SQL Analysis Services version 1.5.0166.0)
I created a cube in Microsoft Visual Studio 2005 with a fact table and only one dimension.
In the 'KeyColumns' DimensionAttribute properties i have the Dimension key and in 'NameColumn' the description.
When I browse the cube with Excel (olap driver 9.0) I can see the description of the Dimension without problem.
The problem starts when I create the local cube with the excel procedure (create offline cube) and I connect to It using Excel; in this case, the description ('NameColumn') disappears and i can see only the Dimension code ('KeyColumns').
When I connect again to the server Cube, leaving the local cube connection, i can see again the description.
It seems that the Local cube does not contain the description of the Dimension, but only the key.
I did the same thing using Microsoft SQL Server Analysis Server 2000, and when I connect to the local cube created with Excel I have no problem viewing the description of the Dimension.
Where am I doing wrong? Am i fo
View Complete Post