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.

Hi I believe this is possible in browser based OAC via Portal Path system setting (doc'd here ) which allows you to specify a dashboard path based on application role, however not sure about Mobile App, will be good to test the setting. Other comments welcomed. Thanks Gayathri

If you see the FY24 Roadmap link posted by Ben, you will find the following features in the upcoming release : OAC Catalog API OAC Connections API Not sure if OAC Connections API will also include enriched APIs for Dataset Management, maybe PMs in this forum can comment on that. Thanks Gayathri

Hi I know this works with admin tool rpd but havent tested with semantic modeler. If tables get created fine, means it's able to refer the connectionpool/connection. Someone has to actually look at backend logs to see if there are any errors preventing the insert for which we need more details on your instance. Appreciate…

The 3 Init Blocks you created, are they 'Repository Init Blocks' or 'Session Init Blocks' ? Please note that for OAC currently only Session Init Blocks get recorded in Init Block Usage Tracking Tables. Repository init blocks do not populate usage tracking table. Please test using Session init block and let us know of…