Categories
- All Categories
- 146 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE - Dashboard prompt with 3 analysis
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.
Answers
-
Isn't this the exact same thing as Dashboard prompt - report not generating ?
0 -
Gianni, it is. Sorry about the duplicate. I was just wondering if anybody had any other inputs considering the logs didn't help to much. Sorry for the redundancy
0 -
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
0 -
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.
0 -
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!
0
