Hi @userva , You have to apply Weblogic and FMW Infrastructure patches (which are listed for OAS 2023) to OAS 2024: https://support.oracle.com/epmos/faces/PatchDetail?patchId=28186730 https://support.oracle.com/epmos/faces/PatchDetail?patchId=36178496 https://support.oracle.com/epmos/faces/PatchDetail?patchId=36074941…

You're welcome! When creating a Pie chart: the Pies drop target will generate a separate pie for each column/value that you place in it the Slices drop target will generate a separate slice for each column/value that you place in it. Moreover the Slice Size drop target should contain the measure columns that you want to…

Hi @User_VJ1LK , You should move "Valor Faturado" and "Schedule Unbilled Amount" from the Pies drop target to the Slice Size one.

Hi @User_VJ1LK , Can you please click on the pencil icon at the top right corner of your pie chart, and a share a screenshot of what you have in the Layout section?

Hi @User_VJ1LK , Can you please upload screenshot as images or PDF format? People are unlikely going to open a docx file shared in a public forum

Hi @userva , Are you able to start em from the WebLogic Administration Console? If not, did you see any error in the log files? Did you apply the required patches?https://support.oracle.com/epmos/faces/DocumentDisplay?id=2832967.2 It's worth noting that you have to apply Weblogic/FMW Infrastructure patches listed under OAS…

Hi @Jaymie , This is expected. I was able to see the screenshot of the intialization block before you removed it, and noticed that you are using an INSERT statement instead of a SELECT one: this is not supposed to work and will always generate issues. You have to use only SELECT statements in initialization blocks.

Hi @userva , Can you confirm that your administrator user is a member of the BIServiceAdministrator role? Can you rerun the command and grant only policies containing admin/administrator in the name?

Hi @Jaymie , I would focus on the error that you are getting when you try to view a report first. It says that the OAC_LOGIN_INITBLOCK initialization block (defined in the RPD) must complete successfully. It has probably been marked as "Required for authentication" and gives you this kind of issues when its query returns…

Hi @userva , You assign security policies / permission sets to application roles, not to individual users. BIServiceAdministrator is the default application role in OAS that allows you to manage the application, and the administrator user created during the installation is member of it. Since you restored an OBIEE…

Hi @Jaymie , It would be great if you can give us additional information: Which tool and version are you using? Where have changes been applied? Directly to the physical database? To the dataset definition in DV? What do you mean exactly with "when I go to connection on Oracle BI"? Are you in the dataset editor? semantic…

Hi @userva, When you restore an OBIEE snapshot in OAS, all default role policies are overwritten with the content of the snapshots. OAS contains new policies that are required in order to use DV properly and you have to restore them: If you grant all policies to BIServiceAdministrator than you should be able to fix your…

Hi @Rajakumar Burra , As a workaround, you could set the canvas layout to Freeform, and manually overlap the Line Chart to the Stacked Bar Chart. You also need to format the vertical axis to have exactly the same Start and End value for both visualizations, and eventually hide titles/labels as required. A proper solution…

Subject areas are tipically designed to help people answering questions that they already know (no need for serendipity imo) and the amount of data is generally way bigger than datasets. Having auto insights applied to a whole subject area will surely lead to performance issue and people complaining about it. As an…

Hi @User_88CSQ , I would use the following approach: Add each analysis to a dashboard page Create a dashboard prompt with 2 variable prompts (e.g. PV_Start_Date and PV_End_Date). It doesn't matter which table/column you use to initialize the available values as long as you create them as variable prompts Add the dashboard…

@Gianni Ceresa you are right, when upgrading from OBIEE 12c to OAS (up to the 2023 version) agents are copied, and disabled by default. The latest version (2024) allows administrators to enable them automatically (if they were enabled in the source environment). @Michelle Flynn Are people in your organization using also…

Hi @SteveF-Oracle , Thanks for your answer. I already know the page you shared, but unfortunately it does not mention cache. It would be great if that document can be expanded with information related to cache.

Hi @Chris Cadrain , This capability is not available in DV. You should post your idea to the Oracle Analytics Idea Lab, which is the official hub for enhancement requests.

Thanks @Gianni Ceresa for sharing this with the community. It will save me a lot of time if I need to face the same issue.

Hi @Gopi Krishna P , From the Classic Home, open the Administration page, then click on Manage Privileges and make sure that View Dashboard Prompt privilege has been granted to the required application roles. You should also make sure that users are using a browser which is certified with OAS. Same permissions working in…