Problems with ytd values and percentage - Daniel |
09-May-08 07:42:44
|
Hi,
I have a problem with Analysis Services doing YTD for percentage
values.
This is the scenario.
I have one dimenison called Account which consists of different
accounts.
In this dimension I have, as example, 2 accounts: A and B. Since its
quite common for the report users to want to look at the value of A /
B I have created a calculated measure in the Account-dimension which
is defined as:
CREATE MEMBER CURRENTCUBE.[Account].[Account hierarchy].
[All].Calculated_account
AS [Account].[Account hierarchy].&[A]/[Account].[Account
hierarchy].&[B],
VISIBLE = 1;
For any given period this work just fine when I take a look at the
values for the current period.
My problem is that my users want to look att YTD values for the
different accounts but the Calulated_account should be calculated from
the YTD values.
I have created a hierarchy in my time dimensions which contains
different time calculations such as YTD.
Ive been trying to set the solve_order attribute for this but it
doesnt seem to be working here.
Can anyone give me some ideas on how to make this "calculated account"
to be the result of the ytd values and not take ytd of the period
percentage values.
All hints are welcome! |
 |
| |
|
|