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.
| Author |
Topic |
|
blakmk
Starting Member
45 Posts |
 Posted - 2008-12-30 : 05:51:39
|
| I have a calculated field that works on a day by day basis; however this doesn’t seem to work when I use the same calculated field at a higher level than a day (ie week or month). Is there a way in SSAS that I can take the average of the daily values over a month?Im using Sql and SSAS 2005. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 06:17:03
|
| seems like what you need is to aggregate the month values. may be use AVG() over the range of month |
 |
|
|
blakmk
Starting Member
45 Posts |
Posted - 2008-12-30 : 07:19:42
|
| thanks for the reply. Can you give me any examples of how to do this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 11:56:47
|
| http://www.databasejournal.com/features/mssql/article.php/3404601/MDX-Essentials-Numeric-Functions-Introduction-to-the-AVG-Function.htmgive the set as month values |
|
|
|
|
|
|
SSAS date dimension average issues