Sybase.com

Document ID: DC76800-01-0402-03

Topic	Page
1. Accessing current release bulletin information
2. Product summary
3. What's in the box?
4. Installation instructions
5. New features and enhancements
6. Migrating from previous versions
7. Product compatibilities
8. Known problems
9. Documentation
10. Documentation updates and clarifications
11. Other sources of information

1. Accessing current release bulletin information

A more recent version of this release bulletin may be available on the Web. To check for critical product or document information added after the release of the product CD, use the Sybase Technical Library Product Manuals Web site.

Accessing release bulletins at the Technical Library Product Manuals Web site

Go to Product Manuals.

Follow the links to the appropriate Sybase product.

Select the Release Bulletins link.

Select the Sybase product version from the Release Bulletins list.

From the list of individual documents, select the link to the release bulletin for your platform. You can either download the PDF version or browse the document online.

2. Product summary

Enclosed is Sybase Industry Warehouse Studio™ (IWS) 4.0.2.

Industry Warehouse Studio contains customizable application templates, data models, and test data for creating a data warehouse. The product you have received is tailored for one of several supported industries.

Note:

Contact your Sybase representative to be sure that you have the correct and latest data model for your application.

All Sybase Industry Warehouse Studios include infrastructure and application components. These components may be common across industries or specific to one industry.

IWS applications that can be ordered separately are discussed in the Release Bulletins for those applications.

All IWS components are available for installation from CD-ROM using the license key (or keys) you have received.

Industry Warehouse Studio 4.0.2 is certified with Windows 2000.

This release bulletin:

Briefly introduces the Industry Warehouse Studio
Provides basic installation instructions for the IWS infrastructure
Describes the installed directory structure for the IWS infrastructure
Lists documentation for the IWS infrastructure
Describes any last minute issues and provides contact information in case you need assistance

Note:

Sybase Warehouse Studio (which contains a set of tools for the operation of Industry Warehouse Studio) was previously included with Industry Warehouse Studio. Warehouse Studio is now purchased as a separate product.

Other IWS documentation has not yet been updated to reflect this separation. See “7. Product compatibilities” for details.

2.1 Infrastructure and applications

All Industry Warehouse Studio applications use the IWS infrastructure. In Version 4.0.2, the infrastructure includes:

A data model that sets up the structure for your data warehouse
SQL application templates (available for cross-industry applications and most industries)
Sample data for use in testing customizations to the applications and model
Documentation on the IWS model, application templates, and the IWS methodology for establishing a data warehouse

The Customer Analytics Infrastructure (CAI) provides infrastructure components for use with all industries. It includes SQL templates for five Customer Relationship Analytics application areas, described below.

The Business Analytics Infrastructure (BAI) components provide industry-specialized extensions, including SQL templates for business analytics application areas, described below.

Note:

Some CDs and documentation refer to the CAI by its former name, Core Analytics Infrastructure.

2.2 Analytics applications visualized for Business Objects

The Industry Warehouse Studio 4.0.2 product family includes the following add-on Analytics applications visualized for Business Objects® client/server and WebIntelligence environments:

Customer Relationship Analytics
Media Advertising Analytics
Media Circulation Analytics
Telco Analytics
Web Analytics

See the Release Bulletins for more information about these add-on applications.

2.3 Supported industries

Sybase Industry Warehouse Studio Version 4.0.2 is available for the following industries:

Financial Services (including Capital Markets, Credit Card, and Retail Banking)

Healthcare
Insurance (including Property and Casualty Insurance and Life Insurance)
Media
Telco and Utilities

2.4 Customer Analytics Infrastructure application templates

The Customer Analytics Infrastructure (CAI) includes SQL templates for Customer Relationship Analytics in these five application areas:

Application	Description
Campaign Analysis	Helps you examine the results of promotional campaigns so that you can focus future campaigns more effectively.
Customer Profile Analysis	Segments your customer base by a wide set of measures so that you can determine which groups of customers are most likely to purchase your products or services and which provide the greatest value to your organization.
Sales Analysis	Lets you determine your sales effectiveness, including total sales, cross-sales, new product sales, and other means of expanding sales to existing customers. It also lets you examine customer satisfaction; determine which types of sales are most effective for different customer characteristics; and develop sales profiles for your customers and services.
Loyalty Analysis	Helps you discover characteristics of loyal customers and determine where you may need to take action in order to retain customers.
Customer Care Analysis	Examines customer interactions, such as complaints, inquiries, fault reports, and suggestions, and helps you rate customer satisfaction overall and in selected areas of concern.

2.5 Business Analytics Infrastructure application templates

The Business Analytics Infrastructure (BAI) includes SQL templates for industry-specialized Business Decision Analytics (also referred to as Business Performance Analysis):

IWS industry	Application templates available
Financial Services	Capital Markets— Risk Analysis Credit Card— Merchant Analysis and Card Holder Analysis Retail Banking—Channel Analysis, Customer Behavior Analysis, and Profitability Analysis
Healthcare	Claims Analysis
Insurance	Property and Casualty Insurance— Channel Analysis, Customer Persistency Analysis, and Profitability Analysis Life Insurance— Channel Analysis, Customer Persistency Analysis, and Profitability Analysis
Telco and Utilities	Call Traffic Analysis and Profitability Analysis for Telco

