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

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers  

---

What are the Input and Output Context Operators.

4 Answers   Bosch, iNautix,

---

Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?

2 Answers   Barclays,

---

How many universes will run maximum in single project

1 Answers   HP,

---

Why do we need metrics and sets?

1 Answers  

---

whats the Diffrerence between business objects and cognos?

1 Answers  

---

In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,

---

While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.

0 Answers   Emphasis,

---

what is performance tunning in BO in report level& designer level?

1 Answers   IBM,

---

What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?

2 Answers   CTS,

---

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers   Business Intelligence Analytics, SRA,

---

WHAT IS CARDINALITIES OF JOIN?

3 Answers  

---