10-26-2023 09:53 AM - edited 10-26-2023 10:55 AM
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
Solved! Go to Solution.
10-30-2023 06:27 AM
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.
10-27-2023 05:36 AM
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.
10-30-2023 06:27 AM
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.