BO Interview Question Answers

(1)

1. How to select different data providers in

1. How to select different data providers in business objects? ...business objects? ... ... 55

2. When we use aggregate awareness function in designer?

2. When we use aggregate awareness function in designer? ...66

3. What is Business objects Repository? ...

3. What is Business objects Repository? ... ... 66

4. Is there any other repository domain rather than...

4. Is there any other repository domain rather than...66

5. What is a

5. What is a Bo repository Bo repository ...66

6. What is domain? How many

6. What is domain? How many are there in a basic setup? are there in a basic setup? What are they? ...What are they? ... ... 77

7. When is the Repository created? ...

7. When is the Repository created? ...77

8. Can we have multiple domains? ...

8. Can we have multiple domains? ...77

9. How do you restrict access to rows

9. How do you restrict access to rows of a database? ...of a database? ... . 77

10. In a report can we hide a particular object?

10. In a report can we hide a particular object? ...77

11. Difference between compatible and incompatible objects? ...

11. Difference between compatible and incompatible objects? ...77

12. Can you please clarify the difference between compatible and incompatible objects? When we

will use these two?

will use these two? ...88..

13. 13. Detail Detail ... .... 88 14. Measure ... 14. Measure ... ... 88 15. What is an object? 15. What is an object? ...88

16. What is a loop? How can we overcome? ...

16. What is a loop? How can we overcome? ... ... 99

17. How

17. How does a does a context resolve context resolve a loop? a loop? ... ... 99

18. While resolving loops, how to

18. While resolving loops, how to decide whether alias or context to decide whether alias or context to be used? Describe be used? Describe ...99

19. What is the use of

19. What is the use of alias and context? Which is the alias and context? Which is the better for solving the loops? Why? Why webetter for solving the loops? Why? Why we

use alias

use alias and why and why we use we use context? context? ... .... 99

20. What is a Loop?

20. What is a Loop? ...99

21. What is a loop? How can we overcome? ...

21. What is a loop? How can we overcome? ... ... 99

22. How does an

22. How does an alias break a loop? alias break a loop? ...99

23. Create an alias to break a loop caused by shared lookup tables

23. Create an alias to break a loop caused by shared lookup tables ...99..

24. Determining when

24. Determining when an alias is not an alias is not appropriate to break appropriate to break a loop a loop ...99

25. What is a context?

25. What is a context? ...1010

26. What is the difference between

26. What is the difference between detect alias and detect context? detect alias and detect context? ...1010

27. What do prefer an Alias or a context? Why? ...

27. What do prefer an Alias or a context? Why? ...1010

28. What is a Chasm Trap?

28. What is a Chasm Trap? ...1010

29. What is a Fan Trap?

29. What is a Fan Trap? ...1010

30. How Do You Resolve a Fan Trap?

30. How Do You Resolve a Fan Trap? ...1010

31. What is a fan trap in Business Objects? ...

31. What is a fan trap in Business Objects? ...1010

32. What is an alias?

32. What is an alias? ...1111

33. How we drill up week to

33. How we drill up week to Month? Month? ...1111..

34. What is a join? Explain

34. What is a join? Explain different types of joins? different types of joins? ...1212

35. What’s universal join in BOs?

35. What’s universal join in BOs? ...1212

36. What is a join? Explain

36. What is a join? Explain different types of joins? different types of joins? ...1212

37. What is a join? Explain different types of joins? ...

37. What is a join? Explain different types of joins? ...1212

38. How achieve the many to many relation ship in Busi...

38. How achieve the many to many relation ship in Busi... .... 1212

39. What is the difference between condition & filter? ...

39. What is the difference between condition & filter? ...1212

Ex: Select values

Ex: Select values for a variable in for a variable in the report to appthe report to apply a simple filter ly a simple filter ...1313

40. What are Alerter, Filters, Breaks and Conditions? – ...

40. What are Alerter, Filters, Breaks and Conditions? – ...1313

41. How to filter repetitive values in the

41. How to filter repetitive values in the report to get distinct values? report to get distinct values? ...1313

42. When to

42. When to use local filter and use local filter and when to use when to use global Filter? global Filter? ...1313

43. Is there any command o

(2)

(3)

44. What is drill filter and its usage? How many types of filters are there? ...

44. What is drill filter and its usage? How many types of filters are there? ...1414

45. What is drill filter and its usage? How

45. What is drill filter and its usage? How many types...many types... ... 1414

46. What are the steps to do to use Alerts in BO?

46. What are the steps to do to use Alerts in BO? ...1414

47. Please explain about Alerts in Bo's,

47. Please explain about Alerts in Bo's, under what situation we need under what situation we need to use alerts to use alerts ...1414

48. What are Alerter, Filters, Breaks and Conditions? ...

48. What are Alerter, Filters, Breaks and Conditions? ...1414

49. Can you create

49. Can you create Alerts in WEB Intelligence? Alerts in WEB Intelligence? ...1515

50. Can you add the Cascading prompts in Business Objects? ...

50. Can you add the Cascading prompts in Business Objects? ...1515

51. Give the

51. Give the notes and functionalities of notes and functionalities of cascading prompts, @ cascading prompts, @ script in business objects script in business objects ...1515

52. What is Nested prompt and

