I have a report out of 2 universes. (pdf example attached)
Merged on several fields and works well.
Now the field IFU gives me multivalue error.
I tried getting this in from query 2 by making it a detailed field on the merged dimension ‘Material’.
This does not work because as you can see in the example query 2 has multiple dates for the outcome.
Guess that is why I am getting a multivalue.
Therefore I first made a field Max addendum date by getting the max date for combination addendum part number and ship to. (Because the addendum part for a material is also dependend on the country).
This gave me as you can see the max date in the report for this combination.
With that date I made the field Add on Max date.
Now In Q2 I seemed to have the correct Addendum part so I now tried making the field ‘Corr IFU’ for the report on both queries combined.
But as you see no output.
The multivalue error is gone but no output is not really better then multivalue error
Can somebody explain me how I could get this to work?
Thanks.
I am not sure how you are uploading these PDFs; maybe different file types are handled differently. If you upload an image it makes it easier to read your question.
Ok…somehow I thought pdf was the only thing I could upload…
But now even noticed I can just paste in my snagit screens directly…sorry about that.
Here are screens for the first part (maybe a bit big…) and will add another post with the slightly better results below this one.
Probably making a mess with all these screens but it actually helps me making steps here
Made me see I also need to make field ‘Corr IFU’ look at material AND ship to
Still a few empty but looking at those it seems to be in the data rather then in de BO formulas.
Guess this is solved for now, but if people read thru all this and think “this is still wrong” or “this could be better and more efficient” please let me know!
Thanks.
and think “this is still wrong” or “this could be better and more efficient” please let me know!