Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi @User_57K2N , Please refer to the following documentation for setting up an email server:
-
Hi @User_57K2N , Did you restart your OAC instance after enabling the Preview Workbook Email Scheduler? Did you setup an email server to deliver workbooks? Does you workbook work as expected when you open it?
-
Hi @Daniel Vornicu , I can't think any way to achieve your goal other than manually changing the column header for each Question_XX column in the visualization. I'd really recommend to transform your table into something more manageable as the current approach looks cumbersome and inefficient (given that 8-9 questions have…
-
Hi @User_Z0VKD , This usually happens when the CASE statement is based on a measure column (e.g. CASE WHEN Sales > 1000 THEN 'Y' ELSE 'N' END). To suppress the value from the Grand Total you have to transform each measure in your CASE statement to an attribute using the ATTRIBUTE function (e.g. CASE WHEN ATTRIBUTE(Sales by…
-
Hi @Paula McMahon , AFAIK this is not yet possible in DV. For this use case, I would use a subject area/semantic model instead of a dataset, so filters will be handled as WHERE conditions in the final physical queries.
-
Hi @User_YIBD4 , Error 403 denotes that access to the requested resource is forbidden. Are you still able to access the datasets used as inputs for the data flow (you should test it using the user who owns/runs the data flow)? Are you using connection-based datasets as inputs? If so, I would double-check that connection…
-
Hi @User_DLT8W , Have you already tried to setup and use Usage Tracking to achieve your goal? SUCCESS_FLG column tells you about the completion status of the query (successful, timed out, failed). END_DT and END_HOUR_MIN columns are null when a query is still running. I'm not 100% sure that you can track canceled queries…
-
Hi @Tiang , OAS 5.5 is no longer supported. I would upgrade to OAS 2024 and apply all the latest critical patch updates.
-
Hi @Rashmi Jadhav-Oracle , In Data Visualization it's not yet possible to set a default landing page. Whenever a user accesses, the Home page will be displayed. As a workaround, you could add a canvas which acts as a landing page to each workbook. In Classic Analytics you can set a default landing page different from the…
-
Hi @Sambasivarao Manam , AFAIK this not yet possible in OAC. I suggest to file an Ideas Lab request about it.
-
Hi @Ubong Henshaw , You can enable monitor and audit for Publisher data: OAC: OAS:
-
Hi @User_G1RXQ , You should replace 1 with rcount(1) directly in your myCalc calculations
-
Hi @Sisanda , A table mapped in your metadata repository (RPD) has been updated in the data source, but changes are not reflected in reports built on top of the RPD. Did I understand your issue correctly? If so, I would double-check the connection details and credentials in the connection pool to be sure that they are…
-
Hi @User_275WC , Did you set EnableSavingContentWithHTML to true in instanceconfig.xml? The Contains HTML Markup functionality is disabled by default in OBIEE 12c.
-
Hi @Khalood , In your Gauge properties dialog, you should format axis labels to display actual values and decimal places.
-
Hi @User_SFA90 , Which object are you using to access to your data? A subject area? A dataset? Where is data stored? In OCI? on-premise? Are you using a view or a materialized view? How many calculations do you have in it? Have you tried to run the physical SQL code generated by OAC directly in the database? Does it run…
-
Hi @Vitalii_Alliance_dgtl , AFAIK displaying both the actual value and the relative percentage for a column is not possible. You have to implement a workaround, such as creating 2 different visualisations.
-
Hi @Tomasz Antosz , Are you talking about RCU schema passwords? If so, did your DBA team change the settings for all the RCU schemas? Are you able to connect to the database using a SQL client (e.g. SQL Developer) using one of the RCU schema and its current password?
-
Hi @Rashmi Jadhav-Oracle , You can change the background color from the Properties panel > Edge Labels tab > Header Font (you have to do it for each column). As an alternative you can set a custom background color for everything in the visualisation: Properties panel > General tab > expand Style and set Background to Custom
-
Hi @Rashmi Jadhav-Oracle , In Data Visualization, you have to use a Pivot visualisation. In the Properties panel, select the Totals tab, and change the Total Rows Position property to Above.