alias

[system]

hi experts,

As i know when ever we access the same table more than once need to create an alias, so to do the same task why cant we use self join

so when to use alias and context

---

sri9 (BOB member since 2011-05-10)

[system]

Self joins are used to apply column filters on that table. Alias has different purpose. Self join cannot replace Alias, and vice versa.

And for more on context and aliases use please check

Read Me: Best Way to Resolve Loops Context? Alias?

Hi all, I am new to Business Objects , and a FAQ in BO is which is the best way to resolve loops , SO Guys can anyone clarify me …which is the best way , Aliases or Contexts… Thank you, Chowdary [Edited title and made sticky - Dave Rathbun] rajchowdary81 (BOB member since 2007-02-01)

---

Saket Asati (BOB member since 2013-07-01)

[system]

When you alias a table (usually a dimension), you are joining to another table (usually a fact).

When you put a self-join on a table, you aren’t joining to another table - you are restricting all the rows from that table.

Judy

---

JMulders (BOB member since 2002-06-20)