Hi ,
I have a 'strange' problem that has caused me considerable frustrations after upgrade to the new 11.2 version.
I am using ADOMD to get data from some Analysis services cubes (MS SQL server 2008), and there I have a custom calendar dimension. Using version 11.1 this calendar works as it should, and displays the month-names from the dimension. After the upgrade and trying to expand a year into months, nothing happends exept that the + in front of the year changes to - .
I also notice that this malfunctioning diemsnsion gets 'stuck' in the xamPivotGrid, and can not be removed. There are no errormessages.
It may be added, that this dimension is working perfectly well in any other tool I have available, including Excel. Any other dimensions I have in the database does not cause the same problem.
I have done quite a bit of checking the cube database and dimension to try to find any settings that may cause the problem, and have found nothing. I have also made sure that no names or labels uses any of our special nordic characters. What I find is that if I set the dimension to display the key-values (month number - as WChar) and not the descriptions, it will expand in the xamPivotGrid.
What can I do to try to identify this problem. I am quite lost, and can not use the upgrade as long as this problem exists.
Below are screen captures from my application, first in the 11.1 version then after upgrade to 11.2. No other modifications have been made, and the Analysis services database is the same.
Solved (sort of) :-)
In the process of making the 'dokumentation' sent last I did the stunt of changing the dimension type from Time to Regular, and after processing with this the month-names comes up as expected.
I am not much wiser though, as other client tools gives the correct result regardless of this settiing, and I can not really see how this can make any difference.
Regards Jorvart
Thank you for quick reply,
The dimension is not generated with a wizard, as the datasource database contains and maintains a Calendar-table that I uses for this dimension.
Here is the actual dimension definision in VS:
This gives me the previously described dimension where month names will not expand.
Just changing the 'NameColumn' definition to ihe Key field (maaned) like shown here:
Gives this result in the xamPivotGrid ( normal and expected behaveour) :
Hi jorvart,
Can you give more information about this one:
" What I find is that if I set the dimension to display the key-values (month number - as WChar) and not the descriptions, it will expand in the xamPivotGrid."
like some sceeen shots from buisness intelligence studio - what property is changed and so on.
And can you provide a screenshot with expanded grid when dimention is set to display the key-values?
And how is your dimetion created? I suppose you have generated a time table using the wizard in buisness intelligence studio and created relationship: PK (date column in new created table) - FK (column with dates in some of your tables)
Regards,
M. Yovchev