ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

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])

ReportPortal