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

How to remove Semantic Model Errors

Received Response
163
Views
15
Comments
Jose Cordoba
Jose Cordoba Rank 3 - Community Apprentice
edited Aug 13, 2024 7:25PM in Oracle Fusion Data Intelligence

I get these errors in semantic models afer I removed a data augmentation, how can I fix it?

image.png
Tagged:
«1

Answers

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

    Hi @Jose Cordoba

    Looks like you have deleted the DA jobs but not the reference at semantic model extension. Please check the step and re-modify the same and republish the steps to fix the Errors.

    Regards,

    Arjun

  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice

    Thank you @Mallikarjuna Kuppauru-Oracle however this Data Augmentation was not use in any of the semantic model extensions that I have, how can I locate where is the issue coming from?

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

    Hi @Jose Cordoba

    As per Error message, Below is the Logical Dimension is showing the Missing Columns -

    DW_FA_X_ACCRUAL

    Can you confirm are you getting this Error while clicking on User Extensions? then you have some reference .

    Regards,

    Arjun

  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice

    That is correct, I'm getting the error on user extensions, but I just have three customizations and none of them involve that Data Augmentation

    image.png
  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited May 17, 2024 12:34AM

    Hi @Jose Cordoba

    Can you check do you have any Extended Dimension steps on customization related to above Logical Dim.

    Refer - FAW:FDI:FDIP: SME Warning/Errors Banner Notification - There Are Errors In Your current Semantic Extensions (Doc ID 3020134.1)


    Regards,

    Arjun

  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice

    I dont have extended dimension steps related to that Logical Dim, these are the only extended dimensions that I have and all of them are working fine because they are related to other logical dims

    image.png
  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice
    edited May 17, 2024 12:43AM

    Hi @Mallikarjuna Kuppauru-Oracle

    I already checked that documentation, but I'm stuck in this part

    image.png

    I know that the issue is that the Data Augmentation was removed, however I dont have that Dim in the custom extensions, so how do I suppose to fix the issue if it's not in any of my user extensions?

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

    Hi @Jose Cardoza

    One way to debug is to Edit the steps and see are you able to find the reference.

    In General as per product,

    These messages were add to identify all augmentation objects used in SME and if the augmentation gets deleted.

    Regards,

    Arjun

  • Jose Cordoba
    Jose Cordoba Rank 3 - Community Apprentice

    Hi @Mallikarjuna Kuppauru-Oracle thanks for your response.

    I already checked every step and there is not a relation to that logical dim, is it possible that this issue was caused due to the augmentation type was create dimension? I mention this because there was not necessary to do a SME to get the subject area created for that Dimension.

    Regards.

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

    Hi @Jose Cordoba

    If you’re unable to find better to log an SR for the further debugging.

    Regards

    Arjun