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!
Dynamic Subset
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: Dynamic Subset
What happens when you input the MDX into an expression window and run it manually?
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dynamic Subset
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.
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.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Dynamic Subset
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
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 )}
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dynamic Subset
Hi 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:
cheers, MarkCode: Select all
{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {StrToMember("[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (Cat Sales Inc) on LM Books]") }, ALL, RECURSIVE ) },0 )}
In PA 2.0.5 I cannot reproduce it. It works as expected.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Dynamic Subset
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!
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!