Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a straight table, Dimension auftrag + positionsnummer
I have several date - filters
In my fact table I have joined several fields to make if-statements in my straight table
I Need if-statements because in the same table I will have some TEXT-Fields (like Lieferart) so AGGR-functions doesn't work
In the table I have an Expression Versanddatum with following if Statement:
/* 20) Year and Month */
if (Isl_YearMonth <= (Year&Month), Versanddatum,
/* 21) Year and Week */
if (Isl_YearWeek <= (Year&Week), Versanddatum,
/* 22) Year and DayShortName */
if (Isl_YearWeekdayShortName <= (Year&DayShortName), Versanddatum,
/* 23) Year and Day */
if (Isl_YearMonthDay <= (Year&Day), Versanddatum,
/* 24) Year */
if (Isl_Year <= (Year), Versanddatum
)))))
the = part functions the < part not
I hope someone can explain me why or why on?
Are such Statements possible at All?
Is there an other solution?
Thanks in advance
Regards
Court
It didn't work because you tried to use a numerical operator for string-values. Instead of <> you could try it with precedes or follows as operators.
Beside them I wouldn't use string-values for it and I'm not sure if the whole approach to control dimensions/expressions with so many date-fields is really handy - at least I would use dual(string, number) for these fields.
- Marcus
Danke Marcus
Will es mahl testen
aber denke es wird ein normale straight tabel ohne if-statements und nur jahr-filters
Court