Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
"Invalid SQL Identifier" It loses the outer most query. Below is the code on the advanced tab. It seems to not be able to find the outer select in 12c, works fine in 11g. SELECT count(distinct SubjectArea1.SSN) saw_0 FROM (SELECT "Claim Information"."SSN" SSN, "Claim Information"."BYE" BYE, "Claim Codes and…
-
This is the what I get when I run a working Analysis in 11g that was upgraded to 12c. These are written on the advanced tab so we can do multiple joins that are not in the RPD. I've been working on this for months with Oracle support and we are getting nowhere.
-
Worth a try. Thanks.
-
It doesn't seem to like the it when we use the name of the mailing list, ABC_DL_LIST_OF_USERS. That is what is in Outlook, do I need to set up something within OBIEE that points to the Outlook list?