Forum Discussion

MStucchi's avatar
MStucchi
New Contributor III
3 years ago

Retrieve member name

Hi all, I'm bit new in developing rules in one stream and I have a simple question. I'm trying to retrieve the accountId member name from a member formula on the account itself. I'm using the b...
  • TonyToniTone's avatar
    3 years ago

    In general, stored calculations use the Data Unit Dimensions with the Cube to drive calculation execution.  Data Unit Dimensions are Entity, Parent, Scenario, Time, and Consolidation, in addition with Cube.  These Dimensions are known at the time of execution of calculations.  Therefore, these Dimensions CAN use api.Pov.xxxx.  All the Account related Dimensions have no concept of api.POV at the time of calculation execution for stored calculations or Business Rules.  For example, a stored calculation can do an If statement such as If api.Pov.Entity.Name.XFEqualsIgnoreCase("EntityA") Then.  

    In order to use api.Pov.Account in stored calculations, you can do it if you wanted to evaluate an Account and Account settings properties of Account members after the Data Unit calculations have executed.  Something like this would be acceptable.  Getting an Account Type of Account Dimension members ( or many of the Settings Properties from the Member Properties tab ).  Api.Pov.Account.MemberId can be used inside the api.Account.GetAccountType function.  

    For Dynamic Calc, there is no concept of a Data Unit in the same manner as stored calculations.  If you have an Account setup as a Formula Type as Dynamic Calc, then api.Pov.Account will work