Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

PLEASE HELP ME !!! MDX COUNT DISTINCT Expand / Collapse
Author
Message
Posted Sunday, July 28, 2013 8:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:23 AM
Points: 63, Visits: 258
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 ????
Post #1478370
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse