Hi ,
I am trying to create a subsetcreatebymdx with below code
vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Price Range] )}, 0)}';
SubsetcreatebyMdx(subsetname,vmdx,0);
But its giving me an error unable to register the subset .
I want to use it for zero out in prolog .
But then I did a similar
SUBSETMDXSET(vDimension,vSourceSubset, vMdx );
SUBSETMDXSET( vDimension,vSourceSubset,'' );
And then did a ascii output and it wrote the values for price range n elements,
Why is my SubsetcreatebyMdx having issues here and can i not use it or when should i use it .
Thanks,
Subsetcreatebymdx
-
- Posts: 124
- Joined: Wed Nov 26, 2014 8:32 pm
- OLAP Product: IBM TM1, Planning Analytics
- Version: PA 2.0.5
- Excel Version: 2016
Re: Subsetcreatebymdx
I think i got it ,
I have to destroy the subset and then use subssetcreatemdx .
Which one is better if i have to just use for zerout .
subsetcreatebymdx or SUBSETMDXSET
I have to destroy the subset and then use subssetcreatemdx .
Which one is better if i have to just use for zerout .
subsetcreatebymdx or SUBSETMDXSET
-
- MVP
- Posts: 3113
- 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: Subsetcreatebymdx
Use temporary subsets and you will have a lot less headaches.
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