| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hi, i try to implement this situation: I have a parameter, defined on year level. 2008: 15% 2010: 17% 2015: 19% For the years between the years, where a number was entered, I want to display the values from the previous year: I expect this: 2008 15% 2009 15% 2010 17% 2011 17% 2012 17% 2013 17% 2014 17% 2015 19% 2016 19% I have tried with ParallelPeriod. But it's correct? Thanks Alot for the answer, Giovanni |
|
#2
|
| no one have a solution? i try this, but i think isn't correct... CREATE MEMBER CURRENTCUBE.[MEASURES].[ValidFrom] AS ([Measures].[Actual Sales Qty]) ; SCOPE ([Month].[Month].&[24]:[Month].[Month].&[27],[MEASURES].[ValidFrom]); THIS = ParallelPeriod ( [Month].[Month].[Month], 1, [Month].[Month].&[25] ) ; END SCOPE; SCOPE ([Month].[Month].&[28]:[Month].[Month].&[35],[MEASURES].[ValidFrom]); THIS = ParallelPeriod ( [Month].[Month].[Month], 1, [Month].[Month].&[26] ) ; END SCOPE; Carnefrisca-at-Work ha scritto: > Hi, i try to implement this situation: > > I have a parameter, defined on year level. > > 2008: 15% > 2010: 17% > 2015: 19% > > For the years between the years, where a number was entered, > I want to display the values from the previous year: > > I expect this: > 2008 15% > 2009 15% > 2010 17% > 2011 17% > 2012 17% > 2013 17% > 2014 17% > 2015 19% > 2016 19% > > I have tried with ParallelPeriod. But it's correct? > > Thanks Alot for the answer, > Giovanni |
![]() |
| Thread Tools | |
| Display Modes | |