Can anybady tell me , what is the aggrigate awareness.how to use it . could u pl

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

Question Posted / vinod3035

4 Answers
7488 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practi..

Answer / nagaraju

Hi Raju,
aggrigate awareness is a intelligent function in BO to
redirect a query to the desired comportable table on the run
time based on reporting side.
Eg: Year,Quarter,Month,Week

Is This Answer Correct ?

0 Yes

0 No

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practi..

Answer / veda

Aggregate Awareness is a funtion used in caliculations
where it is implemented in complex queries to improve the
performance of sql transformation. Mostly we apply this
function for summary tables.
eg; year,quarter,month,week ,day

Is This Answer Correct ?

1 Yes

2 No

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practi..

Answer / passion_bo

AggregateAwareness is the function used in BO Universe
Designer.It is used mainly to go to the minute details of a
measure from its higher details.

ex:
Consider a measure Consumption of a meter.We can read the
daily consumption and hourly consumption of the meter ,then
instead of using 2 separate dimensions for both daily and
hourly details of meter's consumption we can use a single
measure.

Is This Answer Correct ?

1 Yes

3 No

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practi..

Answer / shamanth

Aggregate Awareness is the process of including the
measure/fact values from its highest level to its lowest
level.

Year -> Month -> Week -> Day....

Is This Answer Correct ?

0 Yes

3 No

Post New Answer

More Business Objects Interview Questions

Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....

2 Answers

Give some information on report bursting?

0 Answers

Can any please explain FOR EACH AND FOR ALL?

2 Answers HCL, Infosys, TCS,

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers

What is #DATASYNC error how to remove it?

2 Answers IBM, TCS,

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers Exilant, Wipro,

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers CitiGroup,

What is scope of analysis ?

3 Answers L&T,

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

0 Answers

WHAT IS CARDINALITIES OF JOIN?