dbTalk Databases Forums  

MDX for calculating racio on a diferent dimension

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


Discuss MDX for calculating racio on a diferent dimension in the microsoft.public.sqlserver.olap forum.



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

Default MDX for calculating racio on a diferent dimension - 05-10-2004 , 12:42 PM






Hello All,

I'm starting to use Analisys Services, and I'm building a cube for
finantial analisys. My problem is that I must calculate several
financial indicators, for several profit/cost centers based on the
values of a diferent cost center.

What I have is a cost center (7000) for all the company administrative
costs, and I to create financial indicators that are calculated by
dividing the total costs by other values specific to each cost center.

Who can I user MDX to calculate these indicators, specifying that I
have to use the values for one cost center independently of the one I
have selected? Is there any way other than using calculated members
with MDX?

Thanks,

Luís Mendes

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.