Oracle Fusion Data Intelligence

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

How can I pull a newly created ADW indicator and use it in oac ?

Received Response
23
Views
4
Comments

Hi,

I've been trying to create indicators directly in ADW through the creation of views. For exemple, 2 columns with the number of males and females.

When I try to add these columns through my SME feature in FDI, I'm able to see them in OAC but only as attribute... Where in ADW, they are numeric.

Could someone explain me how to use the SME feature to be able to pull metric indicators please ? Do I need to create the calculation in the SME step ?

Thank you

Regards,

Lauriane

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Lauriane Massin Whitaker

    Are you using Branch or Sandbox Framework?

    You can extend the Dim .

    Regards,

    Arjun

  • Hi,

    Branch framework.

    Regards

  • Any updates ?

    Regards,

    Lauriane

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Lauriane Massin Whitaker -

    • Access SME in Fusion Analytics
      • Navigate to the Semantic Model Extensions editor in your Fusion Analytics instance.
    • Identify the Attribute to Be Cast
      • Locate the attribute you want to cast in the Extensions or Custom Subject Area you are working on.
    • Open the Attribute Properties
      • Right-click on the attribute or click the pencil/edit icon to open the attribute's properties.
    • Change Data Type
      • In the properties dialog:
        • Find the Data Type field.
        • Change it to Number (if it's not already set).
    • Set as Measure (if needed)
      • Check the box or option for Set as Measure.
        • This will ensure the attribute behaves as a measure in analyses (e.g., can be aggregated, used in calculations).
    • Save the Changes
      • Save the changes to your semantic model extension.
    • Validate and Publish
      • Validate the semantic model for any errors.
      • Publish the updated model to make the changes effective.

    Hope this helps!