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 |
|
narayanac
Starting Member
18 Posts |
 Posted - 2005-12-26 : 04:12:29
|
| Hi! I have a problem in my MDX Query. I have a sample MDX query as follows:WITH SET [ABC] AS '{ DESCENDANTS( ANCESTOR([Time].[1997].[Q1], YEAR) ,1) }' SELECT { [ABC] } ON COLUMNS FROM [TRAINED CUBE]The result of the above Query results me Q1,Q2,Q3,and Q4 Time dimension value of Unit Sales. Till now it is fine. The objective of my Query is I needed to multiply the Q1 UnitSales value with 2, Q2 with 3, Q3 with some 10 and Q4 with some other value. For this what is an MDX Query or the Alternative way to acheive it. I am thinking of using Calculated Cells in MDX using With statement. Will it be the correct approach Otherwise, please suggest me for the best way. Thanks for your support. Please also give me an example of Calculated Cells using WITH. I am facing problem while implementing in my Query.ThanksNarayana |
|
|
|
|
|
With Cell Calculation in MDX