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
Dynamic Calc overrides the is 'Invalid' Cell Status?
Hi
I am using a simple dynamic calc to hide an derived data. See below:
The code itself works fine. However, in cases where the cell status was previously 'Invalid=True' is no showing as 'Invalid=False' which is impacting the suppress invalid rows setting on my cube view.
Any thoughts? Or does this sound like a bug in the system?
Mark
Hi Jack
Thanks for this. Unfortunately that won't work as I'm using the UD8 calcs to pull attribute information across all accounts on the cube view.
However, I did find a solution. On the columns where I used the UD8 dynamic cals I set the "Use To Determine Row Suppression" setting to False.
2 Replies
- JackLacava
OneStream Employee
Happy to be proven wrong, but I think the result of dynamic calcs is never invalid. Even setting up a datacell object from scratch, other properties make it through but IsInvalid always reverts to False.
As workaround, you can add a .Remove(YourCalcAccount) clause to the member expansion in the CubeView, or you can suppress NoData as well as Invalid.
Hi Jack
Thanks for this. Unfortunately that won't work as I'm using the UD8 calcs to pull attribute information across all accounts on the cube view.
However, I did find a solution. On the columns where I used the UD8 dynamic cals I set the "Use To Determine Row Suppression" setting to False.
