ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
what is the syntax  for aggregate awareness?
 Question Submitted By :: Dinesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the syntax for aggregate awareness?
Answer
# 1
Aggregate awareness is a feature that makes use of 
predefined aggregate tables to enhance the performance of 
SQL transactions. It is used to improve the speed by which 
aggregates are calculated in the database. To set up 
aggregate awareness in a universe, you define or more 
objects using the @Aggregate_Aware function. The syntax for 
this function is as follows:
	
@Aggregate_Aware(aggregate_table_1, ... aggregate_table_n)

The arguments of this function are all the names of 
alternative aggregate tables. When you formulate the 
syntax, you should be aware of the order of the arguments. 
The precedence is from left to right; this means that 
BusinessObjects determines the aggregate to use beginning 
from the leftmost argument.
 
Is This Answer Correct ?    7 Yes 2 No
Kshatri
 
  Re: what is the syntax for aggregate awareness?
Answer
# 2
@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))
 
Is This Answer Correct ?    10 Yes 0 No
Vams_gk
 
 
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
How to link one location universe to other location universe TCS3
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it? Keane-India-Ltd3
how can we build one report from two data bases IBM2
How to hide the table s in webi?can any one tell me plzzzzzzzz TCS6
What is the use of BO SDK?  4
6.what is conformed dimension? R u used? TCS6
what are the differences between web intelligence reports and crystal reports ? AG-Technologies2
How can you access your repository with different user profiles? TCS1
What is the use of Surrogate Key in BO? IBM1
whats the diff between break and section TCS2
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?  2
while migrate bo 5.1 report into boxir2 ,what are the problems faced  2
how to create a derived table in designer? i need steps regarding derived table  1
Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function? iFlex2
what is master-detail report TCS2
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...  2
What is the degenerated Objects?  2
7.what is data mart? TCS6
how to hide the prompts? TCS6
wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence? Target3
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com