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 |
|
muntu
Starting Member
11 Posts |
 Posted - 2005-03-18 : 08:17:35
|
| Hi I have a sales for a certain product for the last two years. These sales are rolled up to weekly level and monthly level. I am using Proclarity as the front end for my cubes. When I select a week this year and the same week last year. I want to have one extra field which will be the growth between these 2 weeks. How can I achieve this? |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-18 : 12:11:18
|
| create a calculated member in the cube.In ProClarity you can create calculations, and there is a wizard that might do what you are trying to achieve.You can then (in ProClarity) view the MDX that it created and copy that into the cube.Or You just do something like this:(ParallelPeriod(Year),[Measures].[Sales])rockmoose |
 |
|
|
muntu
Starting Member
11 Posts |
Posted - 2005-03-22 : 03:49:55
|
| Thanks rockmoose for your response.I have tried that the problem I experience with that is. I get last years weekly figure, then the growth field which would be incoorect and this year weekly figure with another growth field. I want to see last year weekly figure and this year weekly figure then the growth field. I will eventually rollup the figures to monthly.I hope it clear now. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-22 : 11:46:41
|
| You should have the following 3 measures:[Measures].[Sales] -- this is the regular measure(ParallelPeriod(Year),[Measures].[Sales]) -- this is the Sales for the parallell period the year before (calculated memmber)([Measures].[Sales]-(ParallelPeriod(Year),[Measures].[Sales]))/(ParallelPeriod(Year),[Measures].[Sales]) -- the growth (calculated memmber)Any help ???rockmoose |
|
|
|
muntu
Starting Member
11 Posts |
Posted - 2005-03-24 : 04:12:36
|
| Thanks It worked with some conditional statements. |
|
|
|
|
|
|
Growth in cubes