IWS for Media

While there is a BAI for the Media industry, SQL application templates and data are not provided in the Media BAI. See the discussion of the visualized Media Advertising Analytics and Media Circulation Analytics for these application areas.

3. What's in the box?

You receive one or more of the following CDs with Industry Warehouse Studio, depending on which products you purchase:

Industry Warehouse Studio Customer Analytics Infrastructure CD
Industry Warehouse Studio <Industry> Business Analytics Infrastructure CD(s)
Industry Warehouse Studio <Application> CD(s)
Getting Started CD containing this Release Bulletin and installation information

With the CAI you also receive a printed copy of the Introduction to Industry Warehouse Studio.

Product keys

You need to enter a license key or serial number for each IWS product you install. These confidential keys are found on a set of paper documents enclosed in the package. Be sure to keep all product keys and CDs in a safe place.

3.1 Infrastructure components

See the following table for a description of IWS infrastructure components. Each component you install is specialized for the Customer Analytics Infrastructure and the Business Analytics Infrastructure for each industry.

Component	File format and purpose of deliverable
Data model	PowerDesigner 9 physical data model (.pdm) file. In order to customize any IWS application you need to understand and customize the underlying model. You also use the PDM file to produce Data Definition Language (DDL) for creating a sample database, using the supplied sample data, and for creating your target data warehouse. While the default target database for IWS is Adaptive Server IQ 12.4.3, PowerDesigner includes facilities that let you change the target RDBMS to produce DDL for other database systems.
Template SQL files	SQL files for each application template. These are delivered as .tpl files which can be saved as SQL files after making minor modifications.
Sample data	Files for populating the model database. Load files for Adaptive Server IQ 12.4.3 are included as .csv (comma-separated value) files. Adaptive Server IQ 12.4.3 index files are provided as SQL files.
Documentation	IWS infrastructure documentation includes an Introduction to Industry Warehouse Studio in both printed and PDF format, and an Industry Warehouse Studio System Integrator's Guide, Model Descriptions, and application template guides in PDF format. Also included are a general Methodology Project Plan (.mpp) file and impact analysis Excel spreadsheet (.xls) files for each application template. See “9. Documentation” for more information.

4. Installation instructions

This section provides instructions for installing IWS products from the Customer Analytics Infrastructure and Business Analytics Infrastructure CDs.

To install Media Analytics Applications (Advertising Analytics and Circulation Analytics), Telco Analytics Applications, Customer Relationship Analytics, Web Analytics, or Household Match, see the Release Bulletins for those products.

To install Warehouse Studio components, see “7. Product compatibilities”.

4.1 Installing the IWS Infrastructure

These installation instructions apply to products found on the Customer Analytics Infrastructure CD and all of the <Industry> Business Analytics Infrastructure CDs.

You need the license key or serial number for your product to install these components.

To install the Industry Warehouse Studio CAI or any BAI:

Insert the Industry Warehouse Studio Customer Analytics Infrastructure CD or the <Industry> Business Analytics Infrastructure CD in the CD drive.

If Autorun is enabled on your system, the Install shield appears and begins to install Industry Warehouse Studio infrastructure. If not, use Windows Explorer or My Computer to navigate to the root folder of the installation CD, and double-click setup.exe.

Click Next at the Welcome screen. Read the Licensing Agreement carefully. If you agree to the terms and conditions, click Yes.

Enter Serial Number screen: Enter the license key or serial number included in your product shipment.

Choose the location for the files to be installed. Click Next.

Select the components you want to install.

If you have installed any IWS 4.0.2 components previously, you can choose from these options for updating your existing IWS installation:

Modify—Add or remove a specific component

Repair—Fix a file that has a problem

Remove—Remove all existing files

Select the program folder where you want the files to be listed.

After the files are installed, click Finish.

Installation is complete. It is a good idea to make a copy of the .pdm file, which is found in the Model folder of your installation directory.

4.2 Installing EBF-1 for certain industries

Industry Warehouse Studio 4.0.2 EBF-1 adds new entity-related views to core portions of the model. It also includes updates to the claims analysis portions of the Healthcare and Insurance models. You need to download and install EBF-1 for your industry after installing any of these industries:

Healthcare
Insurance
Finance

You must have IWS BAI 4.0.2 for your industry installed and have the appropriate administrative privileges before installing IWS 4.0.2 EBF-1.

For details of changes in EBF-1and to download the software to your machine, see the Sybase Support Page. See also “11.2 Sybase EBFs and software updates” for download instructions.

4.3 Directory structure for the CAI

After installing the CAI you should see the following directory structure:

4.4 Directory structure for the BAI

After installing the BAI for your industry you should see a directory structure similar to the one for IWS for Finance BAI shown here:

Differences for each industry are:

Your industry name appears where Finance appears in this example.
For the Insurance BAI, the Business folder includes application subfolders for Life and P and C.
Healthcare and Telco & Utilities BAIs have no subfolders within their Business folder; application template .tpl files are directly in the Business folder.
Because the IWS for Media BAI does not include a SQL application template or data, its directory structure includes only the Documentation, Model, and Win32 folders, and the Indexes subfolder is within the Model folder.

