The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
MStucchi
3 years agoNew Contributor III
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...
- 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
TonyToniTone
OneStream Employee
3 years agoHappy to hear that the answer is clear and helps.
The compiler checks for syntax accuracy. However, it does not check the context in which you use the function. That is up to the rule writer and having the foundational knowledge on how/when to use these functions.
Related Content
- 26 days ago