52. What is Nested prompt and how to create this prompt? how to create this prompt? ...1616

53. What

53. What is a Universe? is a Universe? ... ... 1616

54. How

54. How do you do you design a design a universe? universe? ... ... 1616

55. What are Linked

55. What are Linked Universes? Universes? ...1616

56. In the BO universe, how to link two universe, like I have one universe in sales.uni and another is

marketing.uni ...

marketing.uni ...1616

57. Types of universes in business objects? ...

57. Types of universes in business objects? ...1616

58. How can you check the universe? ...

58. How can you check the universe? ...1717

59. What are

59. What are the user requirements in the user requirements in a universe? a universe? ... .... 1717

60. How can you check the integrity? ...

60. How can you check the integrity? ...1717

61. What are Universe parameters? ...

61. What are Universe parameters? ...1717

62. How can we improve performance? ...

62. How can we improve performance? ... .... 1717

63. How many universes can be created in a project ...

63. How many universes can be created in a project ...1717

64. In the BO universe, how to link two universe, like I have one universe in sales. uni and another is

marketing.uni ...

marketing.uni ...1717

65. What are

65. What are the user requirements in the user requirements in a universe? a universe? ... .... 1717

66. What are Universe parameters? –

66. What are Universe parameters? – ...1717

67. what all will be exported

67. what all will be exported to the repository, when we export a to the repository, when we export a universe ? universe ? ...1717

68. How many universes can

68. How many universes can be created in a project...? be created in a project...? ...1717

69. What is the size of data base?

69. What is the size of data base? ...1818

70. Dimension

70. Dimension Parameters for analysis. Dimensions Parameters for analysis. Dimensions typically relate to typically relate to a a ...1818

71. What is a Fact

71. What is a Fact Table Table ...1818

72. What is an aggregate table?

72. What is an aggregate table? ...1818

73. What is a Lookup Table?

73. What is a Lookup Table? ...1818..

74.

74. Classes Classes ...1818

76. Question when we use aggergate awarness function in designer?

76. Question when we use aggergate awarness function in designer? ...1818

77. What is

77. What is difference between custom difference between custom hierarchy and report based hierarchy and report based hierarchy? hierarchy? ...1818

78. Clearly explain

78. Clearly explain the difference between the difference between union and union and group group ... .. 1919

79. What is

80. Explain

80. Explain the difference between uthe difference between union and group nion and group ... ... 1919

81. How to generate the report from excel sheet? ...

81. How to generate the report from excel sheet? ... ... 1919

82. What is the difference between slice and dice & drill through ...

82. What is the difference between slice and dice & drill through ...1919

83. What is the difference between slice and dice and cross tab report? ...

83. What is the difference between slice and dice and cross tab report? ...1919

84. What is

84. What is the difference between the difference between tabular report& cross tab tabular report& cross tab report? report? ...1919

85. How to schedule the report in B.O? ...

85. How to schedule the report in B.O? ...2020

86. What

86. What is is the usthe use of e of BCA? BCA? ...2020

87. How to schedule the report in B.O? ...

(4)

88. What is

88. What is the use of the use of BO SDK? – BO SDK? – ... ... 2020

89. What is BO Main Key? ...

89. What is BO Main Key? ...2020

90. What are the general issues in migration process? ...

90. What are the general issues in migration process? ... ... 2020

91. What is REPORT BURSTING and how to

91. What is REPORT BURSTING and how to do it in BCA as I have do it in BCA as I have to split the report and send diff to split the report and send diff

reports to diff people

reports to diff people ...2020

92. 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 ...

CLIENT and vice versa for BO6.5 ... ... 2121

93. What we can do in WebI and cannot do it in FULL CLIENT and vice versa for BO6.5 ...

93. What we can do in WebI and cannot do it in FULL CLIENT and vice versa for BO6.5 ...2121

94. Difference between ZABO and

94. Difference between ZABO and Webi Webi ...2121

95. How

95. How many ways we many ways we test the universe test the universe & Report? & Report? ... ... 2121

96. How do we test the reports in the business objects...

96. How do we test the reports in the business objects...2121

97. How do we

97. How do we test the reports in the business objects? How to create test the reports in the business objects? How to create the tabs in the reports? the tabs in the reports? ...2222

98. How can we

98. How can we do load testing for WebI Reports? (Example if I hdo load testing for WebI Reports? (Example if I have to test one WebI report for ave to test one WebI report for

Concurrent users refreshing report at one time ...

Concurrent users refreshing report at one time ...2222

99. 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

INVOICE_DATE. Now I want to break it as Year, month... I.e. in time dimension.) DO as Year, month... I.e. in time dimension.) DO I need toI need to

have some changes in Universe? ...

have some changes in Universe? ...2222

100. Can someone please give some information on REPORT BURSTING and how to do it in BCA

as I have to split the report

as I have to split the report and send diff reports to diff people and send diff reports to diff people ...2222

101. How Do U Create Report in BO, if given fixed length file ( Notepad) as source? ...

101. How Do U Create Report in BO, if given fixed length file ( Notepad) as source? ...2323

102. How to execute the plsql procedure from the report by clicking with mouse ...

102. How to execute the plsql procedure from the report by clicking with mouse ...2323

103.

103. What is a What is a derived table in datderived table in data warehousing ...a warehousing ... . 2323

