How do we test the reports in the business objects? How to creates the tabs in the reports?
You can test the report by running the query in SQL*PLUS/TOAD and checking the results.
In the central mangement consol one can test the report. jsut go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can chk from the bo.
What is report template in b.O?
in addition to the above report template is saved with .ret extension.
Report Template is a specimen for your future reports.You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same...
How to schedule the report in b.O?
You can schedule the report in
BO -------- BCA (Broad cast agent)
BO XI onwards -------- CMS (Control Management Server)
VBA Macro
we can schedule the reports through broadcast agent.
If you want to link marketing.uni with sales.uni, you must export the both universe by using export option from File Menu. Then open any one universe sales.uni or marketing.uni. Then apply following s...
There are two ways:1) At universe level we can link universe by parameters->Link option. The univese which is linked is called as derived universe and we cant manipulate it.2) Inculde Universe- Whi...
Can you please clarify the difference between compatible and incompatible objects?
i think we get the incompatible objects when they are not set with a proper cardinality
Hi folks,when you define context in Designer you should tell Query that which context to follow if more then two paths available.If you are selecting the object to different tables and one of the obje...
Give the notes and functionalities of cascading prompts,@script in business objects
@prompt: is useful to create dynamic filter. @prompt('message','type','lov','mono/multi','free/consistent','persistent/nonpersistent',default)cascading prompt:  one prompt is depending on another pr...
Cascading Prompts - Using of values in one prompt to filter the values in the other prompt.@script - It returns the result of a VBA Macro (Visual Basic for Applications Macro). ...
Cursor for loop is a loop where Oracle implicitly declares a loop variable, the loop index that of the same record type as the cursor's record.
A cursor for loop can be used instead of explicit cursors. A cursor for loop implicitly opens, fetches rows, closes a cursor.
The cursor FOR loop is a shortcut to process
explicit cursors.
Implicit open, fetch, exit, and close occur.
The record is implicitly declared.
%rowcount%notfound%found%isopen
Cursor attributes when appended to the cursor name allow the users to access useful information from the retrieved rows. After opening a cursor a 'fetch' statement is used to fetch rows from the...
%ROWTYPE - returns number of the rows which are fetched/updated/deleted
%ISOPEN - returns true if the cursor is open
%FOUND - returns true if the cursor fetched any row
%NOTFOUND-returns true if the cursor does not fetch any row
Difference between an implicit & an explicit cursor.
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor for loop.Explicit cursor is a cursor in which the cursor name is explicitly assigned...
Whenever a DML operation done there is a implicit cursor present. Explicit cursor is defined by user. Whenever a query runs implicit cursor automatically runs. User have no control on it and can not o...
A) A cursor is a pointer to the results of a query run against one of more tables in the database. IMPLICIT CURSOR : PL/SQL declares and manages an implicit cursor every time you execute a SQL DML s...
When do you use where clause and when do you use having clause?
Having clause is used when you want to specify a condition for a group function and it is written after group by clause. The where clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before group by clause if it is used.
we have to apply the condition Before grouping the records then you have to use WHERE clause.
we have to apply the condition after grouping the records then you have to apply HAVING clause.
Thanks & Regards
K.Santhosh
The WHERE clause is a conditional construct used to restrict or limit rows based on some condition.If the condition is satisfied then the filtered rows are returned as output. Consider this exam...
There is a string 120000 12 0 .125 , how you will find the position of the decimal place?
Instr('120000 12 0 .125',1,'.')output 13
Select instr(1200120.125, '.')
from dual
Regards
Dharmendra Jaiswal.
select instr(12000120.125,'.',1) from dual;
How you will avoid duplicating records in a query?
By using distinct
Hi! I think its best option to avoid duplicating records in a queryselect * from empwhere sal in ( select sal from emp &nbs...
HIselect * from empwhere sal in (select sal from emp group by ...
Can a primary key contain more than one columns ?
Yes, a primary key can contain more than one one column. Per EF Cobb's definition, a primary key is the sole candidate key on a relation variable (table) formed from one or more attribute values (c...
in some situations...
if the selected primary key column contains unique row elements..
need only one column....
if it contains any duplicates...then we take two columns
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
NH
The Problem is in your schema. Please check your joins, and cardinalities
also check loops.
Whenever cardinalities is not set proper its give you three types of error.
1-->Incompatibility result
2-->Ambigeous result
3-->Cartiesum result
To prevent cartesian product when running a report initially you can set it in the Universe Parameters.
File ----> Parameters ----> SQL tab ----> two options for Cartesian products 1) Prevent 2) warn (default) -----> click any one of them and then OK