Changing Source Table of an Alias in Physical Layer in OBIEE

ark86

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

ark86

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