Forum Discussion

Oscar's avatar
Oscar
Contributor
30 days ago

Show formula of Account type DynamicCalc

Hello ...  We are trying to output the formula for Accounts of type DynamicCalc in a cube using an U8 member named U8#AccountFormula. In this member we have defined the following: Return api.Acco...
annotations
Reports
rhankey's avatar
rhankey
Contributor II
30 days ago

Part of the problem is that you are passing in ScenarioId rather than the ScenarioTypeId.  Given it appears you are seeking the formula for POV Scenario & POV Time, you could simply remove both those optional pass-in parameters (only pass-in the AccountId).  Otherwise replace your second pass-in param with api.Pov.ScenarioTypeId.

Having said that, I just tried a quick test, and the function did not return the member formula where FormulaType=DynamicCalc, until I set AccountType to something other than DynamicCalc.  I tried a couple alternate ways via the api, and getting the same results.  Not sure I've run into this before.