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 |
|
hanavan
Starting Member
25 Posts |
 Posted - 2008-04-14 : 15:44:25
|
| I have some contracts that run from different times:jan 2007 to dec 2007feb 2008 to jan 2009I would look like to get all values between the months,I can create it in the cube browser (see link), but it would like to have it in mdx so it's automaticcalculated. I don't know if it's possible.[url]http://users.telenet.be/hanavan/question.jpg[/url]thx in advance |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-15 : 03:22:43
|
| You may create a calculated member which says CREATE MEMBER CURRENTCUBE.[MEASURES].[Amount for Period] AS {[Measures].[Amount],[Year].[Month].[Jan 2006],[Year].[Month].[Feb 2006]};Note: Include all month you want in the above MDXPrakash.PThe secret to creativity is knowing how to hide your sources! |
 |
|
|
|
|
|
MDX use of range