vgarcia

Thanks Lucian. I have one more question. If i have the previous mdx: select {[Measures].[unit Sales]} on columns, {([Product].[All Products] ) } on rows from Sales I want to show all data, and the values of the dimensions, etc. I want to say that i want to show all data that we would see in the cube. What fields i need to create?

Hi Lucianc, If i have the mdx: select {[Measures].[unit Sales]} on columns, {([Product].[All Products] ) } on rows from Sales How should be the expression of the field? Thanks in advance.