Oracle Analytics Cloud and Server

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
21
Views
2
Comments
Rank 6 - Analytics Lead

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

  • 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

  • Rank 3 - Community Apprentice

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

Welcome!

It looks like you're new here. Sign in or register to get started.