1) we can create edit Universe in the full client but not in WebI
2)WebI has comparatively less functions to use than in Full client
3) In Full Client we can write macrosaddins but i am not sure whether we can do the same in WebI or not.
The main difference between fullclient and webi is in webi only universe can be used as source,whereas in fullclient we can freehand sql,stored procedures and xml dataproviders as source.
2. Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in
the same tier?
Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.
The data in the Datamart and DWH is Denormalized and optimized for OLAP systems
3. Explain How to schedule the report in B.O?
We can schedule the reports through broadcast agent.
4. Explain When to use local filter and when to use global Filter?
Think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report.
a global filter would apply to all blocks in your report, so if you had many tables the filter would apply to all of them
5. Explain What is the difference between slice and dice and cross tab report?
Cross tab report is like at the intersection of 2 dimensions measure is displayed.like if we have two dimensions year and product and a measure revenu,revenue is displayed at the intersection of year and product.
You can do Load testing for Webi Reports using Load runner tool.
1) Install loadrunner in your system. ( to use loadrunner you need admin rights).
2) Generate loadrunner scripts.
3) Use controller(which is present in loadrunner) to get the results.
Using loadrunner tool you will get these results:
a) Maximum Running Vusers: 50 ( Given by the testing person, you can increase virtual users if you want)
b) hits per second.
c)Average response time for every transaction like login,click on the particular link,logout etc.,
d) Errors per second.
e) Connections per second.
7. What is the difference between BoXIR2 and BOXIR3?
1.XIR3 can use Excel document as a data provider which was not possible in XIR2.
2.We can open XIR2 universes using XIR3 Designer but XIR3 universe cannot be opened using earlier versions of designer.
8. What is the difference between User And versatile user?
SUPERVISOR offers various types of users of Business Objects products. The user profile determines by default what products a user can use. User profiles can be customized to reflect the needs of the users.
User (all products but DESIGNER and SUPERVISOR)
Versatile (configurable)
USERs use the Business Objects end-user products to query, report, and analyze data. They may also use the optional REPORTER and EXPLORER modules for multidimensional analysis. End users can produce documents containing data from one or more data sources.
A versatile user is a customized user who may be given access by a supervisor to any combination of Business Objects products.
9. What are all difference between business objects 6.5 and XI R2?
I have found some differences b/w BO and XI and only the last is specific to XIR2
Difference between BO and XI
BO uses classic BO Architecture and XI uses crystal classic Architecture
BO uses 57 tables for BO repo and 8 tables for auditor where as XI uses 8 tables for CMS and 6 tables for auditor
BO has different security domains where as XI doesn?t has no different security domains
BO, all objects are stored in repository where as in XI Objects are physically stored in Input FRS and instances in output FRS
In BO after installing we have configure, create BO mainkey where as in XI it is install and start working
In BO classic key is an xml file and it has to be placed in relevant location where as in XI a key code is there
In BO if you want to save a report to repository you have to publish that report where as in XI if you click save as and select Enterprise
IN BO, BCA and supervision are entirely separate but in XI there are merged into CMC
IN XI there is no separate auditor is there but there is an auditor database where we can create tables based on that
BO has it?s own reporting toos where as XI uses crystal reports as it?s reporting tool
BO is user centric ? means rights are assigned to user where as XI is object centric ? means rights are assigned on objects level not user level
BO ? all reports are stored in categories, in XI infoview there is folder and categories but all main storage is in folders
In XI R1 there was no concept of full client but that concept is introduced in XI R2
10. What is difference between Webi and Infoview?
In infoview you can create a webi documents i.e wid documents, you can open, schedule, save it as an excel or pdf or business objects document(.rep).
Webi is a part of Infoview
Webi rich client is basicaly use as a windows application (Online as well as Offline)..Here No need for web connection.But
InfoView is a web portal of BusinessObjects where we can create reports in connected mode.It need web connection to run the reports.
11. What is a fantrap in Business Objects?
Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe.
Two Types of Loop Problem:
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table link eachother is in turn linked another one-to-many table.
2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single lookup table.
Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the loop.
FanTrap: resolved by alias. Two one-to-many joined table linked each other and in turn linked to one-to-many table.
If some part of the data in your report is sensative, you can't risk sending the whole report to everybody, even to those who need to see the least sensative part of report !
Solution is Report Bursting.
You can send reports to BCA for scheduled processing & distribution to users based on THEIR profiles (profile = user rights) & not based on your profile !
BO 5 & WebI 2.5 procedure to do this :
Open the document, click "Send to BroadCast Agent" on Doc Exchange toolbar.
In Actions tab select "Refresh with the Profile of Each Recipient"
In the Distributions tab select "Distribute via the Business Objects Repository. (only option to enable you for Report Bursting)
click To, select recipients,
Schedule it & OK.
In WebI 2.5...........
in Refresh options Select Scheduled Refresh & click send
on Scheduling Options, Set "Refresh According to the profile of each recipient" to Yes & OK.
13. Explain the difference between compatible and incompatible objects?
We can select or choose compatable n incompatable objects through aggregator navigation in the designer.
with this method the performance increases tremendously.
instead of checking for each n every object only the compatable objects are only looked for aggregate awareness.
year:-month,quarter,week,day are compatable but customer class is incompatable
Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relation ship etc.and document information
it is centralized and set of data structure that can be stored in databases.basically repository can be made up by 3 domains.
The DENSE_RANK function computes the rank of a row in an ordered group of rows. The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties. Rows with equal values for the ranking criteria receive the same rank.
The DENSE_RANK function does not skip numbers and will assign the same number to those rows with the same value. Hence, after the result set is built in the inline view, we can simply select all of the rows with a dense rank of three or less, this gives us everyone who makes the top three salaries by department number.
ex:
Give me the set of sales people who make the top 3 salaries - that is, find the set of distinct salary amounts, sort them, take the largest three, and give me everyone who makes one of those values.
SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/
DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3
20 SCOTT 3000 1 <--- ! (in case of rank JONES will have 3 and dense rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3
30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3
16. Explain Is there any default username & pwd for BO designer & supervisor?
When we install Enterprise Server, by default if we dont specify any password then it create "Administrator" userid with no password.
17. What is difference between custom hierarchy and report based hierarchy?
By default one class having one hierarchy ie called report hierarchy.Custom hierarchy we can create in designer according our req.
18. Explain What would you consider as your biggest achievement and why?
THOUGH my biggest achievement is still to be achieved ,and that would be if I am able to give all the happiness to my family along with a reputed professional position.
19. Explain the difference between detect alias and detect context?
we should use Detect Aliases and Detect Contexts to formally identify and resolve loops.
i.e.if a loop contains only one lookup table then the loop can be resolved by detecting the alias
if a loop is having 2 or more fact tables(multiple fact tables) then the loop can be resolved by detecting context
Detect alias: resolving fan trap
Detect context: resolving chasm trap
20. What is the difference between condition & filter?
Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)
Filters - are used to restrict the number of rows in the output.
Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.
For Eg: select cust_id from customer where cust_name like 'A%'
Filter is Cust_name like 'A%'.
Condition is also applied at report level.
If (cnt(cust_id) > 1 ;"Valid";"NotValid")
Object store is nothing but the container of object which is created after rpt file run once.
22. Explain How we drill up week to Month?
In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.
So if u again click over that - it would again compressed back to +. This is call drill up.
your Aggregation levels woudl b like
Year>Month>Week>Day>Hour>Minutes>Seconds.
So by changing the symbol from - to + at month aggregation level u can drill up.
23. Explain When we use aggregate awareness function in designer?
1. In order to solve fan trap in busines objects we either create alias table or aggregate awareness function
2. Through aggregate navigation we can also select the compatable as well as incompatable objects
Ex:-year, quarter, month, week, day
year:-quarter, month, week, day are compatable objects
quarter:-year?class is incompatable and month, week, day are compatible.
3. We specify the objects in descending order
24. How to generate the report from excel sheet?
Start BO,
Select "Others" on Data Providers wizard page,
from drop down menu, select "ersonal data files",
specify file location & check the box "First Row contains Column names" this will help you in creating Objects.
click Ok.
Start building your reports.......
BusinessObjects Enterprise lets you preview a report using thumbnails. You can request the server to take a snapshot of the first page of the report and return it to the browser as an image file. This image can then be displayed as part of the Report Details page.
To retrieve a thumbnail, a separate page needs to be created because the code that writes an image to the screen erases any text that may have previously been there.
