-
Sub Reports within Report
How can we apply sub reports within a reports?
-
Compatible and Incompatible Objects
What are Compatible and Incompatible Objects?
amaresh1981
- Sep 10th, 2009
When an Object is same or higher level of aggregation with the table is known as Compatible Object.When an Object is lower level of aggregation or not at all related to the table then it is known as incompatible Object.
-
Errors While Creating Universe
Which type of errors/problems we may face/get while creating the Universe?
muralikrishna1982
- Aug 23rd, 2008
The most common errors while creating universes are cardinalities not okloops not okdivergence not okcheck integrity not ok
-
Errors while creating reports
Which type of errors/problems we may face while creating the reports?
muralikrishna1982
- Aug 23rd, 2008
The Most common errors in BO's while creating reports are1) Multi value column : this can be avoided by setting {Avoid duplicate row aggregation =True} in the properties of the pane, this is caused ...
-
Cascading and nested prompts
How do I create cascading or nested prompts
nishamakhija21
- Nov 10th, 2008
Hi,In Universe designer Go to Tools->List of Values-> Create cascading list of values.here u have option to define the Cascading list of values, suppose if u want to create cascading list like Y...
-
Link Between Datamarts
How to link between Datamarts?Which tools are used?
RishiBO
- Jan 18th, 2010
We can create a link between Data Marts by making use of ETL (Extraction Transformation and loading) Tool?job
-
Filewotcher in BCA
What is the use of filewotcher in BCA
sreenivas27
- Jun 18th, 2008
HiFilwatcher nothing it watch particular event like e.g Suppose you have updated database tables weekly and this log file update particular share folder so you have put filewatch to when they log file...
-
Input Context and Output Context
What is input context and output context? Where it is used?
nyjane
- Jun 23rd, 2008
BusinessObjects (BO) performs calculations in reports.To determine the result of an aggregate calculation BO defines an input context and an output context .Context :A context is made up of one o...
-
Bsiness Ojects (supervisors)
1.what is a calculation contexts2. what is a cardinalities3. what is a categories4. what is a channels5. what is a classes6.what is a combined queries
sreenivas27
- Jun 18th, 2008
Hello,you question related some designer, BO reporter so, could tell me exact question.Thanks.
-
Summary Table
What is Summary Table? On whch table we can use aggregate aware function?
prasanna.ramesh1
- Jul 24th, 2008
Summary table is nothing but aggrigate table.we generally apply agregareawaress on mesure objects.pls currect me if wrong.
-
Dimensional and Fact Table
Is it possible to use a dimensional table as a fact table also, if yes, how?
muralikrishna1982
- Aug 25th, 2008
Yes you can use. that is in the snow flake schema one fact table acts as a dimension to another fact table.
-
Multiple Queries
By using multiple queries how to synchronize the data in web intelligence?
prasanna.ramesh1
- Jul 24th, 2008
in web intelligence we generate multiple querys and stitch them together in single report.by using the synchronization method.write a query then select add query from report panel to add new que...
-
Testing a report
How will you test a report whether it is returning the correct results or not? in WebXIR2
michaelgaultner
- Aug 27th, 2008
I think we can do data validation test. Checking the summary results of the reports by writing
SQL query against database.checking the columns, fields, alignments, report look etc. satisfying the report required
specs.Correct me if i am wrong -
-
Alerters
What are alerters in BO?
sagarikaka
- Oct 29th, 2008
Alerters are used to draw attention to a block of data either by hightlighting or by displaying some messages near the cell.
-
ANSI92
What is ANSI92 and What is its usage?
sagarikaka
- Nov 5th, 2008
If the target RDBMS supports ANSI92, then you can set a universe parameter. ANSI92 support for joins created in your schema. When a universe supports the ANSI92 standard for joins, newly created joins...
-
Restriction on Max Rows
How can you restrict max no. of rows returned to a document?
RishiBO
- Jan 18th, 2010
You need to go to the Related Universe-->Universe Parameters-->Controls tab this controls settings allow you to limit the size of the reulst set and the execution time of queries.
-
Database Error while running query in Webi.
When I try to run query from Webi, I get an error of this kind:The database error text is: {error_db}. (WIS 10901)I'm using SQL Server 2000 DB and driver is ODBC.It is not retreiving data to the report.Somebody please help me to resolve this issue.....
tgmurugan
- Sep 29th, 2009
Have you created a DSN on the server (If using SQL server) or an entry in the TNSANAMES.ORA file for Oracle? Also make sure the ODBC connections are named exactly the same. "MS_ACCESS" is not the...
-
How can we migrate BO 6.1 repository to a multi schema database?
We have three different repositories on different databases. No we want to move all the three to single database by creating three different schema's.
prakharrajsingh
- Sep 19th, 2009
Though it is more of a DB migration centric question rather than BO repo migration.It depends completely on which Db is being used and what would be the target DB.in SQL Server you have to maintain se...
-
Restrict Data Based on Column Values
A report is accessible by 3 user and 1st user should only see the sales data of city A, 2nd can see only data of city B and 3rd user can see only the sales data of city C. How will you restrict data based on column values?
Sivakami_Plr
- Oct 29th, 2009
This can be done by applying row level security on CITY object. Create 3 restriction sets that limit access to respective city. Apply each restriction to each user.
Business Objects Interview Questions
Ans