Filter a string cube data in MDX
Posted: Wed Sep 06, 2017 3:51 pm
Hi,
I have a cube with 3 dimentions, and want to built an active form with dynamic MDX.
CubeA: User, Product, Measure
I set a MDX in dimension User,but no element is showed.
{Filter( {TM1SUBSETALL( [User] )},[CubeA].([Measure].[Department])="DepA")}
If I set a specific Product, the MDX will have result, the changed MDX like this:
{Filter( {TM1SUBSETALL( [User] )},[CubeA].( [Product].[p1], [Measure].[Department])="DepA")}
but there are so many products, and it's impossible for me to specify all the products in MDX, and the syntax is not allowed to write all the products.
Can anybody help me solve this problem? Many thanks.
wendyWang
I have a cube with 3 dimentions, and want to built an active form with dynamic MDX.
CubeA: User, Product, Measure
I set a MDX in dimension User,but no element is showed.
{Filter( {TM1SUBSETALL( [User] )},[CubeA].([Measure].[Department])="DepA")}
If I set a specific Product, the MDX will have result, the changed MDX like this:
{Filter( {TM1SUBSETALL( [User] )},[CubeA].( [Product].[p1], [Measure].[Department])="DepA")}
but there are so many products, and it's impossible for me to specify all the products in MDX, and the syntax is not allowed to write all the products.
Can anybody help me solve this problem? Many thanks.
wendyWang