You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ASO Dynamic Calc Member MDX Conversion

Accepted answer
34
Views
2
Comments

Summary:

We are in the process of setting up an ASO cube. I have 1 account that doesn't seem to work. Currently in the BSO cube I have the following:

if (@ismbr("Jan"));

   "Net Earnings";

elseif (@ismbr("Feb"));

   "Net Earnings"->"Jan" + "Net Earnings" -> "Feb";

endif;

In the ASO cube I have the following:

IIF([Period].CurrentMember.[Jan], 

SUM({[Period].[Jan]},[Account].[Net Earnings]))

In short, all I want it to do is when the period is Jan, pull the value for Net Earnings for Jan. Then I can write one for Feb to be both Jan + Feb. It's a balance sheet account which is why the flow is kind of off. Right now it says it doesn't like the , in line 1. I tried following the Oracle formula guides and kept getting stuck.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!