-
-
What is Data Profiling in Business Objects?What is Data Synchronization in Business Objects?
VIKRAM KUMAR
- Mar 8th, 2018
Data profiling is a feature of SAP BODS. Data profiling handles the inconsistencies seen in data. When data comes in through a single interface, the program can validate data as it is entered. But in ...
smilley
- Dec 26th, 2006
data synchronisation is used to synchronise data from say 2 data providers :1 say all list of sent emails2 say all list of recd emailsyou can synchronise these 2 lists using merged dimensions in webih...
-
Can any one tell me if there is two user groups as follows.Group1user1 -------Report-1user2Group2user1 ---------Report-2user3The user group1 has access to report-1 and user group2 has access to report-2. then can the user1 of Group2 has access to report-1 .
gaurishastri
- Feb 7th, 2007
Yes, user 2 has access to report 1 provided there are appropriate rights to the group and the user. Always remember, Denial rights take over Granted rights.
BO GURU
- Feb 5th, 2007
Hi,Yes, the user will be able to see both the reports .
-
Why we are using Crystal Reports as a Reporting Tool in B.O XI instead of Desktop Intelligence. What are major advantages in crystal reports when you compared with desktop intelligence?
anil.ganga1
- Aug 13th, 2009
Crystal reports and business objects are two different reporting tools which will have their own reporting features. in some cases BO is better, in some cases Crystal reports is better.Using crystal r...
subramanyam
- May 28th, 2007
Because it have the more features than the bo reporting.in bo 6.5 we can't define the dynamic prompts. in crystal reports we can define DYNAMIC?? prompts.
-
What is Business Objects Auditor and what can you do by using Auditor?
nishamakhija21
- Nov 10th, 2008
Hi,In business objects we have Auditor Database, which is used to store the auditing information about every user.Like suppose if User U1 is running some report at what perticular time. or How many ti...
G.V.subramanyam
- Jun 3rd, 2007
In bo 6.5 they are 7 auditor tables created while ur creating a repository.the tables that can store the information about the users and their authentication.
-
What is canned universe and canned reports in bo?
chskumar
- Dec 24th, 2007
Canned reports means pre-defined reports given by the cleint....he wants the report in a specified format .i am sure that there is no canned universe there is always a ad-hoc universe onlyyy.............cheers sateesh
kiran
- Nov 19th, 2007
Canned reports are the Pre defined reports..where in which you get the requirement from the users through a requirement specification doc. I havent heard of a canned Universe....bcos every universe should be adhoc
-
What is incremental aggregation/2. What is rapidly changing dimension?3. How can we merge the two dimensions?4. Can we edit the lov’s? How many ways we can edit?5.What is the difference between rank and dense rank?6. Tell me the process of creating universe?7. How can you send webi reports to the repository?8. Have u created folders?9.What is the object? Difference between XI R2 and 6.5?10. How can we migrate from development server to productions server?
flipside
- May 20th, 2012
Incremental aggregation concept is required in incremental loading. For example, lets say we receive sales data weekly and the same data is stored in some fact table with monthly granularity. We might...
Tom Haughey
- Apr 30th, 2012
Ill answer the first three. An incremental aggregation (I think because I have not exactly used the term) is an aggregate in which the new aggregate rows are appended (added to the back of) previous a...
-
How do link two tables in Business Object?
mudit0506
- Dec 28th, 2009
Http://www.geekinterview.com/question_details/53973 The Question 6 has a better answer.Though its more specific to having an Outer Join but it tells you about creating Joins too.
arunabala
- Feb 20th, 2008
do u want to link two tables or two universes, please speicfy the questionIf u want to link two tables means just through cardinality we can join, that means we need to check when the two tables have ...
-
How to access LOV values in report?How to set Hierarchy in Universe?
RishiBO
- Jan 20th, 2010
Adding to the above Point:Setting Hierarchy in UniverseYou can use the Hierarchies editor to view, create and rearrange existing object hierarchies in your universe.Designer provides a set of default ...
sreya_1234
- Nov 12th, 2007
Accessing LOVs in the report:-Go to Tools -> Universes -> select a universe and click on "List of Values" -> select an object from the table -> display - here you will get list of values for the object which ypu have selected.
-
How would I export a report to Word?
Amit Sachan
- Nov 21st, 2007
Hi,this facility is not available in BO version 6.5 but if you want to do then you will have to make macro based report and you can write the exporting code behind the macro.cheers,Amit Sachan
-
Snow flake schema is normalized or denormalized? Explain how?
VAMSIKRISHNACH
- Dec 9th, 2007
Facts : Always normalised in both the schemasDimensions : Denormalised in StarDimensions : Dimension bcoz of which you are calling a particular star as snow-flake only is normalised but remaining dimension are denormalised
jayasudha.alvi
- Nov 7th, 2007
Hi,Snow flake schema is normalized, bcoz it is interlinked with other dimensions and it is having lot of complex joins, and takes huge database size? and ?the performance wise very slow it will take time a lot to retrieve the data?.cheersJaya
-
Explain scenario to get multiple values in a cell (multi value error)
prashantpurohit2000
- Mar 3rd, 2009
You can get multiple values in a single cell but only when you have prompt on the object as InList. When you run the report, you have to select multiple values from the list of values, now in report u...
rama krishna reddy
- Nov 27th, 2007
When you are trying to run multi valued multipull objects in the section then you will get the multi value error.
-
What is Scope of Analysis?
muralikrishna1982
- Aug 24th, 2008
Scope of Analysis will retrieve additional objects from the database based upon your definition as one level, two levels or none. but these additional objects will not be displayed in the report resul...
amjad.shaik
- Nov 13th, 2007
Scope of analysis is a multidimensional analysis technique through which u can set the analysis upto one leveldown,two level down etc.
-
What's the major difference between regular universe & metric universe?
mhreddy
- Jan 21st, 2008
In case of regular universe all the tables have to be joined. where as in case of Metric universe all the tables need not be joined, there can be isolated tables in universe.In metric universe object ...
avbaby
- Jan 4th, 2008
Regular universe is created when there is a need to create reports only using the universe.metric universe is created when we to create analytics from the universe.
-
To start the infoview what is the URL format to generate the report?
sahiti27
- Feb 13th, 2008
I also have similar query.If it is installed on a personal pc what are the steps to be followed in order to opn BO xi -InfovoiewAppreciate your help......
sreya_1234
- Dec 6th, 2007
Http://boexi:8080/businessobjects/enterprise11/desktoplaunch/“boexi” = server name“8080” = port number
-
Explain scenario where you would use theta Join in Business objects ?
chskumar
- Dec 24th, 2007
use of a theta join: let's assume that we have a customer_look-up table and Age_group look-up table in ur schmea u have a age column in ur customer table u need to match the age column with ...
ravi_kumar_garre
- Dec 20th, 2007
Hi Use of Theta join in BO:consider you have a table called "Customer" having AGE one column. And another table called "AGE_GROUP" with coulmns MAX_AGE and MIN_AGE. If you want to ...
-
Multiple data cubes for one report?
If we create a document from 2 documents or from 2 universes, can any one explain if the new document will have multiple data cubes or not?
manikandans25
- Feb 27th, 2008
You can get data from tow different universe and create a single report, provided there are common dimensions between the two datasets.1) Create New Report -> Create one universe -> Select objec...
asyq5
- Jan 2nd, 2008
You will have a data cube for each query in your BO document. So, if you have 2 dataproviders based on a different universe, you will have two datacubes. Your other part of the question "If we create a document from 2 documents" does not make sense
-
Query not returning any value?
What are the steps to take when the query will not return any value?
-
Using multiple queries in Webi
Can we combine the results from multiple universes/queries in the same block (table/crosstab/chart) in the webi report ?
prashantpurohit2000
- Mar 16th, 2009
Fisrt answer solves your most queries but one thing I would like to mention is you will be only able to pull all the dimensions from one query plus measures from both queries and merged dimension...
Girish Sabbi
- Feb 20th, 2008
You can use multiple queries in Webi same as in Deski. You can do so, by creating Query 1 from the first source (universe). Go to the Query Panel and click on add Queries. This would ask you whether y...
-
How do you hide column in the report
hari7878
- Mar 27th, 2008
There are two ways are there for providing security to the object.1.In designer on tools menu manage level security then to add what you want objects or groups or users if any2.In CMS Select the optio...
Praveen Vaddadi
- Feb 22nd, 2008
We can hide a specific column as follows:FORMAT -->TABLE --> Pivotthen select the column you need and click on the Hide button - PV
Business Objects Interview Questions
Ans