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 |