MDX subset in TI based on cube values?

[tsw]

Hi,

I'm having trouble creating a dynamic subset in TI based on evaluating a cube's value.
It works great when I create the view interactively... but if I try to use the same expression to create a subset in TI with SubsetCreatebyMDX (in order to call ViewZeroOut() ), it fails with msg:
Error: Data procedure line (71): Could not create dynamic subset:
expression:
{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [RowDimension] )}, 0)}, [Cube].([Cube Measure].[Measure C]) > 0)}

[Measure C] is a TM1 rule evaluated from comparing Measure B and another dimension's attribute based on date calculations.

Just wondering if anyone has successfully done this in TI ?

Thanks in advance

[EvgenyT]

Error: Data procedure line (71): Could not create dynamic subset:
expression:
{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [RowDimension] )}, 0)}, [Cube].([Cube Measure].[Measure C]) > 0)}

This error suggests to me that either syntax or some of the variables are wrong

Cube.. is it the real name of the cube you are using???
RowDimension.. is it the real name of the dimension you are using???


Can you please post the real syntax you are using in your TI process?

It should be pretty straightforward.


ET

[panyuleo]

Hi TSW,

[Measure C] is a TM1 rule evaluated from comparing Measure B and another dimension's attribute based on date calculations.

I don't think you should zero out the view which had rules being applied to it.


Regards,
Jay