Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Under Review
111
Views
7
Comments

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

2
2 votes

Under Oracle Review · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • 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.

  • Rank 3 - Community Apprentice

    Ok. Sure.

  • Rank 3 - Community Apprentice

    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 ?

  • Rank 5 - Community Champion
  • Rank 3 - Community Apprentice

    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.

     

     

     

  • Rank 5 - Community Champion

    Hi Samarendra,

    The document contains the following information on when to -

    1. Extend a Dimension - For example, Data Set A might contain new dimensions that extend the attributes of Data Set B.
    2. 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

  • Rank 5 - Community Champion

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

Welcome!

It looks like you're new here. Sign in or register to get started.