MDX question: how to find last set value "valid from"

This is a discussion on MDX question: how to find last set value "valid from" within the sqlserver-olap forums in Data Warehousing category; 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...

Go Back   Database Forum > Data Warehousing > sqlserver-olap

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-27-2008, 11:13 AM
Default MDX question: how to find last set value "valid from"

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
Reply With Quote
  #2  
Old 09-02-2008, 12:02 PM
Default Re: MDX question: how to find last set value "valid from"

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



Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:56 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.