Changing Source Table of an Alias in Physical Layer in OBIEE — Oracle Analytics

Oracle Analytics Cloud and Server

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

Changing Source Table of an Alias in Physical Layer in OBIEE

Received Response
11
Views
1
Comments
ark86
ark86 Rank 3 - Community Apprentice

Dear All,

I had a view V_AGENT and i imported it in OBIEE Physical layer. From that i made an alias naming 'Agent'. I used this alias 'Agent' further in BMM and in Presentation.

Now i import another table naming T_AGENT. I point alias 'Agent' to T_AGENT now and check consistency. Everything looks fine till this point.

When i do any analysis on related Presentation table, it doesn't expand. Its drop down arrow starts blinking. Any idea?

Thanks.

Message was edited by: ark86 Correction: V_AGENT is a view while T_AGENT is a table

Answers

  • ark86
    ark86 Rank 3 - Community Apprentice

    Problem got solved. One column in BMM left unmapped which caused this issue. Everything worked perfectly after mapping it.