MDX Syntax
Posted: Tue Mar 29, 2016 4:55 pm
Hello everyone
I have created a subset using SubsetCreateByMdx - I now want to change the parent selection to run from the Variable on the Process ( instead of being hard coded)
So currently the above works fine, however when i change the [200] to [Pcc] it stops working. (Pcc is the parameter for the cost centre parent which is also set to "200")
I get the following error - "PCU" : object not found expression: - i assume this is due to the parameter automatically having quotations attached.
Can anyone help with the syntax for this please?
Thanks for all your help
Jaimie
I have created a subset using SubsetCreateByMdx - I now want to change the parent selection to run from the Variable on the Process ( instead of being hard coded)
Code: Select all
SubsetCreatebyMDX('CostCDetailReport', '{TM1SORT( {TM1FILTERBYLEVEL( {DESCENDANTS([r_Cost_Centre].[200] )}, 0)}, ASC)} ' );Code: Select all
SubsetCreatebyMDX('CostCDetailReport', '{TM1SORT( {TM1FILTERBYLEVEL( {DESCENDANTS([r_Cost_Centre].[Pcc] )}, 0)}, ASC)} ' );I get the following error - "PCU" : object not found expression: - i assume this is due to the parameter automatically having quotations attached.
Can anyone help with the syntax for this please?
Thanks for all your help
Jaimie