Hello!
In my account dimension I have a parent with Stored Property (Because my client wants to record data in parent). Then I have childs with Dynamic Calc, (I have a formula to obtain a value).
With these way is possible that parent don't have total of child. For my client is OK.
I add an example:
This example works fine for me.
My issue appears with I have ONLY one child dynamic. In that way. Parent is converted to dynamic and I can't to record data.
If create a new dummy child member I can fix my issue but If user drill-down in that parent would see that dummy account...so I don't think it was a good solution. In my dimension I don't have security to "hide" that account.
Do you know another solution??
My goal should be something like this:
Thanks!