1.diff b/w surrogate key and primary key?
2.If user wants the default data when he refrehes , assuming 6 contexts, how can you eliminate the "which context to choose" prompt?
3. diff drill thriugh and drill accross?
4.sub query and corelated query
5.implementaion of full outer join in universe
6.profiling and publishing
7.Traps
8. Minimum requirement to link the universes
----------------------------------------------------
BusObj Questions
Remember, there are many ways to do the same thing with all of the BusObj applications.
General Questions
Q) Tell me about yourself, your employment history. Q) How many years of experience do you have in BusObj? Versions? Q) What was your role in the current project? Q) How many users were there?
Q) On a scale of 1 - 10, rate yourself on BUSOBJ? Q) Supervisor
Q) Designer
Q) BusObj
Q) Webi
Q) Broadcast Agent
Q) Business Query
Q) Were any experts called from BUSOBJ while you were on the project? Q) What is BOmain.key?
A) A file that contains the address of the repository's security domain. This file must be distributed to all users who will access the BusinessObjects repository to share universes and documents. By default, the bomain.key is placed in the BusinessObjects\LocData folder on your system.
Supervisor Questions
Q) What is the Business Objects repository? A) The Business Objects repository is a set of relational data structures stored on a database. It enables Business Objects users to share resources in a controlled and secured environment. Q) What is a domain? How many are there is a basic set up? What are they? A) The repository is made up of three domains: the security domain, the universe domain, and the document domain. Q) When is the repository created?
A) The repository is created by the general supervisor with the Setup wizard during the first-time use of the product. You can create and use more than one repository, typically to manage multiple sites. Q) Can we have multiple domains? If yes. Purpose of having them? A) Yes, Having multiple document domains can help with organization. If you stick with the 'canned' document domain, all documents (BCA, user to user, corporate, universe lov's) all wind up sharing the same domain/default table space. You can create separate domains with separate table spaces for the different types of documents and reduce the risk of space related Repro problems and corruption. Also, you can reduce the risk that problems corrupt your entire Repro.
Q) How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc? Q) How do you restrict access to the rows of a database? A) 1) In the User pane, click the user or group.
2) In the Resource pane, click the Universe tab. 3) Right-click the universe.
4) From the pop-up menu, click Properties. 5) In the Universe Properties dialog box, click the Rows tab. 6) Set the options as necessary.
7) Click OK.
Q) How do you Create a user?
A) 1) In the User pane, click the group in which you want to create a new user.
2) Click on the toolbar.
3) Type a user name, and press the Enter key. Q) What are the types of user profiles and products can they use? A) Supervisor offers standard profiles representing the various types of Business Objects users. The names of the profiles, as well as their symbols, roles, and products are explained below.
Profile) General Supervisor
Role) The Business Objects system administrator. This is the person who launches Supervisor for the first time. The general supervisor creates the repository, defines users and groups, and manages resources. A general supervisor is the sole user with a global view of the hierarchical organization.
Product) All Business Objects Products
Profile) Supervisor
Role) Defines users and group, manages resources, and ensures security. A supervisor also assigns properties and resources to these users and groups. In addition, a supervisor can restrict access to certain resources. A general supervisor can create several supervisors. Product) Supervisor, BusinessObjects
Profile) Supervisor-designer
Role) Creates users, groups and universes. This user has all the rights of the supervisor and designer combined.
Product) Supervisor, Designer, BusinessObjects Profile) Designer
Role) Creates universes and distributes them to end-users by sending them through the file system, or by exporting them to the repository. Product) Designer, BusinessObjects
Profile) User
Role) The main BusinessObjects user whose tasks are to query, report, and analyze data. Users can produce documents containing data from one or more data sources. There can be an unlimited number of users. Product) BusinessObjects
Profile) Versatile
Role) This user is authorized to use any combination of products defined by a supervisor.
Q) How do you create a user group?
A) 1) In the User pane, click the group in which you want to create a new group.
2) Click on the toolbar.
3) Type a group name, and press the Enter key. Q) How do you know if a user is Disabled? A) A sad face means the user has disabled him/herself by failing the password check X number of times. A user disabled intentionally via the Supervisor module will have a red circle X over him/her. Q) How do you enable a User?
A) Right click on the disabled user and select enable. Q) How many strikes does it take before a user disables themselves?
A) 3 is the default but a General Supervisor can change this setting in tools/options.
Q) What is a Category?
A) A keyword or phrase created by Supervisor and stored in the repository, which end-users can assign to documents when they send them to users, groups, or Broadcast Agent. Users can then filter document searches in the repository by assigned category.
Designer Questions
Q) What is a Universe?
A) A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting. In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.
Q) How many Universes did you create?
Q) Tell me how many classes where there, and objects in each class? Q) What is an Object?
A) An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports.
Q) What is Object qualification?
A) For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure. Q) Tell me about a complicated object you have created? Q) What was the size of the database? Which server? Q) What was the Database? Was it a data warehouse? Q) What problems you have faced while creating a universe? Q) Tell me an incident and how you went about solving it? Q) How many Tables was the universe built? Q) What is a loop, how do you resolve them? A) A situation that occurs when more than one path exists from one table to another in the universe.
Q) What do prefer an Alias or a context? Why? A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.
Q) What is join? Explain different types of joins? A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
Q) What are linked universes? Have you worked with them, problems faced and solutions?
A) Linked universes are universes that share common components such as parameters, classes, objects, or joins. Among linked universes, one universe is said to be the kernel or master while the others are the derived universes.
BusObj Questions
Q) How many reports have you created? Explain a few? Q) What are alerter's, filters, breaks, conditions? A) The Alerters dialog box allows you to create and apply alerters. Alerters use special formatting to make data that fits specified conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data.
A) A filter enables you to hide the data you do not want to view and display only the data you want to focus on. In the Apply a Filter on Variable Name dialog box, you choose which values of the selected variable you want to display in the selected block.
A) Select the variables you want to use to insert a break. When you close the dialog box, the variable you select is displayed in the Breaks dialog box. Break Level, sets the level that the block of data will have in the report. You can have more than one break level to organize blocks of data. A) Conditions - feature that forces a query to retrieve only the data that meets specified criteria.
Q) What's the difference between master-detail and Breaks? Q) What's the difference between filters and conditions? Q) What are pre-defined conditions? Compare with report conditions? Justify? Q) What are the differences between a formula, variable and user objects? Q) Did you face any problems while creating reports? Name? Solutions? Q) How do you schedule the reports?
Q) What is a microcube? How many can a document have? A) Local structure in which the data retrieved by a data provider is stored; contains the data users can display in reports inside a document. Q) Have you worked with multiple data sources? If yes. How do you link them? Q) What are templates? Explain what you have created? Q) How do you resolve #multivalue and #computation errors? Q) Difference between Foreach and Forall? A) Foreach - Adds a dimension to the calculation environment.
A) Forall - Specifies the dimensions you want to include in the calculation.
Q) Define a Cell, Block, and Section?
Questions:
1. Multivalue and Syntax error
2. While resolving loops, how to decide whether alias or context to be used?
3. How many ways we test the universe & Report?
4. can we apply Rank and Sort at a time on a single report
5. What are the user requirements in a universe?
6. When to use local filter and when to use global Filter?
7. What is the difference between user and versatile user in superviser product?
8. my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?
9. Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
10. Business Object Security
11. How do I synchronise Microcubes generated by different queries?
12. How do you link different data providers in a single report?
13. What are the different types of Filters available in BUSINESS OBJECTS?
14. There are two ways to transfer data from a report to Excel Can you describe them?
15. What's the major difference between regular universe & metric universe?
16. How to create predefined filters in BO
17. What is the difference between condition and filter? What is thumbnail?
18. Different background in alternative rows
19. Explain about Synchronization Error in Business Objects
20. How many alters can we apply in single column of a report and max no of alters for a whole report.
21. How can we use the multiple data providers in a single report?
22. Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)
23. Query not returning any value?
24. Multiple data cubes for one report?
25. what is canned universe and canned reports in bo?
26. Explain scenario where you would use theta Join in Business objects ?
27. What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?
28. Snow flake schema is normalized or denormalized? Explain how?
29. Difference Between ForEach and ForALL ?
30. what is the difference between break and section in Reports.
31. How to suppress the reports in BO?
32. @aggregate aware function
33. When there are 2 prompt statements given one after the other which one is prompted first when RUN?
34. How would I achieve Traffic Lighting in Business Objects
35. What operator would you use to allow wild card characters in a query?
36. How would I hide fields in a report other than formatting the cells?
37. Queries can be combined, what are the three ways of combining queries?
38. Explain scenario to get multiple values in a cell (multi value error)
39. What is off-peak time?
40. What is the concept of Micro Cube in Business Objects and explain business reason for the usage.
42. How would I export a report to Word?
43. How do you export reports to repository
44. BO Data Providers
45. What is file watcher? What is the use of it?
46. What is Broad casting Agent?
47. What is meant by Report Bursting ?
48. What is Candidate Object?How to resolve #overflow error?
49. can you please clarify the difference between compatible and incompatible objects?
50. I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Supervisor Questions
Q) What is the Business Objects repository? A) The Business Objects repository is a set of relational data structures stored on a database. It enables Business Objects users to share resources in a controlled and secured environment. Q) What is a domain? How many are there is a basic set up? What are they? A) The repository is made up of three domains: the security domain, the universe domain, and the document domain. Q) When is the repository created?
A) The repository is created by the general supervisor with the Setup wizard during the first-time use of the product. You can create and use more than one repository, typically to manage multiple sites. Q) Can we have multiple domains? If yes. Purpose of having them? A) Yes, Having multiple document domains can help with organization. If you stick with the 'canned' document domain, all documents (BCA, user to user, corporate, universe lov's) all wind up sharing the same domain/default table space. You can create separate domains with separate table spaces for the different types of documents and reduce the risk of space related Repro problems and corruption. Also, you can reduce the risk that problems corrupt your entire Repro.
Q) How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc? Q) How do you restrict access to the rows of a database? A) 1) In the User pane, click the user or group.
2) In the Resource pane, click the Universe tab. 3) Right-click the universe.
4) From the pop-up menu, click Properties. 5) In the Universe Properties dialog box, click the Rows tab. 6) Set the options as necessary.
7) Click OK.
Q) How do you Create a user?
A) 1) In the User pane, click the group in which you want to create a new user.
2) Click on the toolbar.
3) Type a user name, and press the Enter key. Q) What are the types of user profiles and products can they use? A) Supervisor offers standard profiles representing the various types of Business Objects users. The names of the profiles, as well as their symbols, roles, and products are explained below.
Profile) General Supervisor
Role) The Business Objects system administrator. This is the person who launches Supervisor for the first time. The general supervisor creates the repository, defines users and groups, and manages resources. A general supervisor is the sole user with a global view of the hierarchical organization.
Product) All Business Objects Products
Profile) Supervisor
Role) Defines users and group, manages resources, and ensures security. A supervisor also assigns properties and resources to these users and groups. In addition, a supervisor can restrict access to certain resources. A general supervisor can create several supervisors. Product) Supervisor, BusinessObjects
Profile) Supervisor-designer
Role) Creates users, groups and universes. This user has all the rights of the supervisor and designer combined.
Product) Supervisor, Designer, BusinessObjects Profile) Designer
Role) Creates universes and distributes them to end-users by sending them through the file system, or by exporting them to the repository. Product) Designer, BusinessObjects
Profile) User
Role) The main BusinessObjects user whose tasks are to query, report, and analyze data. Users can produce documents containing data from one or more data sources. There can be an unlimited number of users. Product) BusinessObjects
Profile) Versatile
Role) This user is authorized to use any combination of products defined by a supervisor.
Q) How do you create a user group?
A) 1) In the User pane, click the group in which you want to create a new group.
2) Click on the toolbar.
3) Type a group name, and press the Enter key. Q) How do you know if a user is Disabled? A) A sad face means the user has disabled him/herself by failing the password check X number of times. A user disabled intentionally via the Supervisor module will have a red circle X over him/her. Q) How do you enable a User?
A) Right click on the disabled user and select enable. Q) How many strikes does it take before a user disables themselves?
A) 3 is the default but a General Supervisor can change this setting in tools/options.
Q) What is a Category?
A) A keyword or phrase created by Supervisor and stored in the repository, which end-users can assign to documents when they send them to users, groups, or Broadcast Agent. Users can then filter document searches in the repository by assigned category.
Designer Questions
Q) What is a Universe?
A) A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting. In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.
Q) How many Universes did you create?
Q) Tell me how many classes where there, and objects in each class? Q) What is an Object?
A) An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports.
Q) What is Object qualification?
A) For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure. Q) Tell me about a complicated object you have created? Q) What was the size of the database? Which server? Q) What was the Database? Was it a data warehouse? Q) What problems you have faced while creating a universe? Q) Tell me an incident and how you went about solving it? Q) How many Tables was the universe built? Q) What is a loop, how do you resolve them? A) A situation that occurs when more than one path exists from one table to another in the universe.
Q) What do prefer an Alias or a context? Why? A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.
Q) What is join? Explain different types of joins? A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
Q) What are linked universes? Have you worked with them, problems faced and solutions?
A) Linked universes are universes that share common components such as parameters, classes, objects, or joins. Among linked universes, one universe is said to be the kernel or master while the others are the derived universes.
BusObj Questions
Q) How many reports have you created? Explain a few? Q) What are alerter's, filters, breaks, conditions? A) The Alerters dialog box allows you to create and apply alerters. Alerters use special formatting to make data that fits specified conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data.
A) A filter enables you to hide the data you do not want to view and display only the data you want to focus on. In the Apply a Filter on Variable Name dialog box, you choose which values of the selected variable you want to display in the selected block.
A) Select the variables you want to use to insert a break. When you close the dialog box, the variable you select is displayed in the Breaks dialog box. Break Level, sets the level that the block of data will have in the report. You can have more than one break level to organize blocks of data. A) Conditions - feature that forces a query to retrieve only the data that meets specified criteria.
Q) What's the difference between master-detail and Breaks? Q) What's the difference between filters and conditions? Q) What are pre-defined conditions? Compare with report conditions? Justify? Q) What are the differences between a formula, variable and user objects? Q) Did you face any problems while creating reports? Name? Solutions? Q) How do you schedule the reports?
Q) What is a microcube? How many can a document have? A) Local structure in which the data retrieved by a data provider is stored; contains the data users can display in reports inside a document. Q) Have you worked with multiple data sources? If yes. How do you link them? Q) What are templates? Explain what you have created? Q) How do you resolve #multivalue and #computation errors? Q) Difference between Foreach and Forall? A) Foreach - Adds a dimension to the calculation environment.
A) Forall - Specifies the dimensions you want to include in the calculation.
Q) Define a Cell, Block, and Section?
2.If user wants the default data when he refrehes , assuming 6 contexts, how can you eliminate the "which context to choose" prompt?
3. diff drill thriugh and drill accross?
4.sub query and corelated query
5.implementaion of full outer join in universe
6.profiling and publishing
7.Traps
8. Minimum requirement to link the universes
----------------------------------------------------
BusObj Questions
Remember, there are many ways to do the same thing with all of the BusObj applications.
General Questions
Q) Tell me about yourself, your employment history. Q) How many years of experience do you have in BusObj? Versions? Q) What was your role in the current project? Q) How many users were there?
Q) On a scale of 1 - 10, rate yourself on BUSOBJ? Q) Supervisor
Q) Designer
Q) BusObj
Q) Webi
Q) Broadcast Agent
Q) Business Query
Q) Were any experts called from BUSOBJ while you were on the project? Q) What is BOmain.key?
A) A file that contains the address of the repository's security domain. This file must be distributed to all users who will access the BusinessObjects repository to share universes and documents. By default, the bomain.key is placed in the BusinessObjects\LocData folder on your system.
Supervisor Questions
Q) What is the Business Objects repository? A) The Business Objects repository is a set of relational data structures stored on a database. It enables Business Objects users to share resources in a controlled and secured environment. Q) What is a domain? How many are there is a basic set up? What are they? A) The repository is made up of three domains: the security domain, the universe domain, and the document domain. Q) When is the repository created?
A) The repository is created by the general supervisor with the Setup wizard during the first-time use of the product. You can create and use more than one repository, typically to manage multiple sites. Q) Can we have multiple domains? If yes. Purpose of having them? A) Yes, Having multiple document domains can help with organization. If you stick with the 'canned' document domain, all documents (BCA, user to user, corporate, universe lov's) all wind up sharing the same domain/default table space. You can create separate domains with separate table spaces for the different types of documents and reduce the risk of space related Repro problems and corruption. Also, you can reduce the risk that problems corrupt your entire Repro.
Q) How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc? Q) How do you restrict access to the rows of a database? A) 1) In the User pane, click the user or group.
2) In the Resource pane, click the Universe tab. 3) Right-click the universe.
4) From the pop-up menu, click Properties. 5) In the Universe Properties dialog box, click the Rows tab. 6) Set the options as necessary.
7) Click OK.
Q) How do you Create a user?
A) 1) In the User pane, click the group in which you want to create a new user.
2) Click on the toolbar.
3) Type a user name, and press the Enter key. Q) What are the types of user profiles and products can they use? A) Supervisor offers standard profiles representing the various types of Business Objects users. The names of the profiles, as well as their symbols, roles, and products are explained below.
Profile) General Supervisor
Role) The Business Objects system administrator. This is the person who launches Supervisor for the first time. The general supervisor creates the repository, defines users and groups, and manages resources. A general supervisor is the sole user with a global view of the hierarchical organization.
Product) All Business Objects Products
Profile) Supervisor
Role) Defines users and group, manages resources, and ensures security. A supervisor also assigns properties and resources to these users and groups. In addition, a supervisor can restrict access to certain resources. A general supervisor can create several supervisors. Product) Supervisor, BusinessObjects
Profile) Supervisor-designer
Role) Creates users, groups and universes. This user has all the rights of the supervisor and designer combined.
Product) Supervisor, Designer, BusinessObjects Profile) Designer
Role) Creates universes and distributes them to end-users by sending them through the file system, or by exporting them to the repository. Product) Designer, BusinessObjects
Profile) User
Role) The main BusinessObjects user whose tasks are to query, report, and analyze data. Users can produce documents containing data from one or more data sources. There can be an unlimited number of users. Product) BusinessObjects
Profile) Versatile
Role) This user is authorized to use any combination of products defined by a supervisor.
Q) How do you create a user group?
A) 1) In the User pane, click the group in which you want to create a new group.
2) Click on the toolbar.
3) Type a group name, and press the Enter key. Q) How do you know if a user is Disabled? A) A sad face means the user has disabled him/herself by failing the password check X number of times. A user disabled intentionally via the Supervisor module will have a red circle X over him/her. Q) How do you enable a User?
A) Right click on the disabled user and select enable. Q) How many strikes does it take before a user disables themselves?
A) 3 is the default but a General Supervisor can change this setting in tools/options.
Q) What is a Category?
A) A keyword or phrase created by Supervisor and stored in the repository, which end-users can assign to documents when they send them to users, groups, or Broadcast Agent. Users can then filter document searches in the repository by assigned category.
Designer Questions
Q) What is a Universe?
A) A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting. In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.
Q) How many Universes did you create?
Q) Tell me how many classes where there, and objects in each class? Q) What is an Object?
A) An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports.
Q) What is Object qualification?
A) For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure. Q) Tell me about a complicated object you have created? Q) What was the size of the database? Which server? Q) What was the Database? Was it a data warehouse? Q) What problems you have faced while creating a universe? Q) Tell me an incident and how you went about solving it? Q) How many Tables was the universe built? Q) What is a loop, how do you resolve them? A) A situation that occurs when more than one path exists from one table to another in the universe.
Q) What do prefer an Alias or a context? Why? A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.
Q) What is join? Explain different types of joins? A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
Q) What are linked universes? Have you worked with them, problems faced and solutions?
A) Linked universes are universes that share common components such as parameters, classes, objects, or joins. Among linked universes, one universe is said to be the kernel or master while the others are the derived universes.
BusObj Questions
Q) How many reports have you created? Explain a few? Q) What are alerter's, filters, breaks, conditions? A) The Alerters dialog box allows you to create and apply alerters. Alerters use special formatting to make data that fits specified conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data.
A) A filter enables you to hide the data you do not want to view and display only the data you want to focus on. In the Apply a Filter on Variable Name dialog box, you choose which values of the selected variable you want to display in the selected block.
A) Select the variables you want to use to insert a break. When you close the dialog box, the variable you select is displayed in the Breaks dialog box. Break Level, sets the level that the block of data will have in the report. You can have more than one break level to organize blocks of data. A) Conditions - feature that forces a query to retrieve only the data that meets specified criteria.
Q) What's the difference between master-detail and Breaks? Q) What's the difference between filters and conditions? Q) What are pre-defined conditions? Compare with report conditions? Justify? Q) What are the differences between a formula, variable and user objects? Q) Did you face any problems while creating reports? Name? Solutions? Q) How do you schedule the reports?
Q) What is a microcube? How many can a document have? A) Local structure in which the data retrieved by a data provider is stored; contains the data users can display in reports inside a document. Q) Have you worked with multiple data sources? If yes. How do you link them? Q) What are templates? Explain what you have created? Q) How do you resolve #multivalue and #computation errors? Q) Difference between Foreach and Forall? A) Foreach - Adds a dimension to the calculation environment.
A) Forall - Specifies the dimensions you want to include in the calculation.
Q) Define a Cell, Block, and Section?
Questions:
1. Multivalue and Syntax error
2. While resolving loops, how to decide whether alias or context to be used?
3. How many ways we test the universe & Report?
4. can we apply Rank and Sort at a time on a single report
5. What are the user requirements in a universe?
6. When to use local filter and when to use global Filter?
7. What is the difference between user and versatile user in superviser product?
8. my query takes 30 min to refresh ...there is any performance tunning is there to reduce refresh time?
9. Is there any significance of testing the BO report by getting the Dataprovider SQL and running it against the DB to check whether the report and the DB gives the same data?
10. Business Object Security
11. How do I synchronise Microcubes generated by different queries?
12. How do you link different data providers in a single report?
13. What are the different types of Filters available in BUSINESS OBJECTS?
14. There are two ways to transfer data from a report to Excel Can you describe them?
15. What's the major difference between regular universe & metric universe?
16. How to create predefined filters in BO
17. What is the difference between condition and filter? What is thumbnail?
18. Different background in alternative rows
19. Explain about Synchronization Error in Business Objects
20. How many alters can we apply in single column of a report and max no of alters for a whole report.
21. How can we use the multiple data providers in a single report?
22. Can you add the Cascading promprts in Business Objects? (Based on Country prompt selection you need to provide the option to select Sate/Province in the next State prompt. That means dynamically refresh the data load in the state list values)
23. Query not returning any value?
24. Multiple data cubes for one report?
25. what is canned universe and canned reports in bo?
26. Explain scenario where you would use theta Join in Business objects ?
27. What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?
28. Snow flake schema is normalized or denormalized? Explain how?
29. Difference Between ForEach and ForALL ?
30. what is the difference between break and section in Reports.
31. How to suppress the reports in BO?
32. @aggregate aware function
33. When there are 2 prompt statements given one after the other which one is prompted first when RUN?
34. How would I achieve Traffic Lighting in Business Objects
35. What operator would you use to allow wild card characters in a query?
36. How would I hide fields in a report other than formatting the cells?
37. Queries can be combined, what are the three ways of combining queries?
38. Explain scenario to get multiple values in a cell (multi value error)
39. What is off-peak time?
40. What is the concept of Micro Cube in Business Objects and explain business reason for the usage.
42. How would I export a report to Word?
43. How do you export reports to repository
44. BO Data Providers
45. What is file watcher? What is the use of it?
46. What is Broad casting Agent?
47. What is meant by Report Bursting ?
48. What is Candidate Object?How to resolve #overflow error?
49. can you please clarify the difference between compatible and incompatible objects?
50. I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Supervisor Questions
Q) What is the Business Objects repository? A) The Business Objects repository is a set of relational data structures stored on a database. It enables Business Objects users to share resources in a controlled and secured environment. Q) What is a domain? How many are there is a basic set up? What are they? A) The repository is made up of three domains: the security domain, the universe domain, and the document domain. Q) When is the repository created?
A) The repository is created by the general supervisor with the Setup wizard during the first-time use of the product. You can create and use more than one repository, typically to manage multiple sites. Q) Can we have multiple domains? If yes. Purpose of having them? A) Yes, Having multiple document domains can help with organization. If you stick with the 'canned' document domain, all documents (BCA, user to user, corporate, universe lov's) all wind up sharing the same domain/default table space. You can create separate domains with separate table spaces for the different types of documents and reduce the risk of space related Repro problems and corruption. Also, you can reduce the risk that problems corrupt your entire Repro.
Q) How do you restrict the users from using a particular universe, a class or object(s) of a universe, a particular document etc? Q) How do you restrict access to the rows of a database? A) 1) In the User pane, click the user or group.
2) In the Resource pane, click the Universe tab. 3) Right-click the universe.
4) From the pop-up menu, click Properties. 5) In the Universe Properties dialog box, click the Rows tab. 6) Set the options as necessary.
7) Click OK.
Q) How do you Create a user?
A) 1) In the User pane, click the group in which you want to create a new user.
2) Click on the toolbar.
3) Type a user name, and press the Enter key. Q) What are the types of user profiles and products can they use? A) Supervisor offers standard profiles representing the various types of Business Objects users. The names of the profiles, as well as their symbols, roles, and products are explained below.
Profile) General Supervisor
Role) The Business Objects system administrator. This is the person who launches Supervisor for the first time. The general supervisor creates the repository, defines users and groups, and manages resources. A general supervisor is the sole user with a global view of the hierarchical organization.
Product) All Business Objects Products
Profile) Supervisor
Role) Defines users and group, manages resources, and ensures security. A supervisor also assigns properties and resources to these users and groups. In addition, a supervisor can restrict access to certain resources. A general supervisor can create several supervisors. Product) Supervisor, BusinessObjects
Profile) Supervisor-designer
Role) Creates users, groups and universes. This user has all the rights of the supervisor and designer combined.
Product) Supervisor, Designer, BusinessObjects Profile) Designer
Role) Creates universes and distributes them to end-users by sending them through the file system, or by exporting them to the repository. Product) Designer, BusinessObjects
Profile) User
Role) The main BusinessObjects user whose tasks are to query, report, and analyze data. Users can produce documents containing data from one or more data sources. There can be an unlimited number of users. Product) BusinessObjects
Profile) Versatile
Role) This user is authorized to use any combination of products defined by a supervisor.
Q) How do you create a user group?
A) 1) In the User pane, click the group in which you want to create a new group.
2) Click on the toolbar.
3) Type a group name, and press the Enter key. Q) How do you know if a user is Disabled? A) A sad face means the user has disabled him/herself by failing the password check X number of times. A user disabled intentionally via the Supervisor module will have a red circle X over him/her. Q) How do you enable a User?
A) Right click on the disabled user and select enable. Q) How many strikes does it take before a user disables themselves?
A) 3 is the default but a General Supervisor can change this setting in tools/options.
Q) What is a Category?
A) A keyword or phrase created by Supervisor and stored in the repository, which end-users can assign to documents when they send them to users, groups, or Broadcast Agent. Users can then filter document searches in the repository by assigned category.
Designer Questions
Q) What is a Universe?
A) A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting. In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.
Q) How many Universes did you create?
Q) Tell me how many classes where there, and objects in each class? Q) What is an Object?
A) An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports.
Q) What is Object qualification?
A) For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure. Q) Tell me about a complicated object you have created? Q) What was the size of the database? Which server? Q) What was the Database? Was it a data warehouse? Q) What problems you have faced while creating a universe? Q) Tell me an incident and how you went about solving it? Q) How many Tables was the universe built? Q) What is a loop, how do you resolve them? A) A situation that occurs when more than one path exists from one table to another in the universe.
Q) What do prefer an Alias or a context? Why? A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.
Q) What is join? Explain different types of joins? A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.
Q) What are linked universes? Have you worked with them, problems faced and solutions?
A) Linked universes are universes that share common components such as parameters, classes, objects, or joins. Among linked universes, one universe is said to be the kernel or master while the others are the derived universes.
BusObj Questions
Q) How many reports have you created? Explain a few? Q) What are alerter's, filters, breaks, conditions? A) The Alerters dialog box allows you to create and apply alerters. Alerters use special formatting to make data that fits specified conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data.
A) A filter enables you to hide the data you do not want to view and display only the data you want to focus on. In the Apply a Filter on Variable Name dialog box, you choose which values of the selected variable you want to display in the selected block.
A) Select the variables you want to use to insert a break. When you close the dialog box, the variable you select is displayed in the Breaks dialog box. Break Level, sets the level that the block of data will have in the report. You can have more than one break level to organize blocks of data. A) Conditions - feature that forces a query to retrieve only the data that meets specified criteria.
Q) What's the difference between master-detail and Breaks? Q) What's the difference between filters and conditions? Q) What are pre-defined conditions? Compare with report conditions? Justify? Q) What are the differences between a formula, variable and user objects? Q) Did you face any problems while creating reports? Name? Solutions? Q) How do you schedule the reports?
Q) What is a microcube? How many can a document have? A) Local structure in which the data retrieved by a data provider is stored; contains the data users can display in reports inside a document. Q) Have you worked with multiple data sources? If yes. How do you link them? Q) What are templates? Explain what you have created? Q) How do you resolve #multivalue and #computation errors? Q) Difference between Foreach and Forall? A) Foreach - Adds a dimension to the calculation environment.
A) Forall - Specifies the dimensions you want to include in the calculation.
Q) Define a Cell, Block, and Section?
No comments:
Post a Comment