Thanks @SivaB -Oracle. We did that before, but unfortunately could not get success. This time we tried using a different User with the same privileges, and it worked. System is not considering the time what we have provided, it is randomly picking up and running crawls. Not sure if others also having the similar issue on…

DV is gaining more traction, users are seeing for Subscribe option that delivers Workbook data directly to their mails.

Thank you all for your suggestions. We will check.

Thanks @Sumanth V -Oracle. Is there any doc or do you have steps to extract content from a bar file? We would like to give a try this even though it is not recommended.

Some interesting features are on the way. Looking forward for all especially AI Assistance full development, Shared watchlists, Multi sheet excel import etc.

Congratulations and Thank you very much @Gianni Ceresa. I was benefited with your Answers/Suggestions for my questions here. Your answer for about Community is very much true. Give and take policy keeps community alive and useful for all. Once again thank you.

Thank you all for your suggestions. We have checked the physical sql, problem is with DB. When we run the SQL in DB it is giving the same error. We will check for alternatives like Narrative view as suggested. Thanks. CLOB data type is not an option for us, there are many limitations if we use CLOB.

Thanks @Christian Berg -Oracle for your response. We are trying to CONCAT two columns in Classic BI report(Analysis). We also checked the length, both columns together just above 4000 chars. Below is the formula from our report, "Competency Assesment"."Feedback"||' - '|| "Competency Assesment"."Competency Name" Here is the…

We also are facing the same issue, having reload metadata option would be very helpful.

Thank you very much @Jacques V.-Oracle. We are able to see the Assistant tab. Thanks for your help.

Thank you @Jacques V.-Oracle

Hi @Benjamin Arnulf-Oracle, @Jacques V.-Oracle We have a 16 OCPU instance(Ashburn Region) that was updated on October 11 with the September 2024 updates. However, we are unable to see the Assistant tab. I understand from previous conversations that the feature is being rolled out gradually to all instances. Could you…

@Mostafa Morsy-Oracle Thanks for the doc, no our is not FDI. Its custom OAC.

@Harish V-Oracle, I am aware of that, my question is related to Parameters. As of now we cant use Variables in Parameters. We may get his option in future and this idea was already suggested, you can upvote for that idea.

Thanks @Sumanth V -Oracle . I upvoted to that idea.

@Sumanth V -Oracle , we have a column SAW_SRC_PATH in LOGICAL_QUERIES(S_NQ_ACCT in-case of 0BIEE) Table. You can use that column to get the DV Workbook or Report name.

This is the formula we use in RPD to get the workbook name, CASE WHEN "WA UsageTracking".""."UT SA"."LOGICAL_QUERIES"."QUERY_SRC_CD" = 'Visual Analyzer' THEN left(SUBSTRING("WA UsageTracking".""."UT SA"."LOGICAL_QUERIES"."SAW_SRC_PATH" FROM LOCATE('/', "WA UsageTracking".""."UT SA"."LOGICAL_QUERIES"."SAW_SRC_PATH" ,-1)+1),…

We are trying to use string functions but not getting results as expected. We are working on that and keep posted here once we get proper solution. Thanks.

@Shantaram-Oracle , we want to create a report on Owners data, like how many workbook are created by a respective owner to get some insights on DV usage by users. Your suggestion works to check who is the owner but our requirement is different.

Thank you @Gianni Ceresa and @GayathriAnand-Oracle . I will check those options.