dbTalk Databases Forums  

How to insert a calculation of %

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


Discuss How to insert a calculation of % in the microsoft.public.sqlserver.olap forum.



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

Default How to insert a calculation of % - 09-24-2004 , 02:23 AM






Hi,

I don't know how to insert a calculation that
gives back the percentage of the value of a measures
regarding to its advanced level.

Help me, please!!



Reply With Quote
  #2  
Old   
Hari
 
Posts: n/a

Default RE: How to insert a calculation of % - 09-24-2004 , 04:27 AM






What you mean by advanced level. Are you talking about the parent.
Please elaborate

"Mathasu" wrote:

Quote:
Hi,

I don't know how to insert a calculation that
gives back the percentage of the value of a measures
regarding to its advanced level.

Help me, please!!




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

Default Re: How to insert a calculation of % - 09-24-2004 , 05:05 AM



Yes, I talk about the parent.
Sorry but I've an italian boy.
I don't write english very well.

"Hari" <Hari (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:EB324EBD-659F-4C84-8B05-D6A5544B97C9 (AT) microsoft (DOT) com...
Quote:
What you mean by advanced level. Are you talking about the parent.
Please elaborate

"Mathasu" wrote:

Hi,

I don't know how to insert a calculation that
gives back the percentage of the value of a measures
regarding to its advanced level.

Help me, please!!






Reply With Quote
  #4  
Old   
Hari
 
Posts: n/a

Default Re: How to insert a calculation of % - 09-24-2004 , 05:17 AM



You can try this.

WITH
MEMBER [Measures].[%Contribution] AS '([Measures].[<measure>],
[<Dimension>].CurrentMember) / ([Measures].[<measure>],
[<Dimension>].CurrentMember.Parent)'

I hope this is what you wanted

"Mathasu" wrote:

Quote:
Yes, I talk about the parent.
Sorry but I've an italian boy.
I don't write english very well.

"Hari" <Hari (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:EB324EBD-659F-4C84-8B05-D6A5544B97C9 (AT) microsoft (DOT) com...
What you mean by advanced level. Are you talking about the parent.
Please elaborate

"Mathasu" wrote:

Hi,

I don't know how to insert a calculation that
gives back the percentage of the value of a measures
regarding to its advanced level.

Help me, please!!







Reply With Quote
  #5  
Old   
Mathasu
 
Posts: n/a

Default Re: How to insert a calculation of % - 09-24-2004 , 07:27 AM



Thank you very much!
You've resolved my problem!



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.