When any IWS documentation mentions <IWS install path>, it either refers to the default install path, C:\Program Files\Sybase\Industry Warehouse Studio 4.0.2 or the install path you specified during installation.

If you are installing other IWS applications, see the Release Bulletin or Installation and Configuration Guide for your application for its installed directory structure.

5. New features and enhancements

Industry Warehouse Studio 4.0.2 includes a number of major new and revised features.

5.1 PowerDesigner 9 models

All IWS models are now PowerDesigner 9 PDM files. As discussed elsewhere in this release bulletin, you must use PowerDesigner 9.0 EBF3 with Industry Warehouse Studio 4.0.2.

Many of the procedures you use to view and modify the model have changed. See the Industry Warehouse Studio System Integrator's Guide for details.

PowerDesigner 9 and PDM files replace WarehouseArchitect and WAM files used in previous IWS releases.

5.2 PowerDesigner Repository

You use the PowerDesigner Repository within PowerDesigner 9 to:

Extract the data model, consolidate changes, and provide version control, so that you can easily use the IWS model in a team development environment
Generate DDL for the sample data warehouse based on the data supplied with your IWS application or application template
Generate DDL for your target data warehouse
Export metadata to Warehouse Control Center so that you can generate information cubes for business intelligence tools

All of these procedures have changed from previous versions. See the IWS System Integrator's Guide for details.

The PowerDesigner Repository replaces MetaWorks used in previous IWS releases.

5.3 Model changes and synchronization among products

The models for all IWS 4.0.2 products, applications, and industries are based on the same version of the IWS base model. This means that any 4.0.2 applications can be run on the same target warehouse database. Of course, if you modify the model and want to use a single target warehouse for different IWS applications, it is your responsibility to keep your model customizations synchronized.

This release includes additions to all IWS models. If you are upgrading from an earlier version, see “6. Migrating from previous versions” for instructions on viewing model changes.

For the latest information on the IWS models, see the Introduction to Sybase Industry Warehouse Studio, and the Model Descriptions document for your model.

5.4 Sample data for Adaptive Server IQ

Industry Warehouse Studio 4.0.2 provides the ability to quickly create a demonstration warehouse on Adaptive Server IQ 12.4.3. Sample IQ data load files and indexes are included with all IWS applications and application templates. Indexes are provided as SQL files. Load files are provided as .csv files. Using the PowerDesigner Repository and these files, you can create and load an Adaptive Server IQ database, which you can run on an Adaptive Server IQ 12.4.3 server.

IWS is database independent

Although Industry Warehouse Studio models are delivered with Sybase Adaptive Server IQ 12.4.3 as a target database, you can create a database using another RDBMS. For information on the necessary modifications to the IWS components, see the Sybase Industry Warehouse Studio System Integrator's Guide and the section on “Creating an IWS Sample Database” found either in your CAI or BAI application template guide, or in the Installation and Configuration Guide for your IWS Analytics application for Business Objects.

IWS sample database and Adaptive Server IQ

Adaptive Server IQ 12.4.3 is required to use the IWS 4.0.2 sample database as delivered by Sybase. You can use the sample data load files provided with your IWS applications on all supported Adaptive Server IQ 12.4.3 platforms. Updates to Adaptive Server IQ are available for download on the Sybase Support Web Site. When upgrading Adaptive Server IQ, be sure to upgrade both Client and Server.

Adaptive Server IQ 12.4.3 installs Sybase Central Java Edition viewer version 3.2.0. Other Sybase products may not be compatible with this version of Sybase Central. Multiple versions of Sybase Central can co-exist on the same system. Refer to the release bulletin for each Sybase product and use the version of Sybase Central that is released with that product.

5.5 Warehouse Control Center 4.0.2

IWS 4.0.2 relies on an improved version of Warehouse Control Center. For details, see Release Bulletin Warehouse Control Center 4.0.2 on the Getting Started CD for Warehouse Studio 4.0.2.

5.6 Product structure changes

The IWS product set has been restructured to reflect the broader set of functionality in this version over previous versions. See “2. Product summary” for a summary of the current product structure. In particular, note that:

The five cross-industry Customer Relationship Analytics SQL application templates are now included in the Customer Analytics Infrastructure (CAI)
The industry-specific Business Analytics SQL application templates are now included in the Business Analytics Infrastructure (BAI)
Warehouse Studio is now a companion product to Industry Warehouse Studio

5.7 Analytics applications visualized for Business Objects

The Industry Warehouse Studio 4.0.2 product family includes the following add-on Analytics applications visualized for Business Objects client/server and WebIntelligence environments.

Media Advertising Analytics
Media Circulation Analytics
Customer Relationship Analytics
Web Analytics
Telco Analytics

See the Release Bulletins for these applications for more information.

5.8 Household Match

The Industry Warehouse Studio 4.0.2 product family includes an updated version of IWS Household Match. See the Release Bulletin for Household Match for more information.

6. Migrating from previous versions

