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

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

---

WHAT IS INPUT CONTROL IN BO?

3 Answers   PWC,

---

what is report tracing in bo

5 Answers   Satyam, TCS,

---

What is report template in b.o?

0 Answers  

---

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  

---

5.what is LOV? where it is store?

3 Answers   TCS,

---

1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?

2 Answers   Mphasis,

---

what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,

---

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,

---

whats the Diffrerence between business objects and cognos?

1 Answers  

---

how we transport universes from business objects 6.5 to BOXI R2?

3 Answers  

---

How to sheduling the report ? What is the need of it?

2 Answers   Infotech,

---