dbTalk Databases Forums  

Problem Group

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem Group in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dario Concilio
 
Posts: n/a

Default Problem Group - 11-24-2004 , 11:30 AM






I'm new AS User!

I have a cube that have some measure.
I have some dimension but I need a particulary measure.
Example:

Vert. Dimension Horiz. Dimension
Agent Code|Province|Cat.| Period (Year,Quarter,Month)

Measure
Amount|Quantity|

I have moreover
Number of Customer that have Invoiced
and
Number of Invoice

My problem is that my Fact Table is a Sales Invoice Line!

I set Number of Customer that have Invoice as Bill-to Customer Code with
aggregate COUNT.
I have a numer of row and not Number of Customer.
HELP!
How can I do create a calculated member that provide this information? Do
you have some example (MDX lng)?

Thank you very much.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.