March 29, 2005 at 10:52 pm
Hi,
I have three dimensions for my cube.. Among those, one is time dimension.
I m using OWC to view the data in VC++. I will be selecting one dimension value and display the aggregated values of other dimensions. For example, consider the three dimensions as events, time and representatives.. I want the Grand total value to be displayed in the pivot table. I will be displaying time and representatives in the column and measures displayed as rows..
but in the pivot table, the grand total is shown only for the representatives, its not giving the total for time dimension... I want the total value to be displayed for the year 2005, total representatives.
Note: If i put the time dimension in the second column, i.e, next to representative dimension, the total values gets displayed properly.
Can anyone pls help me in this regard?
Thnx in advance,
April 16, 2005 at 4:23 am
I have solved this problem by setting the "All Level" Property in the dimensions..
Thnx & Regards,
Goms.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply