BO Questionnaires
1. How many number of open middleware connections?
2. What is the Array Fetch Size of the Database?
3. Is Indexing used on data warehouse tables?
4. Are there any aggregate tables created in the database?
5. Is BO Repository has dedicated system or not?
6. Is there any row level and page level locking mechanism implemented in the BO Repository?
7. Which Database Server is used to host BO Repository?
8. How many numbers of domains are available in the BO Repository?
9. What is size of the BO Repository?
10. What is size of the Security, Universe and Document Domains?
11. Are you purging the old version of documents or not?
12. Are there any separate BO Repository servers exists?
13. Which is the network protocol used in the network?
14. Which master card and switched hub is used for process network packets?
15. Which version of Windows NT Server and Service Pack is used?
16. Are CORBA features enabled for Distributed Component Architecture?
17. What is the ratio factor of node load factor?
18. Which approach for Load Balancing is used?
19. Is all the distributed components are running on Single Server?
20. How many other resources are running simultaneously in NT Server & Web Server?
21. Are there any multiple cluster servers exist?
22. Is all the servers (multiple cluster servers) are running on the same time zone?
23. Which protocols/network cards are used to define network paths?
24. Is extranet feature used for Web Intelligence?
25. How many numbers of components are used in Broadcast Agent?
26. Which version of Broadcast Agent is used?
27. How many number of CPU’s used for BO processes?
28. What is the virtual memory (paging file) used in Windows NT Server?
29. What type of disk is used for server?
30. Which other software and drivers exists in Server?
31. What is the hardware configuration used for Windows NT, where BO Server, Repository, BCA Server and Web Intelligence Server are installed?
32. Is BO installed in NTFS partitions or not?
33. How many numbers of services are running in Windows NT at a given time?
34. How many peak time concurrent groups and users?
35. Is the machine designed and configured based on Total Supported Users and User Activity Ratio or not?
36. How many number of documents accessed in the BO Repository at a given time?
37. What is your organization’s geographical distribution?
38. How many security levels are used?
39. Is BLOB data types used in BO Repository database?
40. Is there any migration happened from older version to newer version?
41. What is the average connection of each user to BO repository?
42. Is restriction applied for sorting on non-indexed columns?
43. Are all the system components on the same subnet mask?
44. What is speed of the switched hub?
45. How many data sources will be feeding data to reporting database instance?
46. Is linked universe concept used?
47. Does the BO Reports run on OLTP or OLAP system?
48. How many standard reports? Any adhoc reporting?
49. How many BO Universes and what is the size of each universe?
50. How many approximate number of conditional, measured and derived objects used in each universe?
51. Is WebI used? Is BCA used?
52. Are BO SDK and WI SDK used for customization?
53. In which database the BO repository is located?
54. How many aliases and contexts in each Universe?
55. Is Aggregate awareness used in universe?
56. Is WebI server and Repository hosted on the same server?
57. What is hardware infrastructure for WebI, BO Repository?
58. Which Web Server is used for hosting WebI?
59. How many loaded processes are running on the server at a given time?
60. How many concurrent processes are running on the server at a given time?
61. Are there any unlinked tables in the universes?
62. Is outer join concept used in universe?
63. What is the repository level hierarchy?
64. How many numbers of domains exist and size of each domain?
65. What is the array fetch size for universe connection?
66. Which version of BO and WebI is currently used?
67. What is the average size of reports? Are multiple data providers and multiple report tabs used?
68. Are hierarchies defined in Unverse or Report level?
69. Within reports are there any calculated objects defined? If yes how many and at what complexity on an average in each report?
70. Is ranking, filtering, alerts used in reports?
71. What type of BO functions (Quartile, Percentile etc) is used?
72. Are there any calculated objects, which is dependent on report level objects?
73. How many approximate jobs are running at a given time through BCA?
74. Are any reports contains Free – Hand SQL, Stored Procedures and VBA Macros?
1. How many number of open middleware connections?
2. What is the Array Fetch Size of the Database?
3. Is Indexing used on data warehouse tables?
4. Are there any aggregate tables created in the database?
5. Is BO Repository has dedicated system or not?
6. Is there any row level and page level locking mechanism implemented in the BO Repository?
7. Which Database Server is used to host BO Repository?
8. How many numbers of domains are available in the BO Repository?
9. What is size of the BO Repository?
10. What is size of the Security, Universe and Document Domains?
11. Are you purging the old version of documents or not?
12. Are there any separate BO Repository servers exists?
13. Which is the network protocol used in the network?
14. Which master card and switched hub is used for process network packets?
15. Which version of Windows NT Server and Service Pack is used?
16. Are CORBA features enabled for Distributed Component Architecture?
17. What is the ratio factor of node load factor?
18. Which approach for Load Balancing is used?
19. Is all the distributed components are running on Single Server?
20. How many other resources are running simultaneously in NT Server & Web Server?
21. Are there any multiple cluster servers exist?
22. Is all the servers (multiple cluster servers) are running on the same time zone?
23. Which protocols/network cards are used to define network paths?
24. Is extranet feature used for Web Intelligence?
25. How many numbers of components are used in Broadcast Agent?
26. Which version of Broadcast Agent is used?
27. How many number of CPU’s used for BO processes?
28. What is the virtual memory (paging file) used in Windows NT Server?
29. What type of disk is used for server?
30. Which other software and drivers exists in Server?
31. What is the hardware configuration used for Windows NT, where BO Server, Repository, BCA Server and Web Intelligence Server are installed?
32. Is BO installed in NTFS partitions or not?
33. How many numbers of services are running in Windows NT at a given time?
34. How many peak time concurrent groups and users?
35. Is the machine designed and configured based on Total Supported Users and User Activity Ratio or not?
36. How many number of documents accessed in the BO Repository at a given time?
37. What is your organization’s geographical distribution?
38. How many security levels are used?
39. Is BLOB data types used in BO Repository database?
40. Is there any migration happened from older version to newer version?
41. What is the average connection of each user to BO repository?
42. Is restriction applied for sorting on non-indexed columns?
43. Are all the system components on the same subnet mask?
44. What is speed of the switched hub?
45. How many data sources will be feeding data to reporting database instance?
46. Is linked universe concept used?
47. Does the BO Reports run on OLTP or OLAP system?
48. How many standard reports? Any adhoc reporting?
49. How many BO Universes and what is the size of each universe?
50. How many approximate number of conditional, measured and derived objects used in each universe?
51. Is WebI used? Is BCA used?
52. Are BO SDK and WI SDK used for customization?
53. In which database the BO repository is located?
54. How many aliases and contexts in each Universe?
55. Is Aggregate awareness used in universe?
56. Is WebI server and Repository hosted on the same server?
57. What is hardware infrastructure for WebI, BO Repository?
58. Which Web Server is used for hosting WebI?
59. How many loaded processes are running on the server at a given time?
60. How many concurrent processes are running on the server at a given time?
61. Are there any unlinked tables in the universes?
62. Is outer join concept used in universe?
63. What is the repository level hierarchy?
64. How many numbers of domains exist and size of each domain?
65. What is the array fetch size for universe connection?
66. Which version of BO and WebI is currently used?
67. What is the average size of reports? Are multiple data providers and multiple report tabs used?
68. Are hierarchies defined in Unverse or Report level?
69. Within reports are there any calculated objects defined? If yes how many and at what complexity on an average in each report?
70. Is ranking, filtering, alerts used in reports?
71. What type of BO functions (Quartile, Percentile etc) is used?
72. Are there any calculated objects, which is dependent on report level objects?
73. How many approximate jobs are running at a given time through BCA?
74. Are any reports contains Free – Hand SQL, Stored Procedures and VBA Macros?
No comments:
Post a Comment