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
Solved
Text Values in Cubeview
Looking for help to display Text data in a cube view. I'm using the member filter below which works for every account type EXCEPT DynamicCalc. Account Type set under Settings in the Member Proper...
From what I can see, the engine will execute Dynamic Calcs in the usual order (i.e. Account first, then Flow, then UD1, etc etc). As soon as it finds a Stored Item, even one containing only comments, it executes that and stops.
In your case, you have a formula in the Account that probably returns a number; that is executed first, and nothing else gets a chance. Since the view is an annotation, that means you get a NoData cell (as documented in the Design guide). Your UD8 formula is never executed.
If you have a Dynamic account formula, you have to place any support for Annotation views in that formula.
JackLacava
OneStream Employee
OneStream EmployeeFrom what I can see, the engine will execute Dynamic Calcs in the usual order (i.e. Account first, then Flow, then UD1, etc etc). As soon as it finds a Stored Item, even one containing only comments, it executes that and stops.
In your case, you have a formula in the Account that probably returns a number; that is executed first, and nothing else gets a chance. Since the view is an annotation, that means you get a NoData cell (as documented in the Design guide). Your UD8 formula is never executed.
If you have a Dynamic account formula, you have to place any support for Annotation views in that formula.
Thank you. I added to the account formula like you said and it is now working.
Hello JenJessel.
How are you?
I have the same issue, can you share with me how did you solve it? please
I have the following:Return api.Data.GetDataCell("A#TotalSales2 - A#TotalPrimeCost2")
thank you
- I added the following code to the end of my formula as I was trying to pull back the text data in Text3 as well as the formula I had before code.Dim accountId As Integer = api.Pov.account.MemberIdDim accountText3 As String = api.account.Text(accountId,3).ToStringReturn accountText3
