How to add custom calculations in the MDX designer?

Mar 8, 2013 at 7:54 PM
I’ve tried using the “customer calculations editor” on the demo site’s “MDX Dynamic”, but it doesn’t seem to include the members in the MDX Select statement.
For example:
I’m using the Mdx Dynamic control with rows “Account/Account Type” and Data as “Measures/Financial Reporting/Amount”.
Then I add a custom member: [Measures].[Amount] / 12
Then this is the MDX Query it returns – it doesn’t seem to include the calculated member.
Coordinator
Mar 12, 2013 at 5:37 PM
The Custom calculations are located in the folder [Calculations] tree metadata. Just drag and drop the desired customer calculation member in the data area. It will appear in the MDX query.