Because Industry Warehouse Studio applications are designed to be customized, you cannot directly upgrade an older data model or SQL to the newest one.

In addition, because this version of Industry Warehouse Studio uses PowerDesigner instead of WarehouseArchitect, you cannot directly compare a WAM file from an older version to the PDM file provided with Version 4.0.2 and up. If you want to determine differences between the new model and one from any version that uses a WAM file, follow the procedure below.

If you are migrating from an older version and need to convert an IWS WAM file to a PDM, contact your Sybase Professional Services representative for assistance.

6.1 Viewing model differences

The IWS 4.0.2 release relies on the data model that is installed in the \Model folder within your installed directory structure. You must use the model that is shipped with this release.

Because Industry Warehouse Studio applications are designed to be customized, you cannot directly upgrade an older data model to the newest one. However, if you have an older version of IWS, and if you retained your original WAM file from the earlier version, you can use the PowerDesigner 9 Repository to display changes in the Version 4.0.2 submodels.

Models to compare may reside either in the PowerDesigner 9 (PD9) Repository or in the PD9 workspace.

Refer to the PowerDesigner online documentation for more information.

To view model changes in PowerDesigner 9:

Click File → Open to open the Version 4.0.2 PDM file in PowerDesigner 9. This file is CRM.pdm for the CAI, or <industry>.pdm for the BAI (for example, Media.pdm).

Click File → Open to open the old WAM file in PD9.

You must select Warehouse Model (*.wam; *.mdw) from the list of file types in order to open the WAM file.

Click File → Save As to save the WAM file as a PDM file.

Click Repository → Connect and connect to the Repository.

Right-click on either the old or the new version of the model and select Compare w/ Repository.

Select the Version 4.0.2 PDM from the drop-down list in the “Model 1" section of the comparison dialog window. Click either the Workspace or Repository button to indicate where the model resides.

Select the older version model from the drop-down list in the “Model 2" section of the same dialog window. Click either the Workspace or Repository button to indicate where the model resides.

Wait until the comparison is complete. The Compare Models window opens.

Differences are indicated with an exclamation point (!) icon on the objects in the Compare Models window. Objects that exist in one model, but not the other, are indicated with a red exclamation point.

Further information on differences is available in the Properties section at the bottom of the window, when an object is selected above.

The model comparison shows many differences in the models, due to the change in model structures between WarehouseArchitect and PowerDesigner 9. Reviewing the model changes is easier, if you reduce the number of differences shown.

To reduce the number of model differences shown:

After running the model comparison in PD9, click the Comparison Options button on the toolbar.

Click the Deselect All button in the Comparison Options window.

Select only the items for which you want to review changes.

For example, under “Physical Data Model,” click the box next to Domains. Scroll down the tree hierarchy and click the boxes for Tables, Views, and References under “Packages.” Select details to compare under Table, then under Column, Key, Reference, View, etc.

This step excludes differences due to the migration of WarehouseArchitect submodels to PowerDesigner diagram and package structures.

Note:

In the comparison, you see mirror tables for views in the old model that do not exist in the new model. Also, the tables and views in the new model are owned by packages, instead of by the physical model at the top level.

7. Product compatibilities

Industry Warehouse Studio 4.0.2 is compatible with the components included in Warehouse Studio 4.0.2.

Industry Warehouse Studio 4.0.2 Analytics applications are compatible with Customer Analytics Infrastructure 4.0.2, and with Version 4.0.2 of the Business Analytics Infrastructure for the appropriate industry.

7.1 Warehouse Studio Components

Warehouse Studio provides a common set of tools which you use to view and customize the data model, manage metadata for your warehouse, import metadata to the Meta Data Manager, and export metadata to popular business intelligence tools

This section describes the common components provided in all Sybase Industry Warehouse Studios.

Component	Version	Installation Source	Description
PowerDesigner®	9.0 with EBF3	PowerDesigner Studio Enterprise CD Sybase Support Web Site, EBF/Updates downloads	A warehouse and data mart design tool, with the capability to generate DDL for many target databases. Also includes a full range of reporting features on warehouse objects, including multidimensional objects. Includes the PowerDesigner Repository, a change management tool for model development in a team environment, with versioning comparisons. Also used to export model structure to Warehouse Control Center Meta Data Manager.
Warehouse Control Center®	4.0.2	Warehouse Studio CD	A graphical browsing and management tool for metadata, including logical and technical views of metadata for all databases in the organization. metadata describes the data items in a database, including originating source, extract or calculation rules, physical attributes, data definitions, and textual descriptions.
Adaptive Server Anywhere server™ including: ODBC (client side drivers) for: ASA ASE Open Client Runtime (required by the ASE ODBC driver) Sybase Central™ and Plug-in for Adaptive Server Anywhere™ (ASA) jConnect for JDBC™	7.0.2 7.0.2 12.0 12.0 4.0.1 4.2 and 5.2	Warehouse Studio CD	A full service, small footprint database server, with all necessary drivers for ODBC applications. Sybase Central is a graphical tool for centralized management of Sybase databases. The Java Open Database Connectivity (JDBC) interface provides for standardized access to databases from Java applications. jConnect for JDBC implements this interface for Sybase databases. The software required for making the JDBC connections is automatically loaded with client tools that are JDBC enabled.

