Hi all,

Let's say that I have a cube with 3 dimensions, machines, products and measures. Products on rows, measures on columns and machines in context. Now, one machine is able to produce several products and each product can be produced by one machine only. I can create several subsets in the products dimension, one for each machine, or I can create an attribute in products dimension with the producing machine name.

Maybe this is trivial, but, in a cube view, how can I show in rows only the products for a machine selected in context? I am used to create views in MDX, simple ones, but this confuses me. I am open to any ideas.

Any advice would be appreciated.

HI,

I am assuming you want an unsuppressed view otherwise you could just show all and suppress and see only valid rows.

You could use MDX on your rows to generate a list of Products that are linked to a Machine based on the attribute.

Because Machine is in the Context area (different axis to Product) you can use .CurrentMember in MDX on the Products to filter by e.g.

Filter(DESCENDANTS([Products].[Products].[Total Products], 99, LEAVES),[Products].[Products].CurrentMember.Properties("Machine")=[Machine].[Machine].CurrentMember.Name)

Hi all,

Let's say that I have a cube with 3 dimensions, machines, products and measures. Products on rows, measures on columns and machines in context. Now, one machine is able to produce several products and each product can be produced by one machine only. I can create several subsets in the products dimension, one for each machine, or I can create an attribute in products dimension with the producing machine name.

Maybe this is trivial, but, in a cube view, how can I show in rows only the products for a machine selected in context? I am used to create views in MDX, simple ones, but this confuses me. I am open to any ideas.

Any advice would be appreciated.

Hi George,

The solution worked as expected. That's what I was looking for.

Thanks a lot.

HI,

I am assuming you want an unsuppressed view otherwise you could just show all and suppress and see only valid rows.

You could use MDX on your rows to generate a list of Products that are linked to a Machine based on the attribute.

Because Machine is in the Context area (different axis to Product) you can use .CurrentMember in MDX on the Products to filter by e.g.

Filter(DESCENDANTS([Products].[Products].[Total Products], 99, LEAVES),[Products].[Products].CurrentMember.Properties("Machine")=[Machine].[Machine].CurrentMember.Name)

Hi all,

Let's say that I have a cube with 3 dimensions, machines, products and measures. Products on rows, measures on columns and machines in context. Now, one machine is able to produce several products and each product can be produced by one machine only. I can create several subsets in the products dimension, one for each machine, or I can create an attribute in products dimension with the producing machine name.

Maybe this is trivial, but, in a cube view, how can I show in rows only the products for a machine selected in context? I am used to create views in MDX, simple ones, but this confuses me. I am open to any ideas.

Any advice would be appreciated.