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 |
|
PavelUK123
Starting Member
1 Post |
 Posted - 2010-01-14 : 11:27:45
|
Hi,I have simple problem.I created following MDX script:SUM ( { [Time].[Year Name].PrevMember, [Time].[Year Name].CurrentMember }, [Measures].[Quantity])The script I want should count current state for time dimension.But it gave me wrong numbers in result.I am sending picture of cube for better understanding.Columns marked in green rectangule are counted good, but colums marked with brown are wrong.In Cal 2005 didnt count state of Cal 2002 because it is counting state from Cal 2003, where are no data.Cal 2009 didnt count good because it didnt add -4 to currentstate from Cal 2008.Can anyone help me with optimizing my MDX script, please ?Picture: |
|
|
|
|
|
Help with MDX measure script!