OBIEE - Dashboard prompt with 3 analysis

Question

Hello all - I have 3 analysis that is going into a dashboard. I have a dashboard prompt that lets the user select analysis "A", "B", "C". Once a user selects a report from the dashboard prompt, each analysis has their own prompts that will prompt an end user to select the "year" and "state". This will eventually produce graphs. Analysis "B" and "C" is working perfectly fine. I have filtered a dummy column in the criteria (for all 3 analysis) so it goes against the presentation value in order for the dashboard prompt to show the A, B, C reports. While analysis B and C is working fine, A is getting an error - Odbc driver returned an error (SQLExecDirectW). It does not have any other information than this.

Pointers - I had all 3 working exactly how it should be but after logging back in a few days later I got the error above. I replicated the exact same reports in a different environment with all the same settings (exactly how analysis B and C is set up) and still getting the same error. At this point, I am stumped and looking for you guys inputs.

As always, thank you all.

3427784 · Answer

Gianni, I wasn't able to figure out the exact problem per say, but I did go in iteration and took an existing working analysis and built on top of that while deleting the columns 1 by 1 in the criteria section. This work around seemed to do it.

Thanks!

3427784 · Answer

I thought so initially, but I don't think that is the case considering the other 2 are set up exactly how it should and working fine. I then suspected it might be a cast function as a double on a column, but that also works for the other 2 analysis. I'll come back and post if a solution is found.

SriniVEERAVALLI · Answer

I suspect on dummy column. can you share logical query for that?

or else add where clause to that dummy column query by pulling any existing column  like where existingColumn is not null