Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Sum within and avg across time dimnsn and

Author  Topic 

satishpc
Starting Member

2 Posts

Posted - 2003-02-18 : 00:57:45
Hi,

I have a cube that has product, branch and time dimension. The time dimension consists of year, quarter and month. I have a measure call ec (economic capital). I would like to sum this measure for each month and average it across the month. Is it possible to create this type of measure ? also, can I get a list of months selected by the user ? I need to use this for one of the calculations of a calculated dimension.

Satish


<edit> moved to proper forum </edit>

Edited by - robvolk on 02/18/2003 01:15:26
   

- Advertisement -