Page6
1.How to select different data providers in business objects?
Once you have your report generated, right click in the left window (your variables) click on "New Data Provider" follow the wizard. & you are done. If trying to use diff. data provider for different reports, after creating 1 report, right click on the Report1 tab located at the bottom, click insert new then the procedure is same to add data provider.
2.How to execute the plsql procedure from the report by clicking with mouse
We can select either tables or procedures or views as our data to generate our reports. In the designer in Bo we can select tab "insert" n select the particular data source for generating the report through mouse click.
3.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.......
4.What is report template in B.O?
Report Template is a specimen for your future reports. You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same colors your company uses for its documents, WebPages etc.) & then save it as BO Report Template file. Next time when you are creating new reports, & select use Templates option, your report saved as template will be listed in the box. If you select it, your new report will automatically use all color formats, & table-chart structures, logo....whatever you used in your template report file. Advantage : 1 time development of display & structure format, for multiple reports use. i.e. Time Saving. No need of formatting for all standard reports
5.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.
6.What is the difference between slice and dice and cross tab report?
Slice and Dice: Arrangement of Data Crosstab report is for Comparison.
7.Can you add the Cascading prompts in Business Objects?
If you select one prompt value based on that prompt value gives other lov (that lov value is have relate that 1st prompt value) you can select one or more from that value.
South (region) > TN, AP, kr, kl (state)
North (region) > nd, jk, hr, up (state)
If I select region south I can see only south region state. (This is cascading prompt)
It should create universe level.
Double click state object >
Edit properties > properties > edit
You can see the query pan, there pull down that region object and use that prompt conditions and save that
Now you click display button you can see how that prompts are working.
8.What is a derived table in data warehousing
Derived tables are not real tables at the Database level, but are the selection of few columns in the Table with some aggregations, specific to the report.
This feature is available in BO 6.5 and later versions.
Sel a1, a2, a3, max (a4)
From a ,
(Sel b1, b2, max (b3) as B3, Min (B4) as B4 from B group by b1, b2) as BX
where BX.B1= a.a1
group by a1,a2,a3
order by a1,a2,a3
The (Sel b1, b2, max(b3) as B3, Min(B4) as B4 from B group by b1,b2)Â in the above query is a derived table.
The same definition has to be added in the Universe - by going into Insert >> Derived Tables.
Type the Query - parse it and the new table inserted can be used to any type of join / Contexts etc in the Universe.
9.What is the difference between tabular report& cross tab report ?
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. Can we apply Rank and Sort at a time on a single report
No we can’t apply rank and sort at a time on one object in one single report. If we try to apply , BO asks if you want to over write the previous condition.
11. Which versions are used in the BO dashboard work?
Latest version
12. I have some queries that I have one project in bussiness objects, like computer peripheral(nrps) for sales, in that I have face question like what is the main objectives of ur projects
Answer Your objectives for this project will be your Report Requirements. whatever the requirements are baselined, you will develop the universes & create simple, complex reports. Requirements can be : Standard sales reports -- Location wise, product line /category wise etc.
Complex Reports -- some reports using multi-data providers, report level variables & using report enhancements with the help of SDKs(.NET /JAVA)
Ad-Hoc Reports -- Misc. reports which end users can create using your universes & are not the part of your Standard Reports.
& Overall Objective will be -----------------
Empowering the Key Decision Makers with historical Information in accurate, consistant,analytical format of flexible Reports (reports that can be sliced & diced as per requirements) for accurate & predictive Strategic Decision making.
13. How to select different data providers in business objects?
Answer Once you have your report generated, right click in the left window (your variables) click on "New Data Provider" follow the wizard. & you are done.
If trying to use diff. data provider for different reports, after creating 1 report, right click on the Report1 tab located at the bottom, click insert new then the procedure is same to add data provider.
14. What is a derived table in data warehousing?
Answer
it is similar to views, it is mainly used to restrict the datas
15. What is Business objects Repository? –
it is nothing but metadata.
16. What is domain? How many are there in a basic setup? What are they?
Domain is nothing but logical grouping of system tables, There are three domains usually in a basic setup, and They are Secure, Universe, and Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.
17. Can we have multiple domains?
- Yes. (Security domain can not be multiple).
18. How do you restrict access to rows of a database?
- In XI version it can be done by using row-level security in designer module whereas in 5i/6i it is done by supervisor.
19. What is a category?
It is nothing but grouping of certain entities.
20. How can we improve performance?
By making use of Aggregate tables.
Analysis in BO? –
Slice-Dice and Drill analysis.
.
21. 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.
22. Are Data mart and DWH normalized or demoralized ? 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.
23. What is a Data Cube ? What is its use ?
Data cube will present in BO tool.
Data cube is used for storing the data values which we are using in the documents. We can clear the data cube by using purge command. Data provider is used to retrived the datas from data cube to documents.
24. Can we apply Rank and Sort at a time on a single report
No we can’t apply rank and sort at a time on one object in one single report. If we try to apply , BO asks if you want to over write the previous condition.
http://www.newinterviewquestions.com/cat/Business-Objects-interview-questions/
25. 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.
http://www.geekinterview.com/Interview-Questions/Business-Objects/page9
26. 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.
26List of charts and graphs we can generate in Business Objects, with some supporting document (any supporting link or PDF file as it is to be sent to client)?
40.
27. What is domain? How many are there in a basic setup? What are they?
Domain is nothing but logical grouping of system tables, there are three domains usually in a basic setup, and they are Secure, Universe, and Document. Business objects are sometimes called domain objects (where the word domain means the business), and a domain model represents the set of domain objects and the relationships between them.
28. When is the Repository created?
In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.
29. Can we have multiple domains?
Yes. (Security domain can not be multiple).
30. How do you restrict access to rows of a database?
In XI version it can be done by using row-level security in designer module whereas in 5i/6i it is done by supervisor.