Oracle Communities

Oracle Analytics and AI

Child Item

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

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

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

All comments

Mallikarjuna Kuppauru-Oracle

Hi @Lauriane Massin Whitaker

Are you using Branch or Sandbox Framework?

You can extend the Dim .

Regards,

Arjun

Lauriane Massin Whitaker

Hi,

Branch framework.

Regards

Lauriane Massin Whitaker

Any updates ?

Regards,

Lauriane

Sumanth V -Oracle

@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!