Load inLine table with expressions for dimensions

[l_denivelle]

Hi

I would like to create a specific dimension in a graphic table.

Those dimensions are :

- Year(Today())

- Year(Today())-1

- 'Objectif '&Year(Today())

- 'Objectif '&Year(Today())-1

I tried to create a valueList : =ValueList(year(today()),year(today())-1,'Objectif '&Year(Today()),'Objectif '&Year(Today())-1)

It didn't work. (I tried to create a variable with LET myvariable = 'Objectif '&Year(Today()) and put it into the ValueList it didn't work)

So I would like to know if it would work with a Load InLine table :

_Dimensions_Objectif:

LOAD * Inline [

    _Dimensions_ObjID, _Dimensions_Obj

    1,Year(Today()),

    2,Year(Today())-1,

    3,'Objectif '&Year(Today()),

    4,'Objectif '&Year(Today())-1

];

Then I have some difficulties to put my _Dimensions_Obj in my Dimension Table (See attachment).

I also tried to put it this way $(=_Dimensions_Obj), it didn't work.

If you have any other solution I'll be grateful.

Thank you

[swuehl · Accepted solution]

What about

=ValueList('$(=year(today()))','$(=year(today())-1)','$(='Objectif '&Year(Today()))','$(='Objectif '&(Year(Today())-1))' )

edit:

=ValueList('2016','2015','','' )	1
	1
2016	1
2015	1
Objectif 2016	1
Objectif 2015	1

[l_denivelle]

Nice !

It works Thank you.