104. What is report template in B.O? ...

104. What is report template in B.O? ...2424

105. Objects

105. Objects infer SQL structures displayed infer SQL structures displayed in a in a schema schema ... ... 2626

106. What is BO Main Key? ...

106. What is BO Main Key? ...2626

107. What is metrics? – ...

107. What is metrics? – ...2626

108. Why do we need metrics and sets? ...

108. Why do we need metrics and sets? ... .. 2626

109. What is a Set? ...

109. What is a Set? ...2626

110. What is the use of AFD? Where it can be stored? ...

110. What is the use of AFD? Where it can be stored? ...2626

111. What is the source for metrics? ...

111. What is the source for metrics? ...2727

112. Is there any bug in 6.x? ...

112. Is there any bug in 6.x? ...2727

113. Analysis in BO? ...

113. Analysis in BO? ...2727

114. Are Data mart and

114. Are Data mart and DWH normalized or demoralized ? Do bDWH normalized or demoralized ? Do both of them exist in oth of them exist in ...2727

The same tier ?

The same tier ? ...2727..

115. What is

115. What is a Data Cube a Data Cube ? What is its ? What is its use ? use ? ... ... 2727

116. Are Data mart and DWH normalized or demoralized ?...

116. Are Data mart and DWH normalized or demoralized ?...2727

117. Can we apply

117. Can we apply Rank and Sort at a time oRank and Sort at a time on a single report? n a single report? ...2727

118. What is Thumbnail? ...

118. What is Thumbnail? ...2727

119. What is the dense rank? ...

119. What is the dense rank? ...2828

120. How Do U Create Report in BO, if given fixed length file (Notepad) as source? ...

120. How Do U Create Report in BO, if given fixed length file (Notepad) as source? ...2929

121. How to select different data providers in business objects? ...

121. How to select different data providers in business objects? ...2929

124. What is report template in B.O? ...

125. what is the difference between slice and dice & drill through ...

125. what is the difference between slice and dice & drill through ...3030

126. What is the difference between slice and dice and cross tab report? ...

(5)

127. Can you add the Cascading prompts in Business Objects?

127. Can you add the Cascading prompts in Business Objects? ...3030

128. What is a derived table in data warehousing ...

128. What is a derived table in data warehousing ... ... 3131

129. What is

129. What is the difference between the difference between tabular report& cross tab tabular report& cross tab report ? report ? ...3131

130. Can we apply

130. Can we apply Rank and Sort at a time oRank and Sort at a time on a single report n a single report ...3131

131. Which versions are used in the BO dashboard work?

131. Which versions are used in the BO dashboard work? ...3131..

132. I have some

132. I have some queries that I have one project queries that I have one project in bussiness objects, like computer peripheral(nrps)in bussiness objects, like computer peripheral(nrps)

for sales, in that I have face

for sales, in that I have face question like what is the main objectives question like what is the main objectives of ur projects of ur projects ...3232

133. How to select different data

133. How to select different data providers in business objects? providers in business objects? ...3232

134. What is

134. What is a derived table a derived table in data warehousing? in data warehousing? ...3232..

135. What is Business objects Repository? –

135. What is Business objects Repository? – ...3232

136. What is domain? How many are there in a basic setup? What are they? ...

136. What is domain? How many are there in a basic setup? What are they? ...3232

137. Can we have multiple domains? ... .... 3232

138. How do you

138. How do you restrict access to rows of a database? restrict access to rows of a database? ...3333

139. What is a category?

139. What is a category? ...3333

140. How can we improve performance? ...

140. How can we improve performance? ... .... 3333

141. clearly explain the difference between union and group

141. clearly explain the difference between union and group ...3333

142. Are Data mart and

142. Are Data mart and DWH normalized or demoralized ? Do bDWH normalized or demoralized ? Do both of them exist in the same tier ?oth of them exist in the same tier ?

...

...3333

143. What is

143. What is a Data Cube a Data Cube ? What is its ? What is its use ? use ? ... ... 3434

144. Can we apply

144. Can we apply Rank and Sort at a time oRank and Sort at a time on a single report n a single report ...3434

145. What is

146. How to break a Date field into Year, month, week, and day? ...

146. How to break a Date field into Year, month, week, and day? ...3434

(For example: I have a field INVOICE_DATE. Now

(For example: I have a field INVOICE_DATE. Now I want to break it as Year, I want to break it as Year, month... I.e. inmonth... I.e. in

time dimension.) DO I need to have some changes in Universe? ...

time dimension.) DO I need to have some changes in Universe? ... ... 3434

147. What is domain? How many are there in a basic setup? What are they? ...

147. What is domain? How many are there in a basic setup? What are they? ...3535

149. Can we have multiple domains? ... .... 3535

150. How do you restrict access to rows of a database? ...

150. How do you restrict access to rows of a database? ...3535

151. What is

152. Can we apply

152. Can we apply Rank and Sort at a time oRank and Sort at a time on a single report? n a single report? ...3535

153. What is meant by Object Stores?

153. What is meant by Object Stores? ...3535

154. What we can do in WebI and cannot do it in FULL CLIENT and vice versa for BO6.5 ...

154. What we can do in WebI and cannot do it in FULL CLIENT and vice versa for BO6.5 ...3636

