Hi experts,
I need your help.
I have a cube with 3 dimensions
- DimProduct with 3 hierarchies
- Category
- Sub Category
- Product
- DimClients with 1 hierarchy
- DimDate with 1 hierarchy
And 1 Measure : Sales Amount
I want to display for a rapport 2 news measures:
- The number of product saled by Year by Clients
- The number Total of product
Category, SubCategory, Product, Date, Client, SalesAmount, Number Product saled, Number Total Product
Please can U help me to write this mdx query ????