Answer / prasanna

An aggregate table is summary table that dba build to execute
querys faster.@aggregate _aware is an function in bo which
takes advantage of aggregate table when ever possible else
it redirects to original fact table.

syntax:
@aggregate_aware(sum(smallest_table),sum(medium
table),sum(biggest_table));

here smallest table is aggregate table because data is
aggregated by various dimensions.and big table is fact table.

Answer / chowdary9999

@Aggregate aware function is maily used for speed up the
business objects process.

Answer / katwal

Aggregate awareness is a function that makes the aggregate
functions aware of the granularity of the tables defined in
the physical layer.

Answer / ramakant baviskar

@aggregate aware is nothing but pre-calculated data of summary
tables which is used for speed up query performance.

Answer / ramakant baviskar

@aggregate aware is apply on BO Universe.aggregate aware is nothing but pre-calculated data of summary tables and is for
improve query performance.

Answer / basha

Aggregate awareness is to redirect a query to the Desired table based on query formation in the report 

you can use @aggregate_awareness in the select statement for an object

 

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers   Nucleus Software,

We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  

Why do we need metrics and sets?

1 Answers  

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

0 Answers  

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,

5.what is LOV? where it is store?

3 Answers   TCS,

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

what is meant by scorecards?

2 Answers   TCS,

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

2 Answers   Infotech,

what are they different types of report in BO?

6 Answers  

who r the users in B.O.XIR2?

2 Answers   PCS,