155. Can a universe be connected to different databases...

155. Can a universe be connected to different databases...3636

156. How Do U Create Report in BO, if given fixed length file (Notepad) as source? ...

156. How Do U Create Report in BO, if given fixed length file (Notepad) as source? ...3636

157. How to select different data providers in business objects? ...

157. How to select different data providers in business objects? ...3636

160. what is the difference between slice and dice & drill through ...

160. what is the difference between slice and dice & drill through ...3737

161. what is a derived table in data warehousing ...

161. what is a derived table in data warehousing ...3737

162. What is the difference between

162. What is the difference between master-detail and Breaks? ...master-detail and Breaks? ... ... 3737

163. What is the difference between break and section I...

163. What is the difference between break and section I...3737

164. What is the difference between break and section I...

164. What is the difference between break and section I...3838

165. What are the requirements for cube creation in bus...

165. What are the requirements for cube creation in bus... .... 3838

166. Business objects

166. Business objects is which type of is which type of the OLAP Tool? the OLAP Tool? ...3838

167. How does the hierarchy and scope of analysis help...

(6)

168. How do you Find the average of an object with out using the Average Function and by using

only sum,average,max,min? ... ... ...38

169. What is difference between datamart and datawarehou... 39

170. How many tabs can be added in a report i.e. how ma... ... 39

171. What is the maximum limit of the data providers in... ... 39

172. How do you check whether the data in the rep...39

173. Clearly explain the difference between union and group ... ... 39

174. State the difference between WebI and Infoview ... ...40

175. What is the difference between detect alias and de... ... 40

176. What is all difference between business objects 6...40

177. Kindly number what are the steps to be taken to schedule the report? ...41

178. What is aggregate awareness and how can we use it? ... ...41

179. RE: What is aggregate awareness and how can we use it? ... ...41

180. What if a Cartesian product pop up block appears w...? ... ...41

183. What is a derived table in data warehousing? ... ...42

184. How to execute the plsql procedure from the report...42

185. How Do U Create Report in BO, if given fixed length... 42

186. Can someone please give some information on REPORT...? ...43

187. Can someone please let me know the things we can d... 43

188. How to break a Date field into Year, month, week, date ...45

189. What is the difference between slice and dice and cross tab report? ...45

190. What is the difference between slice and dice and... ... 45

191. My query takes 30 min to refresh ...there is any p...46

192. What is the difference between tabular report& crosstab...? ... ...46

193. What is the multi value error? Is there any...46

194. What is difference between custom hierarchy and re...? ... ... 46

195. I have three predefined prompts. In a report it will come randomly. How they will come in a specified format? ... ...46

196. Give the notes and functionalities of cascading pr... 46

197. Give the notes and functionalities of cascading pr... 47

198. What is the concept of Micro Cube in Business Objects and explain business reason for the usage. ...47

199. What is the concept of micro cube in business objects and explain business reason for the usage. ...48

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.

(7)

2. When we use aggregate awareness function in designer?

In order to solve fan trap in business objects we either create alias table or aggregate

awareness function Through aggregate navigation we can also select the compatible as well as incompatible objects

Ex:-year, quarter, month, week, and day

Year:-quarter, month, week, and day are compatible objects

Quarter:-year Â class is incompatible and month, week, day is compatible. We specify the objects in descending order

3. What is Business objects Repository? It is nothing but metadata.

4. Is there any other repository domain rather than...

There are only three main Domains Security, Universe and document. You can have multiple Universe and Documents domains in a repository but only one Security domain. 5. What is a Bo repository

• Its A Semantic Layer Which Stores The Bo Users N Their Privileges • 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.

• Repository is data accounts which contain three domains in each one type.

You can create the repository any where .the security domain has the user security info and other domains address. You can have more than one repository but you can use which one u specifying on the time of login. The address info of the security

domains is stored in the .key file if WebI it’s in the Bomain.keyfor more refer the cindi howson book and visit her web www. Askcindi.com

• BO repository is a set of db tables which holds the metadata information. This

Bo repository is divided in to 3 domains Security, universe, and document domain. This metadata holds all the information related to users groups their

privileges...except the "supervisor" this is the super user of Bo rep.the supervisor info is stored BOMain.key which is stored in default theme dir of Bo.

• BO Repository is a set of related data structures of BO stored in a database.

It contains tables of Security, Documents and Universe Domains

• Generally Repository is the Metadata

BO 5.0 Repository create/maintain 50 tables, they are distributed as follows 25 tables for Security domain

24 Table for Universe domain 1 Table for Document Domain

(8)

25 tables in sec.domin 1 table in doc domain 31 tables in uni domain It is a metadata

• Can some one provide the BO XI rel 2 repository Domains (Number of tables

for each domain)...

A context is simply a list of joins denoting a path between tables.

Contexts are set to identify alternative routes in the universe structure. BusinessObjects detects a context for each alternative route.

Contexts identify tables which are incompatible within the same SELECT statement -because the wrong results will be produced.

6. 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.

7. 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.

8. Can we have multiple domains?

Yes. (Security domain can not be multiple).

9. How do you restrict access to rows of a database? In XI version it can be do

10. In a report can we hide a particular object?

Yes we can show/hide a particular object in a table by using the pivot tab of the format table dialog box

