-
What are the tools are in BOXIR2
-
Derived Tables
How a derived table is useful than a view in database? What are the additional features derived table provides?
Divyaprashanth07
- Sep 4th, 2010
Derived table are created at the universe level. 1. They are usually created to fetch results from tables using a complex logic condition. 2. To get the Max/ Min date for the data set. Usually u...
smghurde2
- May 21st, 2010
Derived tables are tables that you define in the universe schema. You create objects on them as you do with any other table. A derived table is defined by an SQL query at the universe level that can b...
-
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
-
Document domain
The area of the repository that stores documents, templates, scripts, and lists of values.
ASHOK1324
- Apr 19th, 2009
The area of the repository that stores documents, templates, scripts, and lists of values.
-
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
-
Hierarchy
An ordered series of related dimensions used for multidimensional analysis.
ASHOK1324
- Apr 19th, 2009
Hierarchy is an arrangement of objects for report to report interactions [RRI]. It is used for drill-down and drill-up operations in universe design.
sithusithu
- Jan 27th, 2006
a series of dimensions used for analysis based on user requiermentsCheers,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 is the drill up , drill down, drill by , drill trough ?
drill up : One level up in the HirearchyDrill down: One level down in the Hirearchydrill by : direct selection of level in the Hirearchydrill trough : to drill data from one Hirearchy to another Hirearchy
pavanbo
- Jul 20th, 2010
Drill up means up in the hierarchy.Month:-Quarter:-YearDrill down means down in the hierarchyYear:-Quarter:-MonthDrill through means you can drill through to the database directly from drill mode and get the required dataDrill by means you can select one hierarchy to another hierarchy
sithusithu
- Jan 27th, 2006
Drill up : UP-one levelDrill down: DOWN-one levelDrill by : selection of level HierarchyDrill trough : Hirearchy to another HirearchyCheers,Sithu
-
-
How will you know the version of Bo using designer?
fani_ece
- Jun 22nd, 2007
Go to help and click About Designer in help, you will find it.
sithusithu
- Jan 4th, 2006
Select the component business object DesignerNow it will prompt for userid/password/security domainYou will find a Help button, click that and find out what ever you want Cheers Sithu
-
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
-
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?Database in use is Oracle.
pat.mclean
- Jun 14th, 2006
well adi,it is not a table name, but column name(sales_date).It can be any name depending upon your ETL process & naming convensions. if you have the database ready & you want to break yo...
Adi
- Jun 9th, 2006
Pat,Do i need to have some tabel selected like u have mention sales_date?
-
-
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...
-
Equi-join
A join based on the equality between the values in the column of one table and the values in the column of another. Because the same column is present in both tables, the join synchronizes the two tables.
Xinx0626
- Jun 28th, 2006
It is also called INNER JOIN
-
Loop
A situation that occurs when more than one path exists from one table to another in the universe.
sithusithu
- Jan 27th, 2006
A loop is a situation that occurs when more than one path exists from one table to another. Loops result in ambiguity in the design of a universe. Designer enables you to identify loops in one of two ways:aliesContextsCheers,Sithu
SM
- Oct 4th, 2005
Loop is a logical and pictorial representation of tables joined in such a way that the join's path begin and end with the same table.Usually such a table would return less number of rows and it is usually the intersection condition values.Loops are resolved by Alias Table.
-
Object
A component that maps to data or a derivation of data in the database. For the purposes of multidimensional analysis, an object can be qualified as a dimension, detail, or measure. Objects are grouped into classes.
kkishore
- Oct 21st, 2005
Object is nothing but templet of a class
-
Online mode
The work mode appropriate for a networked environment in which the general supervisor has set up a repository.
-
Repository
A centralized set of relational data structures stored in a database. It enables BusinessObjects users to share resources in a controlled and secured environment. The repository is made up of three domains: the security domain, the universe domain, and the document domain.
BO Designer Interview Questions
Ans