Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with Alias

Vinay .Feb 20 2009 — edited Feb 22 2009

Hello Gurus:

I am having a report with bunch of dashboard prompts.
Now the fact table in Physical table has 2 aliases.
And some measure in BMM layer are from Alias 1 and some are from Alias 2.
There are different WHERE clauses in BMM layer in sources for Alias 1 and Alias 2.

Now, I want the prompt query to hit Alias 1, but it is hitting Alias 2, and hence it has wrong set of WHERE filters.

Please note that all the joins are same in physical layer between the 2 aliases.

So How do I make that prompt query hit Alias 1 instead of alias 2?

Please help me out.

Vinay

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2009

Added on Feb 20 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

470 views