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
