Load inLine table with expressions for dimensions

l_denivelle — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Load inLine table with expressions for dimensions

swuehl — Mon, 04 Apr 2016 14:28:59 GMT

What about

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

edit:

l_denivelle — Mon, 04 Apr 2016 15:01:04 GMT

Nice !

It works Thank you.