| 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  |
| Shaik.emambasha |
| |
| |
| Answer | While opening the designer,a BO patents page appear which
shows the version of BO  |
| 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  |
| 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  |
| 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.  |
| 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.  |
| 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  |
| 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.  |
| Janardhan |
| |
| |
| Answer | It can be derived fro the Aggregate function.it convay the
numeric information by Dimesion object can be meassured  |
| 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.  |
| 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  |
| 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.  |
| Mithru |
| |
| |
| Answer | Global Filter will affect whole Report But local filter
will affect selected both only.  |
| 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  |
| Gobi |
| |
| |
| Answer | As part of universe parameters increase the array fetch
size and try to use aggregate awareness.  |
| 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  |
| Sridhar |
| |
| |
| Answer | By using drill down functionality additional components
will be added in HTML Tag.  |
| Narsi |
| |
| |
| Answer | You can link thru Hyperlink option  |
| 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  |
| 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.  |
| 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.  |
| Prasanna.ramesh1 |
| |
| |
| Answer | not known  |
| Sridhar |
| |
| |
| Answer | Integrity Check is the option through which one can test
the universse in BO.  |
| 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
 |
| 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.  |
| 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.  |
| 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.  |
| Preeja |
| |
| |
|
| |
|
Back to Questions Page |