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

how to prepare the documentation in business objects and where to get the requirement?

0 Answers   IBM, TCS,

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

What is the definition of derived table ?

2 Answers   JPMorgan Chase,

---

Difference between Decode and Case?

1 Answers   NIIT, TCS,

---

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,

---

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

0 Answers   ASD Lab, Wipro,

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  

---

Is it possible to generate reports without having knowledge of the Universe structure?

4 Answers  

---

how to link 3 fact tables

1 Answers  

---

What is mean by tuning the report?

1 Answers  

---

How to link one location universe to other location universe

3 Answers   Cap Gemini, TCS,

---