Oracle Fusion Data Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

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

Folder within a dataset created by joining two or more datasets

Accepted answer
12
Views
3
Comments
Bhavin Desai
Bhavin Desai Rank 3 - Community Apprentice
in Oracle Fusion Data Intelligence

Dear,

  1. Is there a possibility of selecting the complete folders instead of individual attributes while joining two or more datasets/subject areas?
  2. Would it be possible to create folders (similar to folders in presentation layer in Subject Areas) within a dataset which has been created by joining two or more datasets? For a complex join, there are several attributes, and it may be very useful if the resulting attributes are allowed to be organized similar to folders in presentation layer.

Regards.

Best Answer

  • Rupak C
    Rupak C Rank 3 - Community Apprentice
    Answer ✓

    in FDI - You can select Create Dataset > Local Subject Area > drag a subject area > click a folder and click Add Selected to add the entire folder attributes in dataset.

    And when you join two such subject areas within the data set, they appear as separate folders when you try creating workbook.

    Please see attached document. i hope this is what you are looking for.

    CustomerConnect_FDI.pdf

Answers

  • Rupak C
    Rupak C Rank 3 - Community Apprentice

    same kind of logical folder organization you can achieve if you break your logical SQL into two and join them when you use Create Dataset > Local Subject Area > Manual Query

  • Bhavin Desai
    Bhavin Desai Rank 3 - Community Apprentice

    Dear,

    Thank you for your response. This helps.

    I also wanted to know if we can create custom folders as well? Lets say I select 15 attributes from folder of a one subject area and 20 attributes from other subject area. The resulting dataset is with 35 attributes. Is it possible to organize these 35 attributes into custom folders?

    Regards.