category...

[binjovi]

Hi Guys,
I have a small prob but i couldnt figure out how to do this
lets say you are viewing a dimension diagram ,In this i need to do some summarize information. The diagram goes this way
Q
X
A Y
Z
P

Y
B Z Q
U P

Dimension A contains category Q,X,Y,Z,P and I have created a Manual Category B where i dragged Y,Z and a another Manual Category where Q,P is Dragged in.

My prob is here i want to get the values of Category B this way
I want Y,Z and U( which is the summarize value of Q and P). So that the values poped up are

Y,Z AND SUM(Q,P)
pLEASE HELP ME IN THIS ASAP.

I tried to Cloak U, First things it doesnt allow so easily and secondly if i apply any feature of cloak or supress etc.. its applying for the top ones also i mean to say the P,Q of Dimension A also.
Thanks in advance and i really appreciate for the helps you guys support.

 

[einyel]

Try to create an special category by creating it via drag&drop from parent dimension and this new category grouping the levels you need.

Hope this helps

Einyel
Functional&Technical Cognos Consultant