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

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

---

I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.

2 Answers   L&T,

---

what is diff between Decode and case ? Give some Example?

2 Answers  

---

how do you share the universe ?

4 Answers   Tech Mahindra,

---

CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,

---

How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  

---

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

---

What is a bo repository?

0 Answers  

---

what is confirm dimension ?

11 Answers   IBM, Wipro,

---

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,

---