Answer / shikha

Whenever we use Aggregate Aware we need to set up
incompatilibities to work it properly (so BusinessObjects
knows what SQL to generate)

For example, There are 2 aggregate tables fact table by
week and by day.If you set up a measure as aggregate aware
from both tables - total quantity for example, the select
might be something like: -

@Aggregate_Aware(sum(week_agg.qty),sum(day_agg.qty))

The week table listed first as this would be the
preference. But as BusinessObjects needs a reason to not go
to the week_agg table, this is done using
incompatibilities. For example the Week Number dimension
object would be compatible with the week_agg table as it
will link to it and the data is held at an appropriate
level to report against it. However the Date dimension
object would be set as incompatible with the week_agg
table, such that when it is selected alongside the Quantity
object, BusinessObjects knows to jump to the next option in
its select definition.

Answer / nareshkumar

Aggregate Navigation is used to specify the incompatible
objects.

Answer / sam

To receive the performance benefit offered by an aggregate
schema, a query must be written to use the aggregate.
Rewriting the sample query was a simple matter of
substituting the name of the aggregate fact table for that
of the base fact table. This may be easy for technical
personnel, but can prove confusing for an end user. The
complexity grows as additional aggregate tables are added.
Technical and business users alike may err in assessing
which table will provide the best performance. And, if more
aggregate tables are added or old ones removed, existing
queries must be rewritten.
The key to avoiding these pitfalls lies in implementation
of an aggregate navigator.
A component of the data warehouse infrastructure, the
aggregate navigator assumes the task of rewriting user
queries to utilize aggregate tables.
Users and developers need only be concerned with the base
schema. At runtime, the aggregate navigator redirects the
query to the most efficient aggregate schema.

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?

3 Answers   Oracle,

---

User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.

1 Answers  

---

How can we use multiple data providers in a single report in business objects?

2 Answers  

---

how to create metric universe ?

0 Answers   TCS,

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

0 Answers  

---

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,

---

Hi, How to navigate one report to another report in webi? Thanks in Advance

3 Answers  

---

How to create Universe using Flat file in BO6.0

1 Answers  

---

What is the difference between absolute and relative div positioning?

0 Answers  

---

am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

---