Switch to standard view 
  Sybase logo
 
 
 



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

  1. Go to Product Manuals.

  2. Follow the links to the appropriate Sybase product.

  3. Select the Release Bulletins link.

  4. Select the Sybase product version from the Release Bulletins list.

  5. 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:



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:

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:

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:

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:

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:

  1. 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.

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

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

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

  5. 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

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

  7. 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:

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:

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:

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:

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.

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:

  1. 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).

  2. 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.

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

  4. Click Repository Connect and connect to the Repository.

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

  6. 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.

  7. 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.

  8. 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:

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

  2. Click the Deselect All button in the Comparison Options window.

  3. 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.

7.2 Installing from the Warehouse Studio CD

You install the following products from the Warehouse Studio CD:

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:

  1. 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.

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

  3. 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:

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

Under WCC Meta Data Manager:

Under WCC Web Client Files:



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:

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

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:

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

    The Check Model Properties dialog displays.

  2. On the Options tab, expand the View Reference node.

  3. Select Existence of view reference join.

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

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

  5. Click Apply, then click OK.

  6. 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:

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:

11.1 Sybase certifications on the web

Technical documentation at the Sybase web site is updated frequently.

Finding the latest information on product certifications

  1. Point your web browser to Technical Documents.

  2. Select Products from the navigation bar on the left.

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

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

  5. 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.

  1. Point your web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.


11.2 Sybase EBFs and software updates

Finding the latest information on EBFs and software updates

  1. Point your web browser to the Sybase Support Page.

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

  3. Select a product.

  4. Specify a time frame and click Go.

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




Back to Top
© Copyright 2010, Sybase Inc.