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

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

---

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

What is a universe?

8 Answers   TCS,

---

what is a Micro cube?

5 Answers   TCS,

---

. User wants to modify a report and wants to add additional data. How will you approach.

2 Answers  

---

what is universe null

0 Answers   TCS,

---

How many built-in objects are created in Business Objects repository?

2 Answers  

---

How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.

1 Answers   Patni,

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

---

I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?

4 Answers   Keane India Ltd,

---

how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in

2 Answers  

---

Is it possible to develop reports without Universe access?

7 Answers   IBM,

---