-
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 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 ...
-
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 are derived tables.
chskumar
- Dec 27th, 2007
Derived tables are tables that you define in the universe schema. You createobjects on them as you do with any other table. A derived table is defined by anSQL query at the universe level that can be ...
-
Query not returning any value?
What are the steps to take when the query will not return any value?
-
How many alters can we apply in single column of a report and max no of alters for a whole report.
avbaby
- Jan 4th, 2008
On a single column maximum of 6 conditions can be applied. maximum 8 sub-alerters can be put in a single alert.additional info: BO supports maximum of 30 alerters in a single report.
-
Explain about Synchronization Error in Business Objects
hari7878
- Jan 14th, 2008
When you want to see the complex reports on that time you are using option called synchronization.On that time you are choose only comman column and the same data other wiswe it shows the error that e...
-
What is the difference between condition and filter? What is thumbnail?
bolladi
- Jan 19th, 2008
In short we can say,, Condition : Applied on the query(QP) to restrict data retrieved from the database... Filter : Applied on the report to hide the data which is already retrieved from DB
sarangoun
- Dec 5th, 2007
Thumbnail: A thumbnail is a small image, or a part of a larger image. Normally a thumbnail will be of a border background, or a background set, or a photograph. Clicking...
-
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.
-
How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc?
Pers.L
- Jan 23rd, 2008
1. In supervisor select the user to whom you will restrict. Right click on the universe in the resource pane and select disable.2. For restricting the class and objects, select the user and right clic...
-
Sub-Reports in a Report
How can can we apply Sub-Reports in a Report?
Pers.L
- Jan 23rd, 2008
Every report having some report tabs. The report tab which was created from the base report is called base report and nothing but the exact duplicate of the base report.
-
What is the difference between user and versatile user in superviser product?
I think user can work on all report in the document, but versatile user is a temparory user, so he work in particular report only.
BPatel
- Feb 1st, 2008
User : can have access of BO report product in terms of view, report, analyze, and query.versatile user: can have access of either of above but only if supervisor granted it.
sreya_1234
- Feb 1st, 2008
User profile - can access only Business Objects (Reporter).Versatile profile - This user is authorized to use any combination of products defined by a supervisor.
-
While resolving loops, how to decide whether alias or context to be used?
Amandeep
- Nov 3rd, 2007
If the dimension table involved in the loop is associated with more than one fact table, then for each fact table, an alias would be required for each dimension leading to a chaos. Contexts are advised in such cases, one for each fact tableFurther consider the scenarioFact1
-
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
-
BoXIR2 and Bo6.5
What are the differences between BoXIR2 and Bo6.5
arunabala
- Feb 20th, 2008
HiThe main difference is While installing BOXIR2 itself we create the repository, but in 6.5 after installation we will create repository2. in 6.5 the Security is Administrated by Supervisor&nbs...
-
How do we migrate Universes from 6.5 to XI R2 in Version Manager
arunabala
- Feb 20th, 2008
Through Import Wizard we can Migrate all the informationn from 6.5 to XIR2IF u want to check whether all the users and all the universes are migrated in XIR2 we can use report conversation...
-
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
-
How do you deploy the template to end users ?
How can the end user make use of the Report templates created by me, I should migrate the template into repository(if yes, how?).Also, I cannot include Images inside the template created.Kindly help me on the same.
manikandans25
- Feb 27th, 2008
The deployment of templates created can be done 1) Publish the report to the corporate documents of the users. 2) Publish the report to the user inbox . This can be done. After creating the report. File -> Publish to -> Corporate documents.
-
Business Object Security
What is an open-ended security?
hari7878
- Mar 27th, 2008
There are 3 types of security can be provided in business objects XIR2.They are 1.object level???????????????2.Folder level???????????????3.Global levelIf you have any query mailme to hari7878 @ gmail . comUpdated byHariprasad
-
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