| T O P I C R E V I E W |
| n/a |
Posted - 11/03/2004 : 18:34:51
Hi All,
Is it possible to create a calculated field based on two memebers of a dimension? I have a report that shows two distinct memebers of a dimension as columns and I then want to calc (dimension.memberA.value / dimension.memberB.value)??
Below is the MDX of my report so far:
Select non empty HIERARCHIZE(DISTINCT({
[CalendarYear].[All CalendarYear].[2003].[Quarter 3 2003].[September 2003]})) on rows,
non empty HIERARCHIZE(DISTINCT({
[COA].&[Current Assets],
[COA].&[Current Liabs]})) on columns
From [Finance]
Where ([Measures].[Actual Amount])
Cheers
Ryan |
| 2 L A T E S T R E P L I E S (Newest First) |
| n/a |
Posted - 11/04/2004 : 13:08:26
Thanks Igor that worked a treat!!
Cheers
Ryan |
| admin |
Posted - 11/03/2004 : 20:01:49
Here is an example for Foodmart 2000 - Budget cube. The calculated measure can have a formula that combines values from two members: Marketing and lease. The MDX would look like this:
([Account].[All Account].[Net Income].[Total Expense].[Marketing],[Measures].[Amount]) +
([Account].[All Account].[Net Income].[Total Expense].[Lease],[Measures].[Amount]) |
Report Portal
