TM1 Forum

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!

What happens when you input the MDX into an expression window and run it manually?

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.

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:
cheers, Mark

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.

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!