|
If you are knowledgeable of IBM's
Business Intelligence solutions and the fundamental concepts of relational and
multidimensional database technologies, and are capable of performing the
intermediate and advanced skills required to design, develop and support custom
analytical applications, you may benefit from this
certification. Section 1 - Architecture (10%) - Identify the
application servers (i.e. Websphere, Websphere portal) database architecture
(i.e. relational, multi-dimensional), hardware operating system (i.e. Windows,
Unix, Linux) and application architecture (i.e. Model View Control (MVC)
- Determine hardware sizing
- Create a database and application
security model
- Define users and their roles
Section 2 - Installation (18%) - Install
Alphablox under the various server applications
- Configure security for
the Alphablox application
- Create and test Alphablox data sources for
relational and multidimensional databases
- Configure JDBC Drivers and
MDB adapters
- Configure Application Server JVM settings
- Install Alphablox under the WebSphere Portal
- Configure
Alphablox repository (database vs. filebased)
- Install Alphablox in a
cluster
- Define web terms (i.e., .war file, .ear file, web.xml file,
etc.)
- Configure Alphablox to work with RDBMS connection pools
Section 3 - Development (34%) - Configure RAD or
WSAD development environment for Alphablox
- Code an Alphablox
application in the development environment using JSP, servlets, Java Script,
and HTML
- Use the blox for presentation of grids and charts
- Use the FormBlox for application controls
- Use the
RelationalBlox for relational reporting
- Use the UI Model for advanced
customization manipulation
- Use the Infrastructure Blox (AdminBlox) for
internal application management
- Debug application and performance
issues
- Structure an application
- Use the client’s API in an
application
- Define JSP Terms (JSP, tag library, scriptlets, etc.)
- Define steps to putting a blox on a page
- Define steps to
putting a blox in a portlet
- Adding additional menu items to a blox
- Creating themes (alphablox and portal
- Identify data schema
prerequisites for the cubing engine (i.e., understanding the star schema
requirements)
- Determine cube capacity
- Configure a database
for cube performance
Section 4 - Integration (5%) - Configure single
sign on with Alphablox from LDAP or other third party security providers
- Configure Alphablox applications to run within WebSphere Portal
- Configure Alphablox with other supported application servers
Section 5 - Create Alphablox Cubes (23%) - Import
cube views metadata
- Define Alphablox Cubes using the Alphablox Cubing
UI
- Define tuning queries and refresh cycles
- Define the
sorting of members
- Use MDX to query cubes
Section 6 - Test and Deployment (10%) - Deploy
the EAR file to the application server
- Use web testing technologies to
verify the Alphablox applications’ performance
- Set up and distinguish
between test production servers
- Perform and manager source control
- Backup Alphablox repository
- Migrate application and server
configuration
|
