Hello everyone,
I'm currently using OBIEE 11g
I've created a lot of Publisher Reports a few months ago, including the creation of a data model and it worked just fine.
I've been working a lot on the users, groups, and application roles lately and now, when I'm trying to execute one of the reports, I got the following error : can't extract metadatas from data model (I just translated it from french so you might not find it that way).
I've tried edition the datamodel but when clicking on one of the analysis it contains, I got this error : oracle.xdo.XDOException: Unable to create saw session. please verify the server connection
Server connection sounds to work well : I have no problem opening an analysis (even if it's used in the report...), seems like the problem is just about Publisher Reporting
I've tried to check the privileges, permissions but I can't find anything that solves the problem.
Plus, when I try to create a new Report :
- if I try to use an existant data model I got the same error
- if I try to create a new data model, I choose 'Oracle BI analysis' in New Data Set, if I click on the magnifying glass icon I can't access to the Catalog : I should see sth like that :
ORACLE BI CATALOG
folder icon - shared
folder icon - users
Cancel button
But I don't see any folder. As if I'm now allowed (when using publisher reporting) to see the catalog.
That's it... If anyone has any idea I would be very happy to try it.
Thanks you very much for reading
C.J