As mentioned by Amrita please put everything in one single line without any line break and forward slash . That should work .

In the initial value can you use Logical SQL Query to bring all the values

Can you share sample report and desired columns which you are trying to acheive .

can you please check the below link - https://www.ateam-oracle.com/post/bi-cloud-connector-further-automation-options

Yes in the filters pane you can change the operators as per your requirements.

Indra , for that column can you see if Report based total option is checked or not along with Average . Thanks Anirban

Indra , Can you try with only that column and one more column and see the o/p Thanks Anirban

Hi Indra , Can you get the session query of the OAC report and run the same in DB and check what is the output for that column thanks Anirban

Amrita , Can you please check these links - https://docs.oracle.com/en-us/iaas/integration/doc/creating-oracle-identity-cloud-service-striping.html#INTOO-GUID-30476219-FCDB-4BEB-A9AC-8FAF385C75DF https://blogs.oracle.com/analytics/post/how-to-create-oac-instances-on-oci-native-using-multiple-stripes-or-instances-of-idcs

Thanks for the response . Actually I was expecting a check box for MV same like tables/views . Reason being there are lot of tables in the DBs as compared to MVs . So if there was a way where we can only see MVs that would have been more beneficial .

Hi Ram , Can you check this link - Error "Exceeded Max Concurrent Instances Of Scheduled Job. Max Limit Is 1" When Running Agents (Doc ID 2777480.1) Thanks Anirban

If I change it to Read permission , then Copy option also went off .

After setting this permission , I can see only copy option.

Can you try to change them by giving custom permissions from catalog

Yeah ,even this issue happened to us also . After upgrading to the latest version, this issue didn't come up

Saurabh , Did you check the version of OAC client tool . Is it latest one ? Thanks Anirban

Hi Jahnavi , One option we can try is to manually delete the recommendations and then save the data set . From next time onwards , if we open the same data set then those recommendations won't come up. Thanks Anirban

Yes if you don't have exports or snapshots then i think you can't recover it . Thanks Anirban

Have you taken any export of your DV project ?

Hi Jerry , If its taking time for profiling then it depends on the data volume of the underlying data set . Also there is a profile recommendations , which provides recommendations based on the number of columns in the data set .For varchar and date columns it recommends lot of profiling options . I think we can turn off…