dbTalk Databases Forums  

Urgent! Custome rollup for a level for some of the members

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Urgent! Custome rollup for a level for some of the members in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Prasanna
 
Posts: n/a

Default Urgent! Custome rollup for a level for some of the members - 09-23-2004 , 01:27 AM






Hi,

Could you please help me understand to construct a MDX on the problem statement

Let us assume the following levels and members in an hierarchy.

Quote:
a
b
c
d
e
and members at level "d" assume values
string1 (Brand1)
string2 (brand2)
string3 (Brand3)
string4 (Brand4)
string5 (Brand5)
string6. (Brand6)

We would like to represent members at
this level "d" as follows:

Basically i want to club the values in Brand1 and Brand2 and display the data

Is it possible using Custome rollup at level 'D' in cube.
How can this be achieved

Is there any solutions

Regards
Prasanna


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.