Component

Version

Installation Source

Description

PowerDesigner®

9.0 with EBF3

PowerDesigner Studio Enterprise CD

Sybase Support Web Site, EBF/Updates downloads

A warehouse and data mart design tool, with the capability to generate DDL for many target databases. Also includes a full range of reporting features on warehouse objects, including multidimensional objects.

Includes the PowerDesigner Repository, a change management tool for model development in a team environment, with versioning comparisons. Also used to export model structure to Warehouse Control Center Meta Data Manager.

Warehouse Control Center®

4.0.2

Warehouse Studio CD

A graphical browsing and management tool for metadata, including logical and technical views of metadata for all databases in the organization.

metadata describes the data items in a database, including originating source, extract or calculation rules, physical attributes, data definitions, and textual descriptions.

Adaptive Server Anywhere server™ including:

ODBC (client side drivers) for:

Open Client Runtime (required by the ASE ODBC driver)

Sybase Central™ and Plug-in for Adaptive Server Anywhere™ (ASA)

jConnect for JDBC™

7.0.2

12.0

4.0.1

4.2 and 5.2

Warehouse Studio CD

A full service, small footprint database server, with all necessary drivers for ODBC applications.

Sybase Central is a graphical tool for centralized management of Sybase databases.

The Java Open Database Connectivity (JDBC) interface provides for standardized access to databases from Java applications. jConnect for JDBC implements this interface for Sybase databases.

The software required for making the JDBC connections is automatically loaded with client tools that are JDBC enabled.

7.2 Installing from the Warehouse Studio CD

You install the following products from the Warehouse Studio CD:

Warehouse Control Center
Adaptive Server Anywhere

You need the Adaptive Server Anywhere Installation Key to install Adaptive Server Anywhere 7.0.2.

You do not need an installation key to install Warehouse Control Center.

Authenticated version of Adaptive Server Anywhere

Warehouse Studio includes two different Adaptive Server Anywhere installations. Normally, you should install the full version of Adaptive Server Anywhere, available directly from the main Warehouse Studio installation menu. This version lets multiple users connect to Adaptive Server Anywhere simultaneously from PowerDesigner and Warehouse Control Center.

There is also an authenticated version of Adaptive Server Anywhere, installable from within the PowerDesigner installation menu. The authenticated version is enabled for single-user access with the PowerDesigner Repository only. In order to use this version of Adaptive Server Anywhere on the Repository database, you need to run a script to authenticate the database. For more information on the authenticated version of Adaptive Server Anywhere, see Part Two, Installing Adaptive Server Anywhere, in the PowerDesigner Repository User's Guide.

To install Warehouse Studio executables from the main installation menu:

Insert the Warehouse Studio CD into your computer.

If Autorun is enabled on your system, the Install shield appears and displays the main installation menu. If not, use Windows Explorer or My Computer to navigate to the root folder of the installation CD, and double-click setup.exe.

If you choose to exit the main menu and install components at a later time, click on the setup.exe file to return to the main menu.

Select Install Products from the Main Menu. Read the Licensing Agreement carefully. If you agree to the terms and conditions, click Yes.

Select a product to install.

7.2.1 Installing Warehouse Control Center

To install Warehouse Control Center, see the Warehouse Control Center Installation and Configuration Guide on the Getting Started - Warehouse Studio CD. Be sure to follow the configuration steps it describes, before you install Warehouse Control Center. Summary installation steps are provided here.

Warehouse Control Center provides the following installation options:

Setup Type screen: You can install:

WCC Application Programming Interfaces
WCC Web Client Files
WCC Meta Data Manager

Select Components screen: You can choose from the following options:

Under WCC Meta Data Manager:

Sybase Central Java
Meta Data Manager

Under WCC Web Client Files:

Template for Automatic Web Site
Template for Manual Web Site

Note:

Warehouse Control Center 4.0.2 is certified with Windows 2000.

7.2.2 Installing Adaptive Server Anywhere

Adaptive Server Anywhere offers the following installation options:

Setup Type screen: Your installation type options are:

Network Client
Network Server (includes Personal Server with SQL Remote)
Personal Server
Personal Server with SQL remote

Select Components screen: Select the components you wish to install. For example, your options for Network Client are:

Adaptive Server Anywhere
Sybase Central
jConnect
Help Files

If you highlight Adaptive Server Anywhere or Help Files and click the Change button, you can select or deselect a series of options for installation. These options change depending on which type of installation you have selected.

7.3 Installing PowerDesigner 9.0 and EBF 3

To install PowerDesigner 9 Studio Enterprise, see the PowerDesigner Installation Guide on the Getting Started - Warehouse Studio CD and the printed PowerDesigner Installation Key.

After installing PowerDesigner 9, you must download and install PowerDesigner 9 EBF3. This EBF is required to use PowerDesigner with IWS 4.0.2 models.

You download PowerDesigner 9 EBF3 from the Sybase Support Web Site. Click EBFs/Updates and follow the instructions on the site. You must enter your Sybase user name and password to download the EBF.

8. Known problems

