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…

@Daniel Vornicu Thank you for the detailed explanation. I believe these could be valid enhancements to the personalization feature. @Avinash Krishnaram-Oracle appreciate your thoughts on above use case.

When you revisit the workbook, make sure you are not in preview mode(which is possible if you have edit rights to the workbook) and make sure you open in viewer mode, as filters are persisted only in viewer mode. Refer : https://www.youtube.com/watch?v=BgQ7Hq5xr_c Thanks Gayathri

Thank you for updating this post with what the actual issue was, this will benefit other members of the community!

Have you set RPD , query limit as below : In the RPD => manage Identity => Application Role => Permissions => Set the Query Limits. You can limit queries by the number of rows received, by maximum run time, etc.