Don't know if this applies to your problem, but sometimes things can be resolved by switching which subject area you choose first.... But I would also be very interested in being able to choose which fact-column to join the subject areas on...

Yes, I ended up using RANK(CAST("Expense Report History"."Approval Level" AS numeric) by "Expense Report Details"."Expense Report Number") to be able to isolate the person, who's last approved the expense report... Which also is strange to me: Why is there no "Final Approver" in the subject area? but that's a different…

@Marybeth Snodgrass No, I resolved by creating the report in BI Publisher instead... ? As far as I remember I tried to add it to a DB Prompt and create a dashboard, but still wasn't able to succeed.

Hi Srinivas Here you go ? Thanks in advance for your help. //Anders nqquerylog_issue_with_CIP_Assets.txt

Hi. I have used the query assembler and I'm able to get the right result, but when I'm trying to add any prompts to the prompts-tab, it just returns the following: "Failed to load(Odbc driver returned an error (SQLExecDirectW).)" How do I figure out what is wrong, when all I am left with is this pretty generic message?…