This section describes known problems in the CAI and BAI for this release. See the Release Bulletins for your IWS applications for more information.

8.1 PowerDesigner model reference errors

In the PowerDesigner model, some view references between a core view shortcut and an industry-specific view or table do not contain join information. PowerDesigner is unable to locate the shortcut referenced; if you are in the View Reference Properties dialog of the shortcut and try to click on the Joins tab, PowerDesigner returns the error message

"<NAME_OF_SHORTCUT> (Shortcut): Unknown."

This error causes “Existence of View Reference Join” errors during the check model and DDL generation process.

Workaround

Change the Existence of View Reference Join check from an error to a warning. This change does not interfere with DDL creation, as view references are not generated. This problem has been submitted to PowerDesigner.

To change the Existence of View Reference Join check to a warning:

With the model open in PowerDesigner, select Tools → Check Model.

The Check Model Properties dialog displays.

On the Options tab, expand the View Reference node.

Select Existence of view reference join.

Click the Warning button near the top of the Options tab.

A warning symbol appears next to Existence of view reference join.

Click Apply, then click OK.

Check model executes and displays the results in the Results List window.

8.2 View creation when generating DDL

Changing the database owner from the default user (_O_W_N_E_R_) alters the view SQL statements in all versions of Oracle and possibly in other RDBMS systems. For example, the SQL may be formatted all on one line and is then truncated by the RDBMS, or alias names are changed so that they are not recognized by the RDBMS. This alteration prevents views from being created correctly when the DDL is run.

Workaround

Generate DDL with the default database user (_O_W_N_E_R_). Do not change the default user in PowerDesigner 9.0. After you generate the DDL, use Notepad or other text editor to manually replace all instances of the default user in the generated file.

Use a backed-up version of the original model.

8.3 SQL Inserts

There are records in both the D_CORE_RPT_STRC and D_PRODUCT SQL insert files that include the ampersand character (&) within data values. This causes the SQL script to pause execution. If you choose to escape, that record is inserted, but execution continues.

Workaround

Add an escape character in front of the ampersands (&) within the files before execution.

9. Documentation

You can access the books and spreadsheets from the program group you specify during installation. In Windows, click Start, point to Programs → Sybase → Industry Warehouse Studio 4.0.2 and then select the appropriate document name.

9.1 CAI and BAI application template, IWS model, and IWS methodology documentation

The table below lists documentation for the CAI and BAIs. For add-on application documentation, see the Release Bulletin for your application.

Title	Description	Audience	Filename	Name in menu	Installed with
Introduction to Sybase Industry Warehouse Studio	Data warehousing and data model concepts, instructions for changing IWS models and loading data, and steps for implementing a demonstration warehouse	Users, system integrators, project managers, system administrators	IWS_Intro_Guide.pdf Also provided in print	Introduction to Industry Warehouse Studio	CAI All BAIs
Sybase Industry Warehouse Studio System Integrator's Guide	Methodology for planning and implementing an IWS data warehouse	System integrators and system administrators	SysIntGuide.pdf	IWS System Integrator's Guide	CAI All BAIs
Methodology project plan	Microsoft Project file for implementing IWS, used with the System Integrator's Guide	System integrators and system administrators	method.mpp	Methodology Project Plan	CAI All BAIs
Industry Warehouse Studio Customer Analytics Infrastructure Model Descriptions	Descriptions of the tables and columns in the core data model for each of the five CRA applications and Web Analytics	Application developers and system integrators	ModelDescCAI.pdf	Model Description CAI	CAI
Industry Warehouse Studio Customer Analytics Infrastructure	Application guide to Customer Analytics SQL templates	Users and system integrators	cai_apps.pdf	Customer Analytics Infrastructure	CAI
<CAI_application> Impact Analysis	Spreadsheet for determining impact of model changes on SQL	System integrators and application developers	CA_Impact_Analysis.xls CC_Impact_Analysis.xls CP_Impact_Analysis.xls LA_Impact_Analysis.xls SA_Impact_Analysis.xls	CA Impact Analysis CC Impact Analysis CP Impact Analysis LA Impact Analysis SA Impact Analysis	CAI
Industry Warehouse Studio Business Analytics Infrastructure for Financial Services Model Descriptions	Descriptions of the tables and columns in the Financial Services model	Application developers and system integrators	ModelDescFinance.pdf	IWS Model Description –Finance	Financial Services BAI
Industry Warehouse Studio Business Analytics Infrastructure Financial Services	Application guide to Capital Markets, Credit Card, and Retail Banking SQL templates	Users and system integrators	bai_finance.pdf	Business Analysis Infrastructure – Finance	Financial Services BAI
Impact Analysis (Capital Markets, Credit Card, Retail Banking)	Spreadsheet for determining impact of model changes on SQL for Capital Markets, Credit Card, and Retail Banking	System integrators and application developers	CM_Impact_Analysis.xls CR_Impact_Analysis.xls RB_Impact_Analysis.xls	CM Impact Analysis CR Impact Analysis RB Impact Analysis	Financial Services BAI
Industry Warehouse Studio Business Analytics Infrastructure for Healthcare Model Descriptions	Descriptions of the tables and columns in the Healthcare model	Application developers and system integrators	ModelDescHealth.pdf	IWS Model Description– Healthcare	Health- care BAI
Industry Warehouse Studio Business Analytics Infrastructure Healthcare	Application guide to Healthcare SQL template	Users and system integrators	bai_healthcare.pdf	Business Analysis Infrastructure – Healthcare	Health- care BAI
Healthcare Impact Analysis	Spreadsheet for determining impact of model changes on SQL	System integrators and application developers	HC_Impact_Analysis.xls	HC Impact Analysis	Health- care BAI
Industry Warehouse Studio Business Analytics Infrastructure for Insurance Model Descriptions	Descriptions of the tables and columns in the Insurance model	Application developers and system integrators	ModelDescIns.pdf	IWS Model Description –Insurance	Insurance BAI
Industry Warehouse Studio Business Analytics Infrastructure Insurance	Application guide to Life Insurance and Property and Casualty Insurance SQL templates	Users and system integrators	bai_ins.pdf	Business Analysis Infrastructure – Insurance	Insurance BAI
Insurance Impact Analysis	Spreadsheet for determining impact of model changes on SQL	System integrators and application developers	LF_Impact_Analysis.xls PC_Impact_Analysis.xls	LF Impact Analysis PC Impact Analysis	Insurance BAI
Industry Warehouse Studio Business Analytics Infrastructure for Media Model Descriptions	Descriptions of the tables and columns in the Media model	Application developers and system integrators	ModelDescMedia.pdf	IWS Model Description –Media	Media BAI
Industry Warehouse Studio Business Analytics Infrastructure for Telco and Utilities Model Descriptions	Descriptions of the tables and columns in the Telco & Utilities model	Application developers and system integrators	ModelDescTelco.pdf	IWS Model Description –Telco	Telco & Utilities BAI
Industry Warehouse Studio Business Analytics Infrastructure Telco and Utilities	Application guide to Telco SQL template	Users and system integrators	bai_telco.pdf	Business Analysis Infrastructure – Telco	Telco & Utilities BAI
Telco Impact Analysis	Spreadsheet for determining impact of model changes on SQL	System integrators and application developers	TA_Impact_Analysis.xls	TA Impact Analysis	Telco & Utilities BAI

