Business Intelligence Interview Question and Answers

45. What are cardinalities?
  • Cardinality expresses the minimum and maximum number of instances of an entity B that can be associated with an instance of an entity A. The minimum and the maximum number of instances can be equal to 0, 1, or N.
  • Because a join represents a bi-directional relationship, it must always have two cardinalities.
  • There are two main methods for detecting or editing cardinalities:
  • The Detect Cardinalities command
  • The Edit Join dialog box
Your Name Your Email-ID
Your Answer
46. What are the types of Filters which affects the report?
  There are two types of filter.
  • A global filter affects the whole report.
  • A blockspecific filter only filters data for the specified chart, table or crosstab.
Your Name Your Email-ID
Your Answer
47. What is an Application Developer or Report developer?
  Design the Reports according to the report requirement templates. Testing the each report with following types of tests
  • Unit Testing
  • System Testing
  • Performance Testing
  • User Acceptance Test (UAT)
Your Name Your Email-ID
Your Answer
48. What is OLAP interface?
  • A good OLAP interface writes an efficient SQL and reads an aqua rate data from database.
  • To design the interface and architect having good knowledge on database under standing the report requirements.
Your Name Your Email-ID
Your Answer

131415 Page 12 of 15