What are the requisites a Dataset in DV must fulfill in order to be able to combine it with a Subject Area in Classic Analytics? Please, see the image below…
Thank you.
Cheers,
Jorge
Create a Local Subject Area based off the Subject AreaCreate a Dataset from a Local Subject Area
Please check Blend Datasets documentation : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/work-workbooks-datasets.html#GUID-366E6952-2B1A-4729-8CD0-129003672EB5
Datasets that use Oracle Essbase or Oracle EPM Cloud connections aren't available for blending.
And blending of datasets is for workbooks. for classic you can add content from other subject area based of the same BMM.
Thanks
Sorry but I don't understand your answers. The Datasets on the picture highlighted in yellow with green icons are Datasets created in DV by importing XLS files. When I repeat the steps now, with a Dataset created in DV by importing an XLS file I am not able to see them on this screen where I'd be able to combine them with Sales Order Lines Subject Area for example as it's my intention. Thanks.
You need to create a Workbook for blending and not use classic analysis reports. File based datasources are only supported in datasets, they are not supported for rpd/semantic model. Check supported datasource doc here : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/csv-file.html#GUID-6852FB6E-E6DE-4FED-8C53-B48E7C782E0D
Any blending between subject area and file based dataset has to be done using workbooks and not answers reports.
Gayathri
Thank you @GayathriAnand-Oracle but actually I am able to join the DV Dataset with a Subject Area as long as I am using common columns from both sources in the report. Please, see below:
…and I am getting results…
Best regards,
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