All documents are installed in the Documentation folder within the installation directory for the CAI or your industry. You can access them using Windows Explorer. To open the books, spreadsheets, or the project file, double-click on the filename.

Only the documentation for your industry and applications will be available to you.

9.2 Warehouse Studio documentation

You receive Warehouse Studio documentation when you purchase Warehouse Studio, a companion product to Industry Warehouse Studio.

Documentation for Warehouse Control Center, PowerDesigner, and Adaptive Server Anywhere is provided in these products as online help within the product.

Documentation for Warehouse Control Center is also provided as PDF files that you install with Warehouse Control Center under <WCC Install Path>\Documentation.

Documentation for Warehouse Control Center API is also provided as PDF files that you install with Warehouse Control Center under <WCC Install Path>\wcc_api.

PowerDesigner documentation is also available in Technical Library format. From the PowerDesigner program group in the Windows Start menu, click Online Documentation.

Documentation for Warehouse Control Center, PowerDesigner, and Adaptive Server Anywhere can also be found on the Sybase Product Manuals Web site. You can access this site using a standard Web browser. In addition to product manuals, you'll find links to the Technical Documents Web site (formerly known as Tech Info Library), the Solved Cases page, and Sybase/Powersoft newsgroups.

To access the Technical Library Product Manuals Web site, go to Product Manuals. From there:

To access documentation for Warehouse Control Center, select Industry Warehouse Studio from the drop-down list, and click Go!
To access documentation on the Product Manuals Web site for Adaptive Server Anywhere, select Adaptive Server Anywhere from the drop-down list.
To access documentation on the Product Manuals Web site for PowerDesigner 9, select PowerDesigner from the drop-down list.

10. Documentation updates and clarifications

This sections describes items that were omitted from the documentation, and some new information that needs emphasis.

10.1 Viewing PDF files

In order to view PDM graphs in IWS documentation on-screen using Adobe Acrobar, you may need to zoom the page to at least 250%. To do this, click View → Zoom To and enter 250 (or higher) in the Magnification box. You do not need to zoom the document in order to print visible WAM graphs.

Adobe Acrobat numbers pages consecutively, starting at the title page, while the page numbers you see in the Table of Contents and at the bottom of each page are numbered with Roman numerals in the front matter, and consecutively from 1 starting with Chapter 1.

To find the page you want, add the number of pages in the front matter (6 or 8, depending on the book) to the number in the Contents when using View → Go To Page. You can also use Tools → Find and enter the text you are looking for.

10.2 Installing PowerDesigner 9

The System Integrator's Guide incorrectly states that you need to install PowerDesigner 9 from the Warehouse Studio Executable Components CD-ROM. You install this software from the PowerDesigner Studio Enterprise CD. Be sure to download PowerDesigner EBF3 after installing PowerDesigner 9.

10.3 Installing Adaptive Server Anywhere

