Hi Using WITH clause in SQL syntax for dataset is not supported. This is because OAC wraps the user's SQL query inside another query to limit the number of rows fetched from the DB, but the Oracle DB does not support WITH clauses nested inside of other select statements( It will give error "ORA-32034: unsupported use of…

In addition to above comments, you can also check with sales on getting guidance on appropriate shape for your instance based on projected usage. Since we do not have the CPU/memory consumption metrics, the way to look at existing usage would be to check the query capacity metrics in OCI console. If you are consistently…

Hi Wayne You can check the following blog posts which provides example using python or oci functions to export the json data exported from OCI Logs : https://blogs.oracle.com/cloud-infrastructure/post/exporting-oci-audit-logs-in-csv-format-for-desired-time-period…

Hi Wayne You can check the following blog posts which provides example using python or oci functions to export the json data exported from OCI Logs : https://blogs.oracle.com/cloud-infrastructure/post/exporting-oci-audit-logs-in-csv-format-for-desired-time-period Thanks Gayathri

Just to note that the KM doc you referenced here was created for 'Primavera Cloud Services' product and is not applicable to Oracle Analytics Cloud. For OAC we cannot increase any configured limit via backend. You have to apply necessary filters, reduce columns/cells to be within the documented export limit based on your…

Hi This seems a question for fusion team, will be better to post here : https://community.oracle.com/products/oracleanalytics/categories/otbi Moderators, if possible kindly move this post to fusion. Thanks Gayathri

Hi This has been identified as a known issue which is fixed in next release of OAC. Thanks Gayathri

Another suggestion would be try this as formula in DV by creating Calculated Item. I just tried a simple test case with similar formula and DV showed proper results.

Hi Please check session.log when you execute the dashboard after seeding cache using both methods and verify if the one taking longer is producing a cache hit or is it sending to database. Check Table 5-3 Factors That Determine Whether Cache Is Hit in the following Cache hit section of doc :…

Are you able to access /analytics endpoint (Classic Home)? If so suggest you attempt login to analytics -> my account -> Application Roles and validate the Application Roles assigned to user01.

@Manu R-Oracle Please note that this is a public forum, so please do not share CI/PI info. Since you are oracle employee, you can always use our internal slack channels for further assistance OR you can create SR with Support so we can assist you further. Thanks Gayathri

Also note that if you have OBIEE/OAS/OAC applications connecting to Essbase, there is a way to define SSO connection from BI to Essbase which uses LoginAs command. So depending on how the connection to essbase is defined, loginas could be reported in audit logs for queries coming from BI to Essbase.

Please review Design Tips for Physical layer and BMM layer in product documentation.

Also please try to clear browser cache and retest the behavior.

Can you please clarify which product you are using? When you say in LinuxOS, are you referring to the browser client machine? Thanks Gayathri

For reference here is the link to OTBI Community : https://community.oracle.com/products/oracleanalytics/categories/otbi Thanks Gayathri

Not exactly clear on how your parameter is setup based on what you have described, but if you are trying to create a calculation you could try to escape the single quotes by using a double single quote in place of the unescaped single quotes (i.e. 'O''TOOLE','O''GRADY','D''ADDARIO'). Other comments welcomed.

Can you explore Groups and Calculated Items available in classic Answers for this requirement? Video on Creating Groups Other comments welcome. Thanks Gayathri

Thank you for asking your question in the Oracle Analytics Community. We are trying to find an answer for you, meanwhile, any other user is welcome to share their experience with this question.

Hi Claudia This is a 5 year old thread and actually created in the wrong community. This community is for Oracle Analytics related issues, what original poster reported was specific to fusion OTBI. If you do have issues with schedule option in Oracle Analytics kindly post as a new question to this forum with relevant…