Anyone that can help me with this? Thanks.

Thank you, that was it! I changed UINT to NUMERIC and the correct numbers are now displayed.

Hi Thomas Dodds, I checked the RPD. To be a bit more specific, I use 3 different fact tables in this report and 2 different dimension tables. I made sure that each of these fact tables are indeed connected to the two dimension tables (on logical and physical layer) and that the content level for the three fact tables, is…

Hi Joel, yes I have. The query returns correct data from DB in both cases (I already mentioned this in the first post), but the report shows nulls in the first case. This is why all of this is so strange to me.

Does anyone have any idea what could be causing this?

Thanks for all the help. I cannot explain why this was an issue for me, it just didn't work as a column formula in my report. I tried casting as char/varchar several times... nothing worked. I really think this was a bug. I finally solved it by building a new column in RPD with the same formula (CountryName || ' ' ||…

Hi cesar, both columns are type VARCHAR, both in RPD and in Database. I even tried casting to char/varchar but it doesn't work, I keep getting the same error. I would like to reiterate that this only happens for one of the two columns: CountryName and not for CountryId. CountryId I can concatenate without problems with a…

@Mayur_A I tried: "Countries"."CountryName" ||' '||'Test' Unfortunately the error I get is the same. So the issue isn't in the formula synthax, I guess. It is just weird because I can concatenate two different columns without problem if I don't use any custom text (such as 'Test'). UPDATE: I tried joining the other column…

Hi @Mayur_A This is the exact formula I used: "Countries"."CountryName" ||' '|| "Countries"."CountryCode" or just "Countries"."CountryName" ||'TEST' Both give the same error that I've mentioned.

Same error when I do that.

Hi Cesar, thanks for the answer. I know about that option, but my question was if it's possible to do it for one report only, without making separate dimension table in BMM.

I have tried VALUEOF(NQ_SESSION.COUNTRY) as well but it doesn't work. But I have noticed something even stranger - even when I don't have anything set for Default Selection option for this prompt, 'ENG' still gets automatically chosen when I enter the dashboard. How is that possible?

Bump

Thanks justthefacts, this was exactly the reason: justthefacts wrote:I would look at the dimension hierarchy for your Department dimension and specifically I would look at dimension keys. If something like "Department ID" is specified as the dimension level key, but "Department Name" (what you are showing in the report) is…

Hi Christian, the version is 11.1.1.7.151020.