The System Integrator's Guide incorrectly states that you install Adaptive Server Anywhere 7.0.3 from the Warehouse Studio Executable Components CD. The correct version is Adaptive Server Anywhere 7.0.2, which you install from the Warehouse Studio CD.

10.4 .SQL and .TPL files

All application SQL files are saved as .tpl files (.tpl indicates TEMPLATE). This implies that the SQL file needs modification – for example, the _O_W_N_E_R_ variable must be changed, as described in “Creating a Sample Database” in your application documentation.

Many of the application SQL files have been separated into more than one file for each report. If you intend to run the SQL from within a Business Intelligence tool rather than a simple SQL editor, you may wish to combine the separate SQL into a single statement, which will allow you to analyze data by several dimensions at once.

Note:

In the documentation, .tpl and .sql are used interchangeably.

10.5 Missing figures in Customer Analytics Infrastructure appendix

Appendix A, “Creating a Sample Database,” in Industry Warehouse Studio Customer Analytics Infrastructure, is missing some sample screens. A default figure appears instead. All of the information you need to perform the procedures where these sample screens occur is in the text of the procedures. Note that these screens appear correctly in the same appendix of the Business Analytics Infrastructure guides, and the same chapter in the Installation and Configuration Guides for Business Objects applications.

10.6 Default OwnerID on SQL files

All application SQL files, as well as the indexes.sql file included with all models, contain a default OwnerID. These files must be updated with the database for the local database implementation. Replace all occurrences of _O_W_N_E_R_ with the OwnerID for the warehouse database.

To do this quickly, you may use the IWSUPDT.EXE application provided in the <IWS Install Path>\Win32 directory to make these updates. You can also access this program from the start menu by selecting Start → Program Files → Sybase → Industry Warehouse Studio 4.0.2 → IWS Update Utility.

10.7 Updating OwnerID in the PDM Files

The default OwnerID (_O_W_N_E_R_) for each table and view in the PDM must be changed to the actual database owner under which the IWS tables are created. You must save this change within the PDM file before creating DDL for your database. Do not attempt to create the DDL and then replace the OwnerID, as some tables and views may not have the correct default OwnerID. You must also save this change within the PDM file before importing the PDM into Warehouse Control Center. This ensures that your metadata is consistent with your physical warehouse database.

10.8 Time Period Values in Demo Database

In the demonstration warehouse database, the D_TIME_PERIOD table is populated with a row whose ID is equal to 0. A Time Period ID of 0 signifies an undetermined future date. For example, many tables contain both Begin Date and End Date columns as foreign keys to Time Period. For any given set of measurements, these tables should always have one “current” record whose End Date ID value is 0.

In the supplied sample data, D_TIME_PERIOD goes through 2001. For sample data through 2002, contact your Sybase representative.

10.9 Warehouse Control Center PDM import and validation

To import and validate a PowerDesigner model in WCC, change the owner to a new user internally in PowerDesigner 9, then consolidate the model. Validation works at this point, but the consolidated model cannot be used to generate DDL due to the problems with view SQL.

If you change the default database user in PowerDesigner, do not extract the consolidated model.

10.10 Adaptive Server IQ database options reset

The script that loads the sample data into the Adaptive Server IQ sample database, Load_<application>_Tables.tst, sets the IQ database option Query_Temp_Space_Limit to 0. This option setting is necessary for refreshing data when running the IWS Business Analytics reports as a Business Objects client.

The load script also sets the IQ database options Main_Cache_Memory_MB and Temp_Cache_Memory_MB to 32. These values are recommended for the sample database. For your actual data warehouse, more appropriate settings are:

set option public.Main_Cache_Memory_MB = 128;
set option public.Temp_Cache_Memory_MB = 256;

11. Other sources of information

Use the Sybase Getting Started CD and the Technical Library Product Manuals web site to learn more about your product:

The Getting Started CD contains release bulletins and installation guided in PDF format and may also contain other documents or updated information. It is included with your software. To read or print documents on the Getting Started CD you need Adobe Acrobat Reader, downloadable at no charge from the Adobe web site using a link provided on the CD.
The Technical Library Product Manuals web site is an HTML version of documentation that you can access using a standard web browser. In addition to product manuals, you will find links to EBFs/updates, technical documents, case management, solved cases, newsgroups, and the Sybase Developer Network.

To access the Technical Library Product Manuals web site, go to Product Manuals.

11.1 Sybase certifications on the web

Technical documentation at the Sybase web site is updated frequently.

Finding the latest information on product certifications

Point your web browser to Technical Documents.

Select Products from the navigation bar on the left.

Select a product name from the product list and click Go.

Select the Certification Report filter, specify a time frame, and click Go.

Click a Certification Report title to display the report.

Creating a personalized view of the Sybase web site (including support pages)

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase web pages.

Point your web browser to Technical Documents.

Click MySybase and create a MySybase profile.

11.2 Sybase EBFs and software updates

Finding the latest information on EBFs and software updates

Point your web browser to the Sybase Support Page.

Select EBFs/Updates. Enter user name and password information, if prompted (for existing web accounts) or create a new account (a free service).

Select a product.

Specify a time frame and click Go.

Click the Info icon to display the EBF/Update report, or click the product description to download the software.