nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Blend Data Dialog Box - Documentation about the message or option "This Connec

User_CGJM2

Description

Hi,

1. Click on Create Project

2. Go to Prepare Tab and select Diagram tab.

3. Added 2 Excel Files ( common column is present )

4. Upon clicking the "Join Line" between 2 excels in the Diagram tab, "Blend Data" dialog box opens.

5. There is one message line . That says- " This Connection Will Add Facts or Extend a Dimension"

That you have an option to choose either of them

6. What is the meaning of this option ?

7. In what scenario we have to use it ? What result would each of this option (Add Facts or Extend a Dimension) produce ?

8. Not able to find information in Oracle DV documentation.

Regards

Nachiket/Samar

Use Case and Business Need

We wanted to know what the feature does. But there is no information and hence we can not use this feature.

Original Idea Number: d211312a60

Find more posts tagged with

Under Review

Data Modelling and Datasets

Status: Under Review

Comments

Luis E. Rivas -Oracle

Samarendra,

Thanks for bringing this to our attention. We will review the documentation to locate where these options are documented and also per your idea consider adding direct descriptions of the options to the blend dialog. I will update this idea when I can point you to the documentation.

User_CGJM2

Ok. Sure.

User_CGJM2

Till the time it is being put in documentation, can anyone explain, what is the use of that feature ? In which scenarios we can use Add Facts/ Extend a Dimension option ?

Neeti Choksi-Oracle

Hi Samarendra,

This document might help - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/blend-data-that-you-added.html

Regards,

Neeti

User_CGJM2

Hi Neeti,

We saw the article video on Blend Data.

But we are unable to locate the significance of Add Facts/ Extend a Dimension option in the video.

Neeti Choksi-Oracle

Hi Samarendra,

The document contains the following information on when to -

Extend a Dimension - For example, Data Set A might contain new dimensions that extend the attributes of Data Set B.
Add Facts - Data Set B might contain new facts that you can use alongside the measures that already exist in Data Set A.

Regards,

Neeti

Neeti Choksi-Oracle

Also, if you need, I can provide a couple of examples with sample datasets. Please let me know.