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 the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
