Have you been able to connect directly to the database as the reports user in SQL developer? If so we’re you able to select from these tables?
Yes i am able to connect to reports in sql developers and able to write direct query analysis but can't use the answers features (drag and drop)
Did you check in the logs what exact query the BI Server is sending to the database?
Maybe it isn't using the fully qualified name and therefore there is a wrong or missing schema in the query or things like that.
thanks for your feedback..
I am using the same RPD file and the only thing i change is the user, when using the schema name and password it works perfectly while using the reports the answers are not working.
knowing that i can add tables to the RPD while using the reports user but i cant update the rowcount of the tables.
Still, did you check the query the BI Server is sending to the database? (that feeling of repeating myself )
Run an analysis giving you the error and find the physical query the BI Server sent to the database generating the error (either in the manage session page or the log files).
What is this query like?
Why do I suggest that? Because ...
BASSAM CHEHABEDDINE wrote:
... when using the schema name and password it works perfectly while using the reports the answers are not working.
In the query you will see exactly what schema name is used if any, and you will know what needs to be fixed to get the right queries generated.
please check below
SET VARIABLE QUERY_SRC_CD='Report';SELECT 0 s_0, "FCUBS"."STTM_BRANCH"."ALLOW_CORPORATE_ACCESS" s_1 FROM "FCUBS" ORDER BY 2 ASC NULLS LAST FETCH FIRST 65001 ROWS ONLY
And the physical query is?
That one is the logical query.
By the way: the Oracle database is telling you that you have another issue:
ORA-01017: invalid username/password; logon denied
thanks for your support, it seems it is working now ... what i only did is adding the schema name in each table i added, such as when add STTM_CUSTOMER admin tool is not taking the schema name with it so i just renamed the tablet to be fcubs.sttm_customer.
thanks for your support,