Business Objects - DOC

Document Sample
Business Objects - DOC Powered By Docstoc
					BUSINESS OBJECT
Question 1: a) Create a new BO report based on the Evaluation Kit universe, with the following objects:

Save this report as EVALKIT Report. [2 marks] b) Modify the Data Provider so that the report includes only US Customers. [2 marks] c) Change the formatting of the Table Header, as follows: Font=Tahoma, Size=9, Bold, Font Color=Black, Background Color=Red. [2 marks] d) For other cells, apply this formatting: Font=Arial, Size=8, Font Color=Black, Background Color=None. [2 marks] e) Add a new column which will count automatically the row number (first column) and re-arrange the report columns, as shown in the screenshot below.

[4 marks] f) Rename this current tab sheet as EVALKIT - Tab 1. Duplicate this EVALKIT - Tab 1 tab sheet and rename it as EVALKIT - Tab 2. Duplicate this EVALKIT - Tab 1 tab sheet and rename it as EVALKIT - Tab 3. [2 marks]

Page: 1/10

BUSINESS OBJECT
g) In the EVALKIT - Tab 2 tab sheet, apply a dynamic filter so that customers having at least 1 guest are displayed in the report. Make sure your report looks like the screenshot below:

[3 marks] h) In the EVALKIT - Tab 2 tab sheet, list the customers, starting first with the highest number of guests and ending with one having the lowest number of guests. [2 marks] i) In the EVALKIT - Tab 2 tab sheet, reproduce the screenshot below - add the total number of customer, total number of guests and its percentage (its format must be to 1 decimal place).

[6 marks]

Page: 2/10

BUSINESS OBJECT
j) In the EVALKIT - Tab 3 tab sheet, create the following chart as shown below.

NOTE: All customers must be displayed, irrespective of their number of guests. You must add a title and a legend. [5 marks]

Page: 3/10

BUSINESS OBJECT
Question 2: a) Create a new BO report based on the Island Resorts Marketing universe, with the following objects:

Save this report as Island Resorts Marketing Report. [2 marks] b) Modify the Data Provider so that the report excludes the following Service Lines: Poolside Bar and Restaurant. [2 marks] c) Reproduce the screenshot below:

Hint: Display the Revenue values into the # ##0 format (e.g. 135 232) and compute the total of the Revenue values in the last row of the table. Arial – font size 10 must be used for report display. [4 marks] d) Rename this current tab sheet as Marketing - Tab 1. Duplicate this Marketing - Tab 1 tab sheet and rename it as Marketing - Tab 2. Duplicate this Marketing - Tab 1 tab sheet and rename it as Marketing - Tab 3. Duplicate this Marketing - Tab 1 tab sheet and rename it as Marketing - Tab 4. [2 marks] e) In the Marketing - Tab 2 tab sheet, show these info:

Page: 4/10

BUSINESS OBJECT

[2 marks] f) In the Marketing - Tab 2 tab sheet, change the Service Bungalow to Villa in all the data rows. [4 marks] g) In the Marketing - Tab 2 tab sheet, copy the first table and paste the second table, next to the first one.

Also, list only the 3 services having the lowest revenue, in the right hand table. [5 marks] h) In the Marketing - Tab 3 tab sheet, apply a dynamic filter on the Service column which will exclude all those starting with ‘H’. [5 marks] i) In the Marketing - Tab 3 tab sheet, put a section on the Country object.

[3 marks] j) In the Marketing - Tab 4 tab sheet, display the following service lines: Accommodation and Recreation. [2 marks] k) In the Marketing - Tab 4 tab sheet, reproduce the screenshot below: Page: 5/10

BUSINESS OBJECT

[6 marks]

Page: 6/10

BUSINESS OBJECT
l) In the Marketing - Tab 4 tab sheet, apply some color formatting on the Revenue values:  If revenue < 10 000, font color = Red  If revenue >= 10 000 and revenue < 50 000, font color = Blue  If revenue >= 50 000 and revenue < 100 000, font color = Orange  If revenue >= 100 000, font color = Green

[8 marks]

Page: 7/10

BUSINESS OBJECT
Question 3: a) Create a new BO report based on the Island Resorts Marketing universe, with the following objects:

Save this report as Sales Report. [2 marks] b) Make sure that your Data Provider only returns data satisfying the 2 criteria:  Year = FY94 and FY95  Resort = Bahamas Beach [2 marks] c) Re-arrange the report columns, as shown in the screenshot below. Make sure that all the columns are displayed on 1 page wide.

[2 marks] d) Rename this current tab sheet as Sales - Tab 1. Duplicate this Sales - Tab 1 tab sheet and rename it as Sales - Tab 2. [1 mark]

Page: 8/10

BUSINESS OBJECT
e) In the Sales - Tab 2 tab sheet, insert a new column (rename it as Year – Week) which will concatenate the 2 objects Year and Week. Reproduce the screenshot below:

[2 marks] f) Rename the current data provider as Sales Query. [1 mark] g) Create a new tab sheet and name it as Sales - Tab 3. Create the following cross table with the 3 objects: Year, Service and Revenue.

Make sure that this tab sheet is in landscape mode and all the data fits on 1 page wide. [3 marks] h) In the Sales - Tab 3 tab sheet, reproduce the following chart (it must be below the cross table) :

[3 marks]

i)

Add a prompt on the Service Line object. The prompt name is as follows: Concerned Service Line(s):

Page: 9/10

BUSINESS OBJECT
Refresh the report with those 3 Service Lines:

Service Line Accommodation Food & Drinks Recreation
[3 marks] j) Create a new tab sheet and name it as Sales - Tab 4. Create the following cells, which display the name of the data provider, its execution date and the parameters selected for the Concerned Service Line(s): prompt.

Hint: The 3 left-hand side cells contain only labels and the 3 right-hand side cells contain BO functions. [6 marks]

Page: 10/10


				
Kevin  Soopramanien Kevin Soopramanien Mr www.google.com
About Hello. I am Kevin. I am interested in the security aspect of information systems. I have been doing some research papers which i will be posting here. I hope it helps :) Cars are also of great interest to me. So you can also find reviews here :)