ASO Dynamic Calc Member MDX Conversion
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.
Tagged:
0