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 sheduling the report ? What is the need of it?

2 Answers   Infotech,

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  

---

how many reports have u created ? explain a few.

1 Answers   InfoStep, Ness Technologies, TCS,

---

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,

---

Can i merge two dataproviders if they do not have common column?

3 Answers  

---

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,

---

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers   Arkema pte Ltd,

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  

---

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers  

---

Explain how many universes can be created in a project?

0 Answers  

---

what is report tracing in bo

5 Answers   Satyam, TCS,

---

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,

---