dbTalk Databases Forums  

Difference instead of total?

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


Discuss Difference instead of total? in the microsoft.public.sqlserver.olap forum.



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

Default Difference instead of total? - 06-04-2004 , 04:49 AM






Greetings, it's me again.

My next problem.. I have a dimension "Type", which can either be 0 or 1. I
put
it on columns, and I get:

Quote:
0 | 1 | Total
Now, what I need is to have "Difference" instead of "Total" - e.g. have
every
measure present show a difference between Type 0 and Type 1 in Totals
column.

Is that possible in any easy way?

Thank you again.




Reply With Quote
  #2  
Old   
Martin Mason
 
Posts: n/a

Default Re: Difference instead of total? - 06-05-2004 , 11:37 PM






You can use unary operators to specify that the All Member will be the
difference of the two members. Or you can create a calculated member.

"QQ" <qq.spam[@]takas.lt> wrote

Quote:
Greetings, it's me again.

My next problem.. I have a dimension "Type", which can either be 0 or 1. I
put
it on columns, and I get:

| 0 | 1 | Total

Now, what I need is to have "Difference" instead of "Total" - e.g. have
every
measure present show a difference between Type 0 and Type 1 in Totals
column.

Is that possible in any easy way?

Thank you again.





Reply With Quote
  #3  
Old   
QQ
 
Posts: n/a

Default Re: Difference instead of total? - 06-07-2004 , 06:18 AM



"Martin Mason" <martin.mason (AT) earthlink (DOT) net> wrote in
news:OeoPs$3SEHA.2544 (AT) TK2MSFTNGP10 (DOT) phx.gbl:

Quote:
You can use unary operators to specify that the All Member will be the
difference of the two members. Or you can create a calculated member.
Where can I do that?

I wouldn't really like to do it with calculated members, as it would
require lots of them (lots of measures in the table)


Reply With Quote
  #4  
Old   
Martin Mason
 
Posts: n/a

Default Re: Difference instead of total? - 06-07-2004 , 09:04 PM



Create a new column in the table (or view) that is the source for the
dimension. For the row in the table that corresponds to the Type 1 member,
enter a '-' in the newly added column. In AS Manager, edit the dimension.
On the Advanced tab for the properties of the level, set the Unary Operators
property to the newly created column.

HTH,
Martin

"QQ" <qq-spam (AT) mail (DOT) lt> wrote

Quote:
"Martin Mason" <martin.mason (AT) earthlink (DOT) net> wrote in
news:OeoPs$3SEHA.2544 (AT) TK2MSFTNGP10 (DOT) phx.gbl:

You can use unary operators to specify that the All Member will be the
difference of the two members. Or you can create a calculated member.

Where can I do that?

I wouldn't really like to do it with calculated members, as it would
require lots of them (lots of measures in the table)



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.