-
Universe Creation Issues
What are the common issues faced during creation of universe?
-
BOXIR2 Tools
Can any one tell me the tools and Complete architecture of BOXIR2? and also each tool is used for what purpose?
sagarikaka
- Jun 24th, 2009
BOXIR2 Tools:1. Business Objects Designer: Enables u to create universes.2. Desktop Intelligence: Allows you to analyze data, perform ad-hoc queries to fetch new data, and create reports. Often ...
Priyank Bhayani
- Jul 22nd, 2008
Universe designer is used to create universe which will be used in desktop intelligence to create reports. BO XI is also having an import wizard tool which will be used for taking backup in biar file ...
-
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.
-
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
-
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.
-
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...
-
Cardinality
Expresses the minimum and the maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0,1, or N.
ASHOK1324
- Apr 19th, 2009
Cardinality describes a join between 2 tables by stating how many rows of one table will match with rows of another table. It is very important to detect join problems and to create the contexts to co...
desaial
- Jun 26th, 2008
Cardinality means "How many instances of an Entity (on one side of the join) are related to the how many instance of another entity (on the other side of the join)"
-
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?
-
How to add aggregate tables to a schema in real time scenario
Anil saka
- Jan 22nd, 2009
If your question is to add aggregate tables in the schema then go to insert tables add the required tables in to the schema or you can add the tables by double clicking on the structure pane.
Tanveer Ahmed
- Jul 23rd, 2008
Hi,Aggregate awareness is the ability of a universe to make use of aggregate tables in a database. These are tables that contain pre-calculated data. You can use the @Aggregate_Aware function in the S...
-
Specification for designing Universe
In real time enviorment, what form of specification do we receive from the client for designing Universe?
Anil saka
- Jan 22nd, 2009
In general the allocated person will provide you all the details in TRS document.like :- Naming conventions of objects- Table names and column names- Joins and relations- conditions to create at universe level- Prompts if required
-
What do you mean by Drill Across?
Anil saka
- Jan 22nd, 2009
Drill is used?for multi dimensional analysis:Drill up : one level higher analysis with in the same hirerchyDrill down : one level lower analysis with in the same hirerchyDrill across : is used to analyse data across multiple hirerchies.
-
What are the best practices you need to follow while you are creating the Universe?
Anil saka
- Jan 22nd, 2009
Best Practices:1. keep the objects minimum2. follow the naming conventions3. use universe level conditions4. minimize joins5. aggregating the measure objects
rchrdrea
- Aug 22nd, 2007
Since you mentioned the term 'Universe' I am under the assumption that you are referring to Business Objects.The two best practices are "keep your universe simple", and "Align y...
-
Universe Parameters
What are Universe Parameters? What does the Parameters tab in Universe Parameters indicate?
sagarikaka
- Oct 30th, 2008
The Parameter tab in the universe indicates list of SQL parameters that can b set to optimize SQL generation.The parameters file is still used for many RDBMS specific SQL and connection parameters. fo...
sagarikaka
- Oct 30th, 2008
Universe Parameters are definitions and restrictions that you define for a universe that identify universe and its database connections, specify type of queries that can b run using the universe, and ...
-
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...
-
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...
-
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...
-
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 ...
-
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 tools are in BOXIR2
-
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.
BO Designer Interview Questions
Ans