-
-
-
Join path Problem
What is joinpath problem?
venkatesh
- Dec 26th, 2014
JOIN PATH PROBLEMS
1)LOOPS
2)TRAPS
Loops can be resolved using 1)alias(can completely solve loops)
2)contexts(can only cover loop,not completely solve the loop)
Traps can be solved by using
1)chasm trap
2)fan trapmuralikrishna1982
- Aug 27th, 2008
The join path problems areee loops, chasmtraps, fantraps..these can be solved by using 1) visualising analysis of schema2) by using aliases3) by using contexts
-
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
-
Access to the report in BO designer
If we have a user group and we want to give the access to the report from 1990 to 2000. and from that group we want one user to restrict to see the report from 1990 to 1995. Then what to do in BO designer, so that this can be possible( Not in report level).
T.sreenivasulu
- Aug 15th, 2014
Best answer is using row level restriction for 1990 to 1995
vishwanath_bhambure
- Jul 15th, 2014
Restrictions are joined by default by "AND" Clause. So, If user has subscribed to two restriction that two restriction will joined by and for that user. So suppose current user is member of two restri...
-
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...
-
In what situation we have to use alias& and in what situation we to use contexts?
T.Sreenu
- Jul 2nd, 2014
Alias is to resolve the loop between three tables and one Fact table , context is used to resolve loop between three tables and more than one fact Table
purvanshu
- Jan 26th, 2014
Hi.... Hope it is useful..... Alias use to solve Fan Traps problem in Fan Traps problem 3 tables will be participate, table A connected to table B with one-to-many relationship, table B connected to...
-
What is method overriding?
Derived has the same method as that of super class method
purvanshu
- Jan 26th, 2014
Same method name with same signature (return type,arguments..) in both super class and subclass is method overriding.
-
Isolated joins in universe
What are isolated joins? whether there will be any problem if we have isolated joins in our universe?
-
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 ...
-
What is the difference between BO and Web intelligence
Mohd Sarim
- Jul 13th, 2011
Info view is nothing but another name of web intelligence. we also call it BO thin client.
DeskI is thick client as we need software installed on the system to access BO reports etc whereas in case of WebI the BO installed on the server and we need to access it through our browserKumaresh Goplsamy
- Jul 25th, 2007
Infoview is a portal to access the Business Objects in Web intelligence.? Business Objects???????????????????????????????????????????????????????????????? ??? web intelligence1.Multiple data providers...
-
Hai..... i hvae linked 2 data provider..and generate the report ..in that report how can i find the which data is comming from which data provider...?
sumesh
- Mar 7th, 2007
Go to View -->structure...Here you can find the data providers name in Map tab..
-
-
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
-
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 the difference between Aggregate Awareness and Index Awareness? Where are they used and how can be used?
gaurav07
- Oct 7th, 2010
Aggregate awareness: First understand the usage of aggregate awareness. information is store in database is in summary form.instead of recording the date and time each time a certain product is s...
-
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...
-
What is row level security
sri_emd
- Jul 29th, 2010
The measure of specifying which rows a user can retrieve based on a column of data or combination of columns is called row level security
Kumaresh Goplsamy
- Jul 25th, 2007
HI, It is a security implemented by the supervisor for accessing particular data from the database . This can be done by 1.login to BO supervisor .2.Go to universe tab3.select the&nbs...
-
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
-
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
BO Designer Interview Questions
Ans