Hello experts,
I'm using obiee 11.1.1.9 and I have a report that when I want to open I obtain this error:
It's weird because if I click on "Refresh" I can see my report perfectly. It's only first time that I open this report.
Any help??
Thanks!
Hi,
It somehow complain about incompatible types. Does the analysis ("report" = Publisher, "analysis" = the one you are opening ) contain a UNION?
Is that something you copy/paste edited, migrated or moved around for a while?
Does the same happen if you create a new (from scratch) analysis with the same logic?
Hello @Gianni Ceresa
Thanks for your reply.
Is an analysis (answers analysis) and not contain any union
This analysis is migrated from a test enviroment (In test enviroment works fine).
If I create a new analysis from 0 with exact columns I obtain same error that I posted before.
Non-compatible types errors really point to a calc/logic issue.
Recreate the analysis step by step or prune away columns one by one until you find the issue.
It's weird because when I open report first time I have this issue, then I refresh and I see report perfectly (only If I click on refresh)
If I recreate analysis I can see that are one columns that cause the error. That column I need to use to filter all analysis, when I create a filter for that column error appears. Then I don't know what to do. Maybe I have to modify something in Administration layer?
That's exactly the point I wanted to get you to
Now check what is underneath in the RPD
Ok, Now I know that issue is in admin layer but how can I havbe to fix? Aparently I have checked between prod and test exactly and I have same connections
Trace it top down. Column logic/formula, LTSs, physical source, source settings, SQL, explain plan...
Ok! Thanks I'll trace all of this and inform about results.
Hello experts
In that report....if I check this option:
my report works fine (load at first time without any error) but it slow to load (20 seconds instead 1 sec) My customer woudn't approve it...
This option is any clue to fix my issue?
Thanks
Do you have any special characters in the table name/columns etc.. in the report? If so remove them and see if the same issue occurs again.
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
