Page 1 of 1
Dynamic Subset
Posted: Tue Jul 17, 2018 4:05 pm
by lax9
Hi All,
Getting the below error while running TI:
Error: Epilog procedure line (412): Could not create dynamic subset:
expression:
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (Cat Sales Inc) on LM Books] }, ALL, RECURSIVE ) },0 )}
Please let me know how to resolve this?
Thank you!
Re: Dynamic Subset
Posted: Tue Jul 17, 2018 4:37 pm
by Edward Stuart
What happens when you input the MDX into an expression window and run it manually?
Re: Dynamic Subset
Posted: Tue Jul 17, 2018 8:47 pm
by Wim Gielis
For me it works when I change the dimension name and the (consolidated) element name.
As Edward asked for, what happens if you do this in the Subset Editor of the dimension 'Account PCR' ?
Does the consolidated element have level 0 descendants ? Related to this, what happens if you use the undocumented argument in the function 'SubsetCreateByMDX' whereby adding the dimension name allows the subset to be empty ?
If all of this does not work, please provide a screenshot of this Subset Editor with the expression, where the dimension name and element name are clearly visible.
Re: Dynamic Subset
Posted: Wed Jul 18, 2018 9:15 am
by Mark RMBC
I would say the problem is with the naming of the element, the parentheses in the name, i.e.
(Cat Sales Inc
) are causing the mdx to break.
Can you try the following and see if it works:
Code: Select all
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {StrToMember("[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (Cat Sales Inc) on LM Books]") }, ALL, RECURSIVE ) },0 )}
cheers, Mark
Re: Dynamic Subset
Posted: Wed Jul 18, 2018 11:18 am
by Wim Gielis
Mark RMBC wrote: ↑Wed Jul 18, 2018 9:15 am
I would say the problem is with the naming of the element, the parentheses in the name, i.e.
(Cat Sales Inc
) are causing the mdx to break.
Can you try the following and see if it works:
Code: Select all
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {StrToMember("[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (Cat Sales Inc) on LM Books]") }, ALL, RECURSIVE ) },0 )}
cheers, Mark
Hi Mark,
In PA 2.0.5 I cannot reproduce it. It works as expected.
- 01.png (17.6 KiB) Viewed 3257 times
Re: Dynamic Subset
Posted: Wed Jul 18, 2018 12:08 pm
by Mark RMBC
Hi Wim,
in 10.1 I was getting an empty subset, but when I used StrtoMember or used the original mdx but without the name containing parentheses it returned the correct elements. I say was because I just tested it again and now it appears to be working!
I might be going mad!