-
-
How to Implement the the Built-in Strategy Script in BO Designer?
Kumaresh Goplsamy
- Jul 25th, 2007
Hi,universe is provided with default strategy also known as built in strategy.if you want to create new strategy, edit the .SBO file and mention your strategy ,and this strategy ...
mayuri
- May 4th, 2006
Using quick design wizard for developing the universe will invoke the built-in strategy
-
Hi AllCan any one explain the Aggregate tables and how is that helps in fine tunning the performance, Please give an example not the one which is in PDFs.Appreciate your help.Thanks All
Kumaresh Goplsamy
- Jul 25th, 2007
Hi, Aggregate table is a pre defined table.calculate the aggregates and store the values in one table.Instead you ask query to generate aggregate every time you just give reference to...
Sravan Gopisetty
- Sep 14th, 2006
Hi,Is that Aggregator Transformation or Aggregator Tables.If it is Aggregator Transformation then it CALCULATES the summery values like SumSAl,AVGSAL,MAXSAL,MINSAL FOR EACH GROUP WISE.FOR EXAMPLE...
-
-
What are the security level used in BO?
jgd.ramesh
- Aug 15th, 2007
They are two type of security in BO, first one row level security and another one column level security, this is to hide object?any doubt contact with me jgd . ramesh @ gmail . com
Kumaresh Goplsamy
- Jul 25th, 2007
There are four security level used in BO1.Database level security2.Row level security3.Table mapping4.Security table---------------------------Thanks & regards,Kumaresh Gopalsamy.
-
-
Cartesian product
A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
ravi_kumar_garre
- Nov 13th, 2007
Table A having m records and Table B having n records then the cartesian prodcut is mXn. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
Reen
- Oct 11th, 2007
Cartesan product is the result of a query when the two tables are not joined by any type of join. All the possible combinations of one table are displayed with the other table just like a cartesan product in algebra
-
Connection
Set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and path to the database. Designer provides three types of connections: secured, shared, and personal.
ravi_kumar_garre
- Nov 13th, 2007
BO Designer supports three different types of connections, each denoted with a unique symbol in the list of connections:1. Personnal connections that users may create for freehand SQL or that universe...
sithusithu
- Jan 27th, 2006
A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database.Cheers,Sithu
-
Detail object
An object qualified as a detail provides descriptive data about a dimension object. A detail object cannot be used in drill down analysis.
ravi_kumar_garre
- Nov 20th, 2007
A Detail object provides additional information about a particular dimension. A Customer dimension, age, fax, phone number, street address and direct mail are typical details. Details and attributes m...
sithu
- Apr 19th, 2006
Defined role that object takes when used in the Query panel. You can qualify an object as being one of three types:DimensionDetail Measurel detail objects holds more information about you measure and dimension, but you can't drill that based on your detail objectsCheers,Sithu, sithusithu@hotmail.com
-
Enterprise mode
A work mode whereby a designer creates universes in an environment with a repository. The mode in which a universe is saved determines whether other designers are able to access it. By default, a universe is saved in the mode in which the designer is already working.
ravi_kumar_garre
- Nov 20th, 2007
Within BusinessObjects enterprise, user names can be authenticated against one of more security databases. The default authentication source is Enterprise. However, if your company uses Windows NT, for example then NT user name and password can be used to log into Designer. Cheers,Ravi Kumar Garre
sithusithu
- Jan 30th, 2006
Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them.Cheers,Sithu
-
How do you design a universe?
The design method consists of two major phases. During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.During...
ravi_kumar_garre
- Nov 21st, 2007
Universe Design as follows:Define Parameters -> Insert Database Schema (tables, columns..etc)->Make the Joins->Resolve the loops->create classes and Objects->Hierarchies.Then test the universe for integraty.Cheers,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
sithusithu
- Jan 27th, 2006
The design method consists of two major phases.During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and t...
-
What are the precautionary measures you will take in the project?
sar
- Apr 23rd, 2007
Most important, Backup and maintain versions
-
What is slicing and dicing in business objects?
arunabala
- Feb 26th, 2008
HiSlicing and dicing means switching the position of data in the report, two swap two variables horizontally, we can swap rows to columns or columns to rows, very easy to do master detail reports.
raysgowda
- Feb 26th, 2007
Slice and Dice is used for extensive data analysis.
-
Designer
In real time environment what do we get from the client for the development of universe. provide me with an example document.
Noel Lastra
- Mar 3rd, 2008
I agree, just to add after receiving the functional specifications you start with your technical specifications, then you can create your Data Model.
sreenivas27
- Feb 4th, 2008
Hi In real time we get functional spec so that we can create universe based on user requestsSreeni.
-
What are the tools are in BOXIR2
-
What type of architecture does Businees Objects 6.5 follow?
jagsganti
- Apr 3rd, 2008
It has both 2 tier and 3 tier arch. Desktop and web reporting is possible with these 2 types of arch's
Anil kumar Saka
- Sep 21st, 2007
3-tier architecture
-
What are the main issues handled by the designer, while creating a Universe?
jagsganti
- Apr 3rd, 2008
There will be not be issues that are handled at creating universe. Things to be taken care by designer are1. Avoid un-necessary import of tables from schemas to the universe.2. In case of ...
-
AS OF DATE Filter to automate
Hello Guys,I am creating a WEBI from my universe which is using ORACLE database as backend. I have the following query which i need to automate. For that i need to create a filter in the unvierse i don't know which statement i should write in the universe filters.SELECT WMB.DEPOSITS_TXN_DETAIL.AS_OF_DATE, WMB.DEPOSITS_TXN_DETAIL.TXN_CODE, WMB.DEPOSITS_TXN_DETAIL.TXN_POSTING_DATE, WMB.DEPOSITS_TXN_DETAIL.SYS_SUB_PROD_CD,...
Balajikaadi
- Jun 11th, 2008
Hi,This can be handled as a condition object. Understand from the filter name (as of date) The condition object query should only contain the below statement. But of course.. you should have the assoc...
-
Dimension object
An object being tracked in multidimensional analysis; the subject of the analysis. Dimensions are organized into hierarchies.
shailesh.suman
- Aug 15th, 2008
A dimension is an object that is a focus of analysis in a query. A dimension maps to one or more columns or functions in the database that are key to a query. For example Country, Sales Person, Products, or Sales Line.
ravi_kumar_garre
- Nov 20th, 2007
A Dimension object is typically textual information by which users analyze the numeric measures, such as product, region, or month. A dimension object often comes from the lookup or reference tables w...
-
Hyperlink in Webi reports
Can any body says how to link 2 reports using hyperlink in webi reports ?
nishamakhija21
- Aug 22nd, 2008
To link 2 report I can explain with example, say you have 2 reports: "Primary Report" and "linked report", say you have 'year' and 'revenue' objects in primary report, and you wanna apply link on 'yea...
BO Designer Interview Questions
Ans