dbTalk Databases Forums  

AVERAGE for Quartal

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


Discuss AVERAGE for Quartal in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dubravko Modrusan
 
Posts: n/a

Default AVERAGE for Quartal - 03-14-2005 , 08:06 AM






Hi how to make AVERAGE for quartal?



Reply With Quote
  #2  
Old   
OLAPMonkey
 
Posts: n/a

Default Re: AVERAGE for Quartal - 03-15-2005 , 09:40 AM






Could you elaborate on what your definition of quartal is? For
instance....take a dimension Customer and measure Unit Sales. Do you
mean you'd want to rank the Customers from 1 to N based on the value of
Unit Sales...and then grab the top 25% of customers based on that rank
and call them Quartal 1...the next 25% - 50% and call them Quartal
2...the next 50% - 75% and call them Quartal 3...the next 75% - 100%
and call them Quartal 4.

Then...after quartilzing things...then determine the average for a
given quartal based on the quartal that the current customer is in.
Or said differently...for each customer...compare their value of unit
sales to the average for the quartal that the current customer happens
to be in?

If you want something like I describe...my next question is how big is
your cube...sticking with my example above for customers...how many
customers do you have?

If you I'm not quite on target...can you please elaborate on your
question with an example describing what you wish to achieve?


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.