Answer / mysticbo

Hi All,

I am new to Universe designing.
I have detected loop. And after reading forums,I understand
I need to create alias of the required table.

I have a few questions:
1) Suppose I create an alias of the table
as "table_name_alias" and create the necessary joins,what
is the next step?
2)DO I need to link the alias table with the original
table? ---No I think
3)DO I simply go to my semantic layer and change the object
definition of the original table and point it
to "table_name_alias".

Will 3) be sufficient if I dont have too many facts tables?
Or do I need to drag the "table_name_alias" and create a
class of that?-- I think NO

Please guide.Thanks:)

Answer / sj

One of the main use of Alias is to solve loop..So consider
you have a loop like A-->B-->C-->D-->A
in this case the loop ends on A.

So create a alias tale of Table A like A_alias and breathe
loop like below
A-->B-->C-->D-->A_alias,in this way loop is removed

What is drill across ? can anybody explain me in detail?

1 Answers  

---

could you please give me the diagram of BO 6.5 Architecture or explain about the tires?

6 Answers   PCS, Tech Mahindra,

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

---

How many universes will run maximum in single project

1 Answers   HP,

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

What are the Users and Usergroups?

1 Answers  

---

Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90

1 Answers   CSC,

---

What is the difference between the public object&schema object?

0 Answers  

---

what is difference between global filter an query filter in web intelligence?

3 Answers  

---

how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????

2 Answers   Infosys, Keane India Ltd,

---

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

---