To make it simple:
I have 2 dimensions: dim1 and dim2
I also have a settings cube1 containing just 2 dimensions:
- dim1
- cube1_measure dimensions
cube1_measure dimension contains just one element: value
In dim2 I have attribute attr_dim1_elm_name which contains dim1 element name related to dim2 element
I need to build an MDX statement to select all elements from dim2 which satisfy the condition:
Code: Select all
{FILTER(
{TM1SUBSETALL( [dim2] )},
[cube1].( [dim2].[attr_dim1_elm_name], [cub1_measure].[value] ) > 0
)}
In that case I would need some MDX like:
Code: Select all
{FILTER(
{TM1SUBSETALL( [dim2] )},
[cube1].( [dim1].[ [dim2].[attr_dim1_elm_name] ], [cube1_measure].[value] ) > 0
)}