Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX to calculate number of products sold

Status
Not open for further replies.
kdemulder

kdemulder

IS-IT--Management
Mar 10, 2004
33
BE
Hi there,
I am trying to add a calculation to the cube that shows how many products were sold. This means that I actually have to count the members of a dimension that gave > 0 for a certain measure (amount sold). Any ideas?

Do you guys recommend any books covering MDX btw, it seems I'm getting more and more questions that require more prfound knowledge of MDX...
 
Sort by date Sort by votes
Sorry don't have the answer to your calc but the best MDX book out is George Spoffords "
MDX Solutions: With Microsoft SQL Server Analysis Services"

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
137
Benedito Almeida
Benedito Almeida
Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
155
Komal0735
Komal0735
burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
165
burakcan
burakcan
tcstl1
  • Locked
  • Question
Migrating SSAS to new server
Replies
0
Views
142
tcstl1
tcstl1
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
172
JP_Quinn
JP_Quinn

Part and Inventory Search

Sponsor

Back
Top