TM1 Forum

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,

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

Use temporary subsets and you will have a lot less headaches.