Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Errors in RPD after adding new LTS and column

Received Response
31
Views
2
Comments
aPsikus
aPsikus Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:31PM in Oracle Analytics Forum

Hi,

Not sure if it is normal behavior, but I'm not sure how to proceed.

In physical layer I have created new alias. Created all the required joins.

After adding it to the BMM as LTS, I have removed all not needed column mappings.

And when saving the RPD, it gives error about missing data source mapping between logical column and physical data source.

As I have checked in earlier version of the RPD, the columns which I have removed in new LTS are not mapped with any other LTS in same logical table.

How it is possible that there is no error if they are not connected?

How in safe way I can add new LTS without connection?

EDIT: I think I know what has happend.

By dragging aliast to LTS I have also moved all the columns from the table, and in BMM they need to be removed before I create new columns. I had wrong feeling that in previous version of the RPD they are also present in BMM, but it looks like they dont.

Please confirm

Answers

  • Avinash Pentyala
    Avinash Pentyala Rank 5 - Community Champion

    Hi,

    In physical layer I have created new alias. Created all the required joins.

    After adding it to the BMM as LTS, I have removed all not needed column mappings.

    - What do you meaning of Column mapping?? you removed alias columns from Physical Layer??

    Did you check BMM model  logical source is mapped to all columns?

    Regards,

    Avinash Pentyala

  • 842395
    842395 Rank 3 - Community Apprentice

    If you adding LTS column join LTS join with Base table or automatically is soucre oF LTS column is added.