Hi Mark, i believe to be able to increase the number of rows returned, you will need to scale up your OCPUs. See the below article that clearly explains the limits that each OCPU can handle: https://www.rittmanmead.com/blog/2019/08/oac-row-limits-scale-up-or-down/ Usually, the DEV environments are at 1 OCPU to save on…

Hi Chetana, you may want to try the below, if you have access to the NQSConfig.ini (customer managed): https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=312054624455837&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2437684.1&_afrWindowMode=0&_adf.ctrl-state=em2cukm2z_4 Or Oracle support should be able to…

If its the OAC DV dataset is not visible to other users, here is what you need to also do (in addition to what you have done already): 1. Login as the 'DataAnalyst' who created the dataset into your current instance (TEST or PROD)2. Select the Data option from the OAC DV Menu on the left 3. Select the Dataset menu on the…

Hi Paul, is this in OAC Data Visualization Dataset? -Prasanna

Hi Adrian, i may have misunderstood your question, i was trying to answer the one one one access, is what i thought you were asking. Yes agree with Christian Berg, that functionality for Admin to have all privileges to DV objects at the time of creation by any user, is currently not available.Hopefully in the very near…

As Aman mentioned, this is how you will navigate to the steps he is referring to: 1. Login to your OAC Console, on the left menu select user -> identity 2. Select the user you want to change/add roles 3. Select the "Roles" tab and provide permissions to that user as appropriate (See image 3). You will only provide user…

Hi Chethana, There is data limitation when you create datasets, we encountered that when we are trying to connect to Oracle provided subject areas and pull financial data for more than 2 years worth. We would always run into query limit issues, hence dataset did not work until we started to limit data to a shorter periods.…

Hi Adrian, if you as user 'ABC' create a dataset, this is how you can grant access to an Admin and vice versa: 1. Login to OAC DV as user 'ABC' 2. Select the Data option from the OAC DV Menu on the left 3. Select the Dataset menu on the top to view all the data set user 'ABC' user had created 4. Highlight on the dataset…

Hi Chethana, everyone has great comments and all will help. In addition, we created an email alias to receive notifications either console related, data sync or DV errors, jobs, etc. We use the same alias for all notifications, as our ADMINs usually remain the same and its easier to maintain if ADMINs change in the future.…

Hi Raphel, See if this option works for you, its a bit convulted using OBIEE and using those roles in DV: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/connect-oracle-applications-data-sources.html#GUID-067CC574-D859-40CB-8300-027D682FB8A5 Thanks! Prasanna

Tod, my suggestion is to re-install your OAC DV desktop version. The install is pretty straight forward, make sure you meet the system requirements required to install. Latest version available: https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html User guide:…

Hi Brian, You can also clear you cache in OAC through the Menu (on your left) -> Console -> Issue SQL. And executing the below commands, depending on what you are trying to clear: call SApurgeallcache(); call NQS_GetAllCacheEntries(); call SAPurgeCacheByQuery(); call SAPurgeCacheByTable(); call SAPurgeCacheByDatabase();…

Aman, you can view your Administration Tool version (in help menu section), if you happen to use a RPD in OAC. That's just another way to check. -Prasanna

Chethana, is your OAC an autonomous or classic? If its is Autonomous, they are done automatically with an advance notification email to account Admin from Oracle. If it is Classic, then its on you to perform the upgrade. Make sure you have admin access to perform the upgrades, maybe thats why you are not seeing any…

We faced the same issue when we were in the older version of OAC. With the recent upgrades, have not encountered this issue in the recent times.

There is also a known bug 29757348 for this issue, Oracle is working on a solution for it in the future releases. Oracle managed changing the PDF/EXCEL parameters is not an option.

https://docs.oracle.com/en/solutions/migrate-data-models-analytics-cloud/connect-oracle-analytics-cloud-your-premises-database1.html#GUID-03DD603D-A0B1-4035-A5B1-193DD5274F20

Hari, yes there is an option to scale up in OAC, but you have to be provisioned at minimum 2 OCPUs to be able to scale up in the future. Or the only other option is to delete and re-creating the instance. PROD instance is automatically provisioned with 2 nodes, unlike the other instances. However, we did encounter unusual…