11. Difference between compatible and incompatible objects?

- When an object is at the same or higher level of aggregation as the table, it is

(9)

- When an object is at a lower level of aggregation than the table (or if it is not at all

related to the table), it is incompatible with the table.

- We can select or choose compatible n incompatible objects through aggregator

navigation in the designer. With this method the performance increases tremendously. Instead of checking for each n every object only the compatible objects are only looked for aggregate awareness. Year:-month, quarter, week, day are compatible but customer class is incompatible

12. Can you please clarify the difference between compatible and incompatible objects? When we will use these two?

When you are defining Aggregate tables in Universe design, you need to create hierarchies for aggregated objects, for that you need to make the relative objects incompatible (the objects which are of lower level of aggregation -- not of hierarchy you have Year, Quarter, Month, Day as a hierarchy, while aggregation, you need to define as follows Year - Quarter, Month, Day Compatibles

Quarter - Month, Day Compatibles, Year Non-compatible Month - Day Compatible, Year, Quarter Non-compatible 13. Detail

Provide a description of a dimension, but are not the focus For analysis. For example Phone Number

Detail objects are attached to dimensions; one cannot drill on details nor link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.

14. Measure

Convey numeric information which is used to quantify a Dimension object. For example Sales Revenue

15. What is an object?

- It is an instance of class, its nothing but an entity.

- In Business Objects products an object is a named component in a universe that - Represents a column or function in a database.

- Object qualification represents what kind of object is that, usually we have three types

of object qualifiers they are measure, dimension, detailed.

- An object is a named component that maps to data or a derivation of data in the Database.

The name of an object should be drawn from the business vocabulary of the targeted user group. For example, objects used in a universe used by a Product manager could be

Product, Life Cycle, or Release Date. A universe Used by a financial analyst could contain objects such as Profit Margin, and Return on Investment.

(10)

- Object qualification represents what kind of object is that, usually we have three types

of object qualifiers they are measure, dimension, detailed. 16. What is a loop? How can we overcome?

- Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.

17. How does a context resolve a loop?

A context resolves a loop by defining a set of joins that specify one specific path Through tables in a loop. It ensures that joins are not included from different paths Within the same SQL query.

18. While resolving loops, how to decide whether alias or context to be used? Describe 19. What is the use of alias and context? Which is the better for solving the loops? Why?

Why we use alias and why we use context? 20. What is a Loop?

A loop is a set of joins that defines a closed path through a set of tables in a Schema. Loops occur when joins form multiple paths between lookup tables.

21. What is a loop? How can we overcome?

Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.

22. How does an alias break a loop?

An alias breaks a loop by using the same table twice in the same query for a Different purpose.

The alias is identical to the base table with a different name. The data in the alias is exactly the same as the original table, but the different Name “tricks” SQL into accepting that you are using two

different tables.

23. Create an alias to break a loop caused by shared lookup tables

A sales database holds information about customers living in different countries. These customers can place orders for goods that can be delivered by a number Of couriers or shipping companies.

24. Determining when an alias is not appropriate to break a loop

Creating an alias to resolve the loop described above is not the optimal solution. In this case, the use of contexts is a better solution. The following example

Describes why aliases are not appropriate, and why contexts are a better solution In this case.

If you try to identify the lookup table used for more than one purpose, it is not clear If it is the PRODUCTS table, or the CUSTOMERS table.

(11)

25. What is a context?

Contexts are a collection of joins which provide a valid query path for Business Objects and Web Intelligence to generate SQL.

26. What is the difference between detect alias and detect context?

Answer 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.

27. What do prefer an Alias or a context? Why? 28. What is a Chasm Trap?

. A chasm trap is a common problem in relational database schemas in which a

Join path returns more data than expected. A chasm trap is a type of join path between three tables when two "many-to-one" joins converge on a single table, and there is no context in place that

separates the converging join paths

29. What is a Fan Trap?

A fan trap is a less common problem than chasm traps in a relational database

Schema. It has the same effect of returning more data than expected. A fan trap is a type of join path between three tables when a to-many” join links a table which is in turn linked by another “one-to-many” joins. The fanning out effect of “one-“one-to-many” joins can cause incorrect results to be

returned when a query includes objects based on both tables.

30. How Do You Resolve a Fan Trap?

There are two ways to solve a fan trap problem.

• Create an alias for the table containing the initial aggregation, then use Detect Contexts (Tools > Detect Contexts) to detect and pr opose a context for the Alias table and a context for the original table. This is the most effective way To solve the fan trap problem.

31. What is a fan trap 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 links each other is in turn linked another one-to-many table. 2) CHASM TRAPS 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.

(12)

Â

When there is a series of one to many join in the tables, a Fan trap is resulted.

This may cause incorrect results to be returned when a query includes objects based on both tables.

For example: Associate, A Project, Â Dept tables.

One associate may work for N Projects, and those N projects may be Executed by N Dept....The report executed withÂ the Associate table and the Dept table objects may produce that One Associate belongs to many departments.

To avoid this

Create an Alias table for Project A, which is A joined to the Associate as One to one mapping table.

Create an Alias table forÂ Dept, which is A joined to theÂ Project as One to one mapping table.

That means one associate, will be shown working for one project, and one project belongs to one dept.

Which will now result in one associate working for one Dept.? Â

