OTBI Standard Subject Area with Custom Subject Area

Summary:

Hi Team,

I have a requirement where i need to add a custom object column mapped to a dynamic field to the OTBI report built using standard subject area. when i tried to create a custom subject area including that custom object column and add it to the OTBI report its giving multiple rows due to unavailability of necessary join columns across dimensions. So is there a way we can add the custom object column to the standard subject area in fusion?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):