Planning Analytics

Hi Glen, Looks like you are providing static text to drive your report. You need a formula to evaluate the contents of C15 and add it into the text e.g. ="EXCEPT(DISTINCT({[CostCenter].[CostCenter].["&C15&"],DESCENDANTS([CostCenter].[CostCenter].[Claims ...

To give a little more clarity to my request I have an MDX statement 'EXCEPT(DISTINCT({[CostCenter].[CostCenter].[&C15&],DESCENDANTS([CostCenter].[CostCenter].[Claims Legal] , 99 , LEAVES)}) , {[CostCenter].[CostCenter].[&C15&]}) in a dynamic report, that ...

Hi Stuart, A demo will be very helpful. Are you planning one? Thanks, Luther. ------------------------------ Luther Rapaka ------------------------------

Updated TI processes can be found in the following GITHUB repository. https://github.com/StuartStephenKing/PA-Workflow I've added a fix for the issue with assigning and removing nodes using existing groups (the Group security mode). ------------------------------ ...

I am working on a universal report that has a subset in the context section, but also has virtual subset in the rows that has the leaf level elements in it. I am trying to get the report to show only the leaf elements for a specific consolidated element ...

Etags are first and foremost meant to identify individual versions of an entity and, even more importantly, the fact that it changed or not. If you want to study etags in a bit more detail have a look at the protocol specification for OData, the standard ...