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
 
  Teradata (22)  Business-Objects (374)  Cognos (385)  Informatica (524)  Crystal-Enterprise-Suite (23)
  Actuate (19)  Ab-Initio (49)  Data-Stage (66)  SAS (273)  Micro-Strategy (8)
  ETL (136)  Data-Warehouse-General (148)
 


 

Back to Questions Page
 
Question
How will you know the version of Bo using designer?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
in designe select the file tab,then click on parameter tab
in that select summary tab then we will get the information
 by emam
 
0
Shaik.emambasha
 
 
Answer
While opening the designer,a BO patents page appear which 
shows the version of BO
 
0
Naresh Nookala
 
 
Answer
start-->all programs-->he re it shows the Boname with the 
version 

for example for BO Xir2 it shows BusinessObjects XI release 
2
 
0
Vams_gk
 
 
 
Question
Which command using Query Analyzer will give you the 
version of SQL server and operating system ?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
select @@version
 
0
Usha
 
 
Question
How can we acheive Correlated sub-query in Designer?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Wells-Fargo , Xxxx, Xxxxxxxx, Tccx, Infy
I also faced this Question!!   © ALL Interview .com
Answer
A correlated subquery is a SELECT statement nested inside 
another T-SQL statement, which contains a reference to one 
or more columns in the outer query. Therefore, the 
correlated subquery can be said to be dependent on the 
outer query. This is the main difference between a 
correlated subquery and just a plain subquery. A plain 
subquery is not dependent on the outer query, can be run 
independently of the outer query, and will return a result 
set. A correlated subquery, since it is dependent on the 
outer query will return a syntax errors if it is run by 
itself.
 
0
Prabha
 
 
Question
Explain in Detail about Measure Objects? and what is the 
use of it? How to create it?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
It is a numeric data.
 
0
Guest
 
 
Answer
Measure Object convey numeric information which is used to 
quantify a dimension object. A measure object returns 
numeric information. 

You can create a measure object by using aggregate 
functions such as,
1)Sum
2)Count
3)Average
4)Minimum
5)Maximum
 
0
NareshKumar
 
 
Answer
Measure objects retrieve numeric data, or data that is the 
result of calculations on data in the database. 
For example: No. of students in the Students Universe.
 
0
Janardhan
 
 
Answer
It can be derived fro the Aggregate function.it convay the 
numeric information by Dimesion object can be meassured
 
0
Subramanyam
 
 
Question
What is the local filter and global filter in bo's?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
To hide & display the data.
 
0
Guest
 
 
Answer
Local Filter is to single block to which it is created, but 
a global filter is to all the blocks which consists of that 
column
 
0
Prasad
 
 
Answer
a report can contain more than one block...same way
a document can contain more than one report.....
so if we see one report we have some blocks....
applying a report filter to only one block is local filter..
applying a report filter to all blocks is global filter...
in any report.
 
0
Mithru
 
 
Answer
Global Filter will affect whole Report But local filter 
will affect selected both only.
 
0
Santhosh.r
 
 
Question
What are the steps to taken care to improve the Report 
performance?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
The Report Performance can be improved by the following 
performance Requirements :
1- The Report should open within 10-15 Minutes 
2- The data should be available within 24 hours For 
Example - If there is some data error , it has to be taken 
in ETL ( Extraction , Transformation , Loading ). When the 
mapping got refreshed , the data should be fetched into the 
Reports within 24 hours
 
0
Gobi
 
 
Answer
As part of universe parameters increase the array fetch 
size and try to use aggregate awareness.
 
2
Swades
 
 
Question
How toconnect one to one report?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   iFlex
I also faced this Question!!   © ALL Interview .com
Answer
by bo report to bo report
 
0
Sridhar
 
 
Answer
By using drill down functionality additional components 
will be added in HTML Tag.
 
0
Narsi
 
 
Answer
You can link thru Hyperlink option
 
0
Sankarnarayanan05
 
 
Question
What is the drill up , drill down, drill by , drill 
trough ?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   TCS
I also faced this Question!!   © ALL Interview .com
Answer
drill-down means analysing the in different levels going to 
the down let us eg as year--->quarter,quarte---> month and 
so on
drill-up means analysing the in different levels going to 
the up let us eg as month--->quarter,quarte---> year  and 
so on
 
0
Prakash123
 
 
Question
How to create Universe using Flat file in BO6.0
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
If i am not wrong u can't create universe from a flat file 
but u can generate a report from a flat file. 
choose "personal data files" in the new report wizard 
instead of univese and input the file information.
 
0
Ravindra81
 
 
Question
What is  the test methodology for testing BO Universes?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   TCS , Cisco
I also faced this Question!!   © ALL Interview .com
Answer
we test universes by using integrity check .
or we can indivedually test loops,contexs,aliases.
 
0
Prasanna.ramesh1
 
 
Answer
not known
 
0
Sridhar
 
 
Answer
Integrity Check is the option through  which one can test
the universse in BO.
 
0
Handy
 
 
Question
What are steps to be taken care to create a good Universe?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
A Universe is a business-oriented mapping of the data 
structure found in databases: tables, columns, joins, etc.
  A Universe is a semantic layer between Database and end 
users.
   A Universe can represent any specific application, 
system, or group of users. For example, a universe can 
relate to a department in a company such as marketing or 
accounting.
   A Universe can also pertain to a section within a 
department or just about any set of organized procedures 
such as a payroll or inventory system. 
A Universe consists of a set of objects, grouped by classes.

Steps to be taken care to create :

Prepare : Know the data source

Analyze :Identify the needs of the end user population

Plan : Design the universe(s)

Implement : Create the universe(s)

Test  : Using a test team (including end users)

Deploy  : Distribute the universe to end users

Evolve : Adapt and extend universe over time


 
0
Janardhan
 
 
Question
What is pragma?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
A PRAGMA statement appears in a PL/SQL block. It is not an 
executable statement, but it provides instructions to the 
compiler.
 
5
Yandapalli.prasad
 
 
Question
In Microstrategy, how can you direct the sql generated to 
use a specifc table?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Lanco
I also faced this Question!!   © ALL Interview .com
Answer
By changing the Logical Size of the "specific" table. After 
changing table size, you need to update schema.
 
1
Kwwl
 
 
Answer
if it is required for metric to calculate from a particular 
table in report, you can try changing the "level"  in the 
merics.
 or by using relationship filter also can direct to a 
particular table ,based on the requirement.

modifying the logical table size is a good idea, but it can 
affect all reports which depends on the attributes defined 
on the same table.
 
0
Preeja
 
 
 
Back to Questions Page
 
 
 
 
 
   
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