Page4
1.Question when we use aggergate awarness function in designer?
1. In order to solve fan trap in business objects we either create alias table or aggregate awareness function
2. Through aggregate navigation we can also select the compatible as well as incompatible objects
Ex:-year, quarter, month, week, day
Year:-quarter, month, week, and day are compatible objects
Quarter:-year class is incompatible and month, week, days are compatible.
3. We specify the objects in descending order
2.What is difference between custom hierarchy and report based hierarchy?
By default one class having one hierarchy i.e. called report hierarchy. Custom hierarchy we can create in designer according our req.
3.Clearly explain the difference between union and group
The difference between union and group is as follows:
take two tables t1 and t2.in t1 we have columns like a,b,c,d. and t2 has a,d,e,f.so union means t1 union t2 i.e. getting result from both tables i.e. a,b,c,d,e.,f
where as group performs on a individual column in a particular table.
4.What is difference between custom hierarchy and report based hierarchy?
By default one class having one hierarchy i.e. called report hierarchy. Custom hierarchy we can create in designer according our req.
5.Explain the difference between union and group
Take two tables t1 and t2.in t1 we have columns like a, b, c, d. and t2 has a, d, e, f .so union means t1 union t2 i.e. getting result from both tables i.e. a, b, c, d, e, f where as group performs on a individual column in a particular table.
6.How to generate the report from excel sheet?
Start BO,
Select "Others" on Data Providers wizard page,
From drop down menu, select "personal 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.......
7.What is the difference between slice and dice & drill through
Slice and dice allows us to show and hide the objects Where as drill allows us to drill the data like drill up, drill down, drill through depending upon the user requirements.
8.What is the difference between slice and dice and cross tab report?
Slice and Dice: Arrangement of Data
Crosstab report is for Comparison.
9.What is the difference between tabular report& cross tab report?
Answer: - Tabular reports are a 2D format and Cross tab reports is a 3D format. Most of the operational/formatted reports will be created in tabular form and most of the analytical reports are created in the cross tab report form (Product VS Year VS Sales amount)
10. How to schedule the report in B.O?
We can schedule the reports through broadcast agent.
11. What is the use of BCA?
BCA is used to refresh and schedule and export and save as.html, .rtf, .xls, .PDF.
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.
12. How to schedule the report in B.O?
We can schedule the reports through broadcast agent.
13. What is the use of BO SDK? –
Bo SDK main use is to suppress “no data to fetch” using Macros
BO SDK is a software development kit.
14. What is BO Main Key?
Bo Main Key file contains the information about the repository site i.e. it contains the address of the repository security domain.
15. What are the general issues in migration process?
Alignment, performance.
16. What is REPORT BURSTING and how to do it in BCA as I have to split the report and send diff reports to diff people
If some part of the data in your report is sensitive, you can't risk sending the whole report to everybody, even to those who need to see the least sensitive 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.
17. Can someone please let me know the things we can do in WEBi and cannot do it in FULL CLIENT and vice versa for BO6.5
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 macros\addins but I am not sure whether we can do the same in WebI or not.
Please revert back if these are wrong
18. What we can do in WebI and cannot do it in FULL CLIENT and vice versa for BO6.5
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 macros\ad dins but I am not sure whether we can do the same in WebI or not.
19. Difference between ZABO and Webi
ZABO is zero administrator businessobjects , which will be installed on your local m/c when any full client report in opened/edited from infoview . For this you don’t require any BO mainkey , key will be installed from BO server.Webi is also called as thin client , where -in you are create BO reports on web browser . Reports are only based on Universe .
Both are user in 3-trier architecture.
ZABO-Zero Administration BusinessObject means we don’t need to install BO to view the reports. while we open the reports through infoview the server installs the required components to your local machine. We don’t need any bomain key etc.
WebI is a web based application in BO. We will create web based reports in WebI(it’s a java based application). We can publish reports to personal & corporate by WebI and can save as pdf file.
20. How many ways we test the universe & Report?
By doing integrity check we can test universe & By coping report query and run in backend(oracle,sql server...) we can test the data by comparing both.
21. How do we test the reports in the business objects...
In the central management consol one can test the report.
22. How do we test the reports in the business objects? How to create the tabs in the reports?
In the central management consol one can test the report. Just go to the link http://ipadress:port no/businessobjects/enterprise11/admin/en/admin.cwr .every thing can check from the Bo.
23. How can we do load testing for WebI Reports? (Example if I have to test one WebI report for Concurrent users refreshing report at one time
You can do Load testing for WebI Reports using Load runner tool.
1) Install load runner in your system. (To use load runner you need admin rights).
2) Generate load runner scripts.
3) Use controller (which is present in load runner) to get the results.
Using load runner tool you will get these results:
a) Maximum Running Users: 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
24. How to break a Date field into Year, month, week, and day?(For example: I have a field INVOICE_DATE. Now I want to break it as Year, month..... I.e. in time dimension.) DO I need to have some changes in Universe?
Create objects in your universe with date functions.
Let's say your DB is Oracle. In your "Select" statement of new object called year, try
to_char(INVOICE_DATE, 'YYYY') similarly for month create object called month & repeat process, simply replace'YYYY' with 'MM' of 'MMM' in the select statement. & so on.
25. Can someone please give some information on REPORT BURSTING and how to do it in BCA as I have to split the report and send diff reports to diff people
If some part of the data in your report is sensitive, you can't risk sending the whole report to everybody, even to those who need to see the least sensitive 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.