-
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...
-
Alias
A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
ASHOK1324
- Apr 19th, 2009
An alias is identical to base table with different name. The data in alias is exactly same as original table/but the different name tricks SQL into accepting that we are using 2 different tables. ...
Suresh
- Jun 25th, 2006
Actually, What happens in the back end?(i.e) in database end, while?alias?is performed, whether it points to one table or too many table. How the performance will be in universe level.Please help me by explaining with this concept correctly, because i faced?such question by interviewer.
-
Class
A logical grouping of objects and conditions within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.
ASHOK1324
- Apr 19th, 2009
A Category is grouping of certain entities [reporting objects]. A class is a category of reporting objects. A object is an instance of class or a reporting field [entity]. A class can be further divid...
harshadapj
- Jul 24th, 2008
Classes are folders that serve to organize data objects according to common business need. A class can contain any type of object, including another class, (i.e. subclass). The number of classes and s...
-
Context
A method by which Designer can decide which path to choose when more than one path is possible from one table to another in the universe.
rupesh.sivaguna
- May 28th, 2009
Context:Contexts are a collection of joins which provide a valid query path for Web Intelligence to generate SQL.Regards,Siva
-
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.
-
How to create Universe using Flat file in BO6.0
sekharregati
- Mar 13th, 2009
Of course, we can create Universe from flat file, by using EXTERNAL STRATEGIES,By using external strategies we are going to pull the meta data from flatfile and create the universe.
chennu
- Jun 15th, 2006
Hi..... how many fact & dimensional tables (max&min)can use in projects?
-
What are Universe requirements?
gaurav07
- Oct 7th, 2010
Universe requirements 1) Database connections which you manually select2) Classes and objects which maps the data from tables and columns of database3) Create or automatically extract joins4) Set card...
Nayef Almiseher
- Dec 4th, 2006
Hi ,First thing you have to create connection with the DataBase which you want to work on it .Then you can take tables and put them in the Universe and starting analyzing them .Regards ,Eng. Nayef AlmiseherSaudi Fransi Bank Saudi Arabia
-
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
-
Universe
A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, which is made up of classes, objects, and conditions, can represent any specific application, system, or group of users.
amaresh1981
- Sep 9th, 2009
An universe is an symanteic layer between the user and the Designer which contains connection of a database
ravi_kumar_garre
- Nov 21st, 2007
Universe is a Semantice layer that maps the data structure found in databases (tables, columns, views..etc) to Business Terms.Cheers,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in
-
What are the precautionary measures you will take in the project?
sar
- Apr 23rd, 2007
Most important, Backup and maintain versions
-
What are the steps to taken care to improve the Report performance?
Nidhii
- Mar 12th, 2007
Hi,I can explain why a report performance is increased when we apply a filter at the universe level rather than at the report levelWhen we apply a filter in the universe level,after the query is fired...
Latha03
- Jan 26th, 2007
Avoid applying filters unless and until there is a requirement from client side. Thus we can increase the performance of the reporter.
-
-
-
Isolated joins in universe
What are isolated joins? whether there will be any problem if we have isolated joins in our universe?
-
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...
-
Shortcut join
A join that links two tables by bypassing one or more other tables in the universe.
sreenu
- Jul 2nd, 2014
Shortcut join is a join , It is an alternative path between the tables .
By using shortcut join we can improve the performance of query and decrease the join path.ASHOK1324
- Apr 19th, 2009
A. short cut joins are used to improve the query performance at universe level i.e. for performance tuning. Suppose if we have 4 tables A,B,C and D A--->B---->C---->D and there is a chance to...
-
-
What is block? types of blocks?what is locking systm in universe?what is shortcut join where it is neccessary?
vengi
- Jun 1st, 2012
Shortcut join: direct joins b/w the two tables by eliminating the intermediate tables.......the main purpose of this join is improve the performance of the query
BalamuruganS
- Jun 1st, 2011
Locking of universes:When you are to import a universe , you will be going to File->Import.A dialog box opens where you can browse the universe you want to open.If you double click on the universe ...
-
How to create groups in business objects designer?
Tak
- Dec 4th, 2014
You can create Groups in CMC
sharmampooja
- Apr 28th, 2009
Their is no option to create groups in Designer, you have to use CMS to create groups.RegardsMohit
BO Designer Interview Questions
Ans