dbTalk Databases Forums  

Different calculations in the same dimension

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


Discuss Different calculations in the same dimension in the microsoft.public.sqlserver.olap forum.



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

Default Different calculations in the same dimension - 02-23-2006 , 08:35 AM






Hi There!
I have a little problem.
If it is possible to define different kind of calculations
i the same dimension. What I mean is for
example: I have parent-child hierarchy in some dimension.
I defined Calculationin percent but
what is more important for me I'd like to have
on last level (one leaf) not in procent but avg aggregations.

Is it possible?

Regards,
Saidor




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

Default RE: Different calculations in the same dimension - 02-23-2006 , 10:57 AM






It may not be the best solution. I will use calculated member and iif()
function to branch the calculations on different levels.

"sajdor" wrote:

Quote:
Hi There!
I have a little problem.
If it is possible to define different kind of calculations
i the same dimension. What I mean is for
example: I have parent-child hierarchy in some dimension.
I defined Calculationin percent but
what is more important for me I'd like to have
on last level (one leaf) not in procent but avg aggregations.

Is it possible?

Regards,
Saidor





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.