There are many other methods to solve Fan trap!!

Creating Manual Context, Using @ Aggregate Awareness Etc - based on the Business scenario these can be used

36i have some queries that I have one project in business objects, like computer

peripheral(nrps) for sales, in that I have face question like what is the main objectives of ur projects

32. What is an alias?

Aliases are references to existing tables in a schema. An Alias is a table that is An exact duplicate of the original table (base table), with a different name. The Data in the table is exactly the same as the original table, but the different name "Tricks" the SQL of a query to accept that you are using two different tables.

33. 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 would b like

(13)

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.

34. What is a join? Explain different types of joins?

Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.

35. What’s universal join in BOs?

The level of join between two universes with a matching column 36. What is a join? Explain different types of joins?

Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.

37. What is a join? Explain different types of joins?

- Join is used to link to tables depending upon the data requested by the user, Usually

we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join. 38. How achieve the many to many relation ship in Busi...

A) If you have two tables with many to many relation ships, take the keys of those tables and form a 1-1 relationship table. Then you can connect both the existing tables to the newly formed table using the key. B) Create an intermediate table with 2 keys. i.e., the primary keys of both tables. Join each table to its primary key in the intermediate table.

C)

m to m relation ship m to 1 1 to m

This way you can join

39. What is the difference between condition & filter?

A) Condition allows us to limit the data displayed from the database and Filter allows us to hide the data which is already generated in the report.

B) Conditions: these retrievals the data based on the condition (universe level) Filter: it brings the data and filter; performance will be slow (report level)

C) Condition allows us to limit the data displayed from the database and Filter allows us to hide the data which is already generated in the report.

(14)

D) A Condition feature that forces a query to retrieve only the data that meets specified

criteria. Condition is placed on a report query to show the specific data. To define a condition Name, Description and Where clause are required

A Filter enables you to view only necessary data in a report .i.e. it allows you to restrict the no. of rows displayed in the report they affect only the data currently displayed in the block but not query results

Ex: Select values for a variable in the report to apply a simple filter

In a report can we hide a particular object?

Yes we can show/hide a particular object in a table by using the pivot tab of the format table dialog box

40. What are Alerter, Filters, Breaks and Conditions? –

Alters are nothing but they are used to draw attention to a block of data by highlighting.

Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.

41. How to filter repetitive values in the report to get distinct values?

A) In the Query panel we have tab "Options” Click there to get "eliminate duplicate enable this options.

Example: In any database we can use distinct command but My Report source is flat file. Therefore I can’t manipulate source system.

B) Using the eliminate duplicates option is one way.

In a slightly different scenario, duplicates could come up due to the design structure of the report.

E.g. In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one value is returned.

C) One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition (the black cube)

But sometimes in free-hand sql reports it is not possible. 42. 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

Local Filter is to single report to which it is create, but a global filter is to all the reports which consists of that column

(15)

43. Is there any command or function to filter repeating records/values in the report? Using the eliminate duplicates option is one way.

In a lightly different scenario, duplicates could come up due to the design structure of the report. E.g. in some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION

ERROR). To avoid such situation, one can define a variable which would e the max of the Original field required. That ways the same value is fetched and also only one value is returned

44. What is drill filter and its usage? How many types of filters are there?

I don’t think there is any number of types in drill through filter, drill through filter is used to fetch the particular data from the report or other report by click browse while in the drill through process.

45. What is drill filter and its usage? How many types...

Three types of drill is in BO.1.drill up, 2.drill down, 3.drill thro'. Drill up means second->minutes->hour->->day

Drill down means region->country->state->district Drill thro'--whatever u want that element

Drill filters acts as query conditions when you bring new data from database

We can not say there are different types of drill filters, because we apply filters through scope of analysis and set the apply drill filters option by

Tools >options>drill tab

There are different drill modes like drill up, drill down, drill through 46. What are the steps to do to use Alerts in BO?

Alerts are used to alert some part of the data if any change occurs. select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank then a window pops up n we ca n give some condition where in if it crosses that an alert is sent

47. Please explain about Alerts in Bo's, under what situation we need to use alerts

Hello friends, here alert means to highlighted data in a particular report. In every report we can apply alerts situation like, sales revenue per city wise. Here city field we can apply alert, condition like sales revenue >=50,000

48. What are Alerter, Filters, Breaks and Conditions?

Alters are nothing but they are used to draw attention to a block of data by highlighting.

Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.

(16)

49. Can you create Alerts in WEB Intelligence?

In Version6 we can't create alerts in WEBi but it is available in XIR2 50. Can you add the Cascading prompts in Business Objects?

Answer: - if you select one prompt value based on that prompt value gives other low (that low value is have relate that 1st prompt value) you can sele ct 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.

51. Give the notes and functionalities of cascading prompts, @ script in business objects Syntax

@Prompt ("message", ["type"], [lov], [MONO|MULTI], [FREE|CONSTRAINED])

where

message is the text of a message within single quotes.

Type can be one of the following: "A" for alphanumeric, "N" for number, or "D" for date.

Lov can be either a list of values enclosed in brackets (each value must be within single quotes and separated by commas) or the name of a class and object separated by a backslash and within single quotes.

MONO means that the prompt accepts only one value. MULTI means that the prompt can accept several values.

FREE refers to free input as opposed to CONSTRAINED, which means that the end user must choose a value suggested by the prompt.

Description

is used to create an interactive object. In the Query Panel, this type of object causes a message to appear. This message prompts the end user to enter a specific value.

Note

the last four arguments are optional; however, if you omit an argument you must still enter the commas as separators.

(17)

In Where Clause:

City. City IN @Prompt ("Choose City", "A", {"Chicago", "Boston", "New York"}, MULTI, FREE) In the Query Panel, the object prompts the end user to choose a city.

52. What is Nested prompt and how to create this prompt?

Nested prompts are called "Cascading Prompts" in Business Objects environment. Try searching for this keyword. To create cascading prompts, you need to edit the properties of an object & impose another prompt as a condition.

53. What is a Universe?

A) It is a semantic layer between Database and the designer used to create objects and classes. (It maps to data in Database).

54. How do you design a universe?

The design method consists of two major phases.

During the first phase, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins by which they are

linked. You may need to resolve loops which occur in the joins using aliases or contexts. You can conclude this phase by testing the integrity of the overall structure.

During the second phase, you can proceed to enhance the components of your universe. You can also prepare certain objects for multidimensional analysis. As with the first phase, you should test the integrity of your universe structure. You may also wish to perform tests on the universes you create from the Business Objects User module. Finally, you can distribute your universes to users by exporting them to the repository or via your file system.

For a universe based on a simple relational schema, Designer provides Quick Design, a wizard for creating a basic yet complete universe. You can use the resulting universe immediately, or you can modify the objects and create complex new ones. In this way, you can gradually refine the quality and structure of your universe

55. What are Linked Universes?

If the data provided is from two different data providers then we can link those two universes, such type of universe is called Linked Universe.

56. In the BO universe, how to link two universe, like I have one universe in sales.uni and another is marketing.uni

In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linkin g.

57. Types of universes in business objects? Simple and Complex.

(18)

58. How can you check the universe? By making use of Check integrity button

59. What are the user requirements in a universe?

Database connections, key column, join and check for loop if you need measures, metrics, 60. How can you check the integrity?

By making use of Check integrity button. 61. What are Universe parameters?

Name of the universe, description and RDBMS connection, size and rights. 62. How can we improve performance?

By making use of Aggregate tables.

63. How many universes can be created in a project

We can create any number of universes, but at a time we can open only one universe, generally number of universes should be equal to number of sub-domains.

64. In the BO universe, how to link two universe, like I have one universe in sales. uni and another is marketing.uni

In BO Designer, from File Menu -> Parameters -> Links tab on Universe Parameters box. Click Add link to link the universe. The linking universe should be exported and imported from repository before linking.

65. What are the user requirements in a universe?

Database connections, key column, joins and check for loopif you need mesures, metrics, cheers,www.sithu.s5.com

66. What are Universe parameters? –

Name of the universe, description and RDBMS connection, size and rights. 67. what all will be exported to the repository, when we export a universe ?

When we export a universe first time, a unique identifier is allocated to the universe and this identifier is updated on the local version of the universe in the universe domain. If we export the universe to a diff, domain and now the universe has an identifier for diff-domain (EX: exporting a universe from a development diff-domain to a production diff-domain)

when a designer exports the universe to the Repository (universe domain) they must export all the related LOV files (which contains the data values associated with an object) to the document domain.

68. How many universes can be created in a project...?

Â In a project you can create multiple universes. For multiple universe usage linked universe is an ideal concept.

(19)

69. What is the size of data base?

In general it will be anything between 4-8 Terabytes.

70. Dimension Parameters for analysis. Dimensions typically relate to a

Hierarchy such as geography, product, or time. For example Last Name and CityId

71. What is a Fact Table

A fact table contains statistical information about transactions. For example, it May contain figures such as Sales Revenue or Profit.

72. What is an aggregate table?

These are tables that contain pre calculated data

73. What is a Lookup Table?

A lookup (or dimension) table contains information associated with a particular Entity or subject.

74. Classes

A class is a logical grouping of objects within a universe. It represents a category Of objects. The name of a class should indicate the category of the objects that it Contains. A class can be divided hierarchically into subclasses.

75. 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.

76. 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

77. 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.

(20)

78. 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.

79. 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.

80. 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.

81. 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...

82. 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.

83. What is the difference between slice and dice and cross tab report? Slice and Dice: Arrangement of Data

Crosstab report is for Comparison.

84. 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)

(21)

85. How to schedule the report in B.O?

We can schedule the reports through broadcast agent.

86. 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.

http://www.newinterviewquestions.com/cat/Business-Objects-interview-questions/ 87. How to schedule the report in B.O?

We can schedule the reports through broadcast agent.

88. 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.

89. 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.

90. What are the general issues in migration process? Alignment, performance.

91. 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.

(22)

In Refresh options Select Scheduled Refresh & click send

On Scheduling Options, Set "Refresh According to the profile of each recipient" to Yes & OK.

92. 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

93. 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.

94. 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.

95. 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.

96. How do we test the reports in the business objects... In the central management consol one can test the report.

(23)

97. 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.

98. 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

99. 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.

100. 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 !

(24)

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 :

1. Open the document, click "Send to BroadCast Agent" on Doc Exchange toolbar. 2. In Actions tab select "Refresh with the Profile of Each Recipient"

3. In the Distributions tab select "Distribute via the Business Objects Repository. (only option to enable you for Report Bursting)

4. click To, select recipients, 5. 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.

101. How Do U Create Report in BO, if given fixed length file ( Notepad) as source?

To create a report using notepad (.txt files) : 1.Open BusinessObjects --> new report

2. Select data provider as others instead of universe,

• from "Others" drop down list, select "Personal Data Files", • File selection box appears, specify the location of your text file,

• if you have separated data by tabs in text file select "Tabulation" if by comma then "Comma

Separated" (I don’t remember the exact caption for this option) & if space separated then select "Characters"(I don’t remember the exact caption for this option)

• if you have specified column names in your text file, check the box "First Row contains Column

names" Run the report.

102. 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's we can select tab "insert" n select the particular data source for generating the report through mouse click.

103. 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)

(25)

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.

104. 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

Definition of ERP (Enterprise Resource Planning)

Enterprise resource planning (ERP) is the industry term used to describe a broad set of activities supported by multi-module application software that helps a manufacturer or other business manage the important parts of its business. These parts can include product planning, parts purchasing, maintaining inventories, interacting with suppliers, providing customer service, and tracking orders. ERP can also include application modules for the finance and human resources aspects of a business.

Definition of Etl (extract, transform, load)

Short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.

Extract -- the process of reading data from a database.

Transform -- the process of converting the extracted data from its p revious form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.

(26)

http://www.computerworld.com/databasetopics/businessintelligence/datawarehouse/story/0,10801,89534,00. html

What is OLAP?

Short for Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining.

Functionalities

Before we speak about OLAP tool selection criterion, we must first distinguish between the two types of OLAP tools, MOLAP (Multidimensional OLAP) and ROLAP (Relational OLAP).

1. MOLAP: In this type of OLAP, a cube is aggregated from the relational data source (data warehouse).

When user generates a report request, the MOLAP tool can generate the create quickly because all data is already pre-aggregated within the cube.

2. ROLAP: In this type of OLAP, instead of pre-aggregating everything into a cube, the ROLAP engine

essentially acts as a smart SQL generator. The ROLAP tool typically comes with a 'Designer' piece, where the data warehouse administrator can specify the relationship between

The relational tables, as well as how dimensions, attributes, and hierarchies map to the underlying database tables.

Right now, there is a convergence between the traditional ROLAP and MOLAP vendors. ROLAP vendor recognize that users want their reports fast, so they a re implementing MOLAP functionalities in their tools; MOLAP vendors recognize that many times it is necessary to drill down to the most detail level information, levels where the traditional cubes do not get to for performance and size reasons.

(27)

 Ability to leverage parallelism supplied by RDBMS and hardware: This would greatly increase the

tool's performance, and help loading the data into the cubes as quickly as possible.

 Performance: In addition to leveraging parallelism, the tool itself should be quick both in terms of loading

the data into the cube and reading the data from the cube.

 Customization efforts: More and more, OLAP tools are used as an advanced reporting tool. This is

because in many cases, especially for ROLAP implementations, OLAP tools often canbe used as a reporting

tool. In such cases, the ease of front-end customization becomes an important factor in the tool selection process.

 Security Features: Because OLAP tools are geared towards a number of users, making sure people see

only what they are supposed to see is important. By and large, all established OLAP tools have a security layer that can interact with the common corporate login protocols. There are, however, cases where large corporations have developed their own user authentication mechanism and have a "single sign-on" policy. For these cases, having a seamless integration between the tool and the in-house authentication can require some work. I would recommend that you have the tool vendor team come in and make sure that the two are compatible.

 Metadata support: Because OLAP tools aggregates the data into the cube and sometimes serves as the

front-end tool, it is essential that it works with the metadata strategy/tool you have selected.

Popular Tools

• Business Objects • Cognos

• Hyperion

• Microsoft Analysis Services • MicroStrategy

105. Objects infer SQL structures displayed in a schema

The objects that Business Objects and Web Intelligence users see in a universe Infer SQL structures that you have inserted into a database schema. You, as the Universe designer, create this schema based on the tables and joins that are Required to return the data, needed by users for their analysis and report creation.

Object type Description 106. 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.

107. What is metrics? –

Metrics are a system of parameters or ways of quantitative and periodic assessment of a process that is to be measured; these are used to track trends, productivity.

108. Why do we need metrics and sets?

- Metrics are used for analysis and Sets are used for grouping. 109. What is a Set?

Its nothing but grouping of users.

110. What is the use of AFD? Where it can be stored?

(28)

111. What is the source for metrics? Measure objects.

112. Is there any bug in 6.x?

In earlier version of 6.0 they had, but 6.5 is the best version with out any bugs. 113. Analysis in BO?

Slice-Dice and Drill analysis.

114. 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. 115. 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.

Data cube is the representation of data along every possible dimension included in the query.

Data cubes are processing units composed of fact and dimensions. 116. Are Data mart and DWH normalized or demoralized ?...

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 Data mart and DWH is Demoralized and optimized for OLAP systems 117. 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.geekinterview.com/Interview-Questions/Business-Objects/page9

.

118. What is Thumbnail?

Business Objects 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.