Switch to standard view 
  Sybase logo
 
 
 



DocID: DC76800-01-0410-01

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

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

Sybase Industry Warehouse Studio™ (IWS) 4.1 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.




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 using the license key (or keys) you have received.

Industry Warehouse Studio 4.1 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.1, the Customer Analytics 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, as described in “2.3 Customer Analytics Infrastructure application templates”.

The Media Business Analytics Infrastructure (BAI) components provide industry-specialized extensions, as described in “2.4 Business Analytics Infrastructure for the Media industry”.



Note:

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


2.2 Analytics applications visualized for Business Objects

Version 4.1 of the Industry Warehouse Studio product family includes the add-on Analytics applications Media Advertising Analytics and Media Circulation Analytics visualized for Business Objects® client/server and WebIntelligence environments.

See the Release Bulletin Industry Warehouse Studio for Media Applications for more information about these add-on applications.

2.3 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.4 Business Analytics Infrastructure for the Media industry

The Business Analytics Infrastructure (BAI) for the Media industry provides industry-specialized extensions to the IWS CAI. This version of BAI for Media includes:

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.

Installation 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 descriptions of IWS infrastructure components. Each component you install is specialized for the Customer Analytics Infrastructure.

CAI component

File format and purpose

Data model

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

See the following table for descriptions of IWS BAI for Media infrastructure components. Each component you install is specialized for the Business Analytics Infrastructure for the Media industry.

Media BAI component

File format and purpose

Data model

PowerDesigner 9.5.2 physical data model (Media.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 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.

Index files

Adaptive Server IQ 12.4.3 index files are provided as SQL files.

Documentation

IWS for Media infrastructure documentation includes Introduction to Industry Warehouse Studio, Industry Warehouse Studio System Integrator's Guide, and Media Model Descriptions in PDF format.

Also included is a general Methodology Project Plan (.mpp) file to use with the Industry Warehouse Studio System Integrator's Guide to create a data warehouse with IWS.

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), see the Release Bulletin Industry Warehouse Studio for Media Applications.

To install the companion Warehouse Studio components, see Release Bulletin Warehouse Studio for Version 4.1.

4.1 Installing the IWS Infrastructure

These installation instructions apply to products found on the Customer Analytics Infrastructure CD and the Media Business Analytics Infrastructure CD.

First IWS Infrastructure installation

The installation procedure for CAI or Media BAI installed on a system is simple using the Setup wizard, as described in the following procedure. If CAI or Media BAI is already installed on your system, follow the procedure in the section “Additional IWS Infrastructure component installation” to install other components.

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

To install the Industry Warehouse Studio CAI or Media BAI:

  1. Insert the Industry Warehouse Studio CAI or Media BAI installation CD in the CD drive.

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

  2. Click Next on the Welcome dialog.

  3. Select your geographical location on the Select Install Location dialog and click Next.

  4. Read the License Agreement carefully. If you agree to the terms and conditions, click Yes.

    If you cannot read the license agreement for your geographical location, refer to the instructions in the section “8.2 License Agreement does not display properly”.

  5. In the Customer Information dialog, enter the serial number from the Installation Key document included with this product and click Next.

  6. Choose the target directory for the files to be installed, or accept the default C:\Program Files\Sybase\Industry Warehouse Studio 4.1. Click Next.

    Although the setup wizard installs IWS Infrastructure components in C:\Program Files\Sybase\Industry Warehouse Studio 4.1 by default, you can specify another target directory during installation.

  7. Follow the instructions on the Setup wizard dialogs. 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.

Additional IWS Infrastructure component installation

If you have installed IWS CAI or Media BAI components previously, the Setup wizard presents more options during the installation procedure. Follow the steps below to install additional components.

To update the current IWS CAI or Media BAI installation:

  1. Insert the Industry Warehouse Studio CAI or Media BA installation CD in the CD drive.

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

  2. The Welcome dialog displays options to update the current installation. Choose one of the following options, then click Next.

    Modify—Add or remove a specific component

    Repair—Reinstall all previously installed components

    Remove—Remove all installed components

    If you select Modify, proceed to step 3.

    If you select Repair, Setup reinstalls all previously installed components. In the Maintenance Complete dialog, click Finish to complete the procedure.

    If you select Remove, Setup asks if you want to remove all selected applications. Click OK to remove the files. In the Maintenance Complete dialog, click Finish to complete the procedure.

  3. Click Next on the Welcome dialog.

  4. Select your geographical location on the Select Install Location dialog and click Next.

  5. Read the License Agreement carefully. If you agree to the terms and conditions, click Yes.

    If you cannot read the license agreement for your geographical location, refer to the instructions in the section “8.2 License Agreement does not display properly”.

  6. In the Customer Information dialog, enter the serial number from the Installation Key document included with this product and click Next.

  7. Select the check boxes for the components you want to install and clear the check boxes for installed components you want to remove, then click Next.



    Note:

    If you do not want to remove previously installed components, leave the boxes for these components checked. The install process will not install them again.


    Setup performs the operations you requested.

  8. Click Finish on the Maintenance Complete dialog.


4.2 Directory structure for the CAI

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


4.3 Directory structure for the BAI

After installing the BAI for Media you should see the following directory structure:


When any IWS documentation mentions <IWS install path>, it either refers to the default install path, C:\Program Files\Sybase\Industry Warehouse Studio 4.1 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.1 includes a number of major new and revised features.

5.1 Model changes and synchronization among products

The models for all IWS 4.1 products, applications, and industries are based on the same version of the IWS base model. This means that any 4.1 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 Industry Warehouse Studio, and the Model Descriptions document for your model.

5.2 Sample data for Adaptive Server IQ

Industry Warehouse Studio 4.1 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, except for Media BAI. 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 version 4.1 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 in your CAI application template guide, or in the Industry Warehouse Studio for Media Applications Installation and Configuration Guide.

IWS sample database and Adaptive Server IQ

Adaptive Server IQ 12.4.3 is required to use the IWS 4.1 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.3 Warehouse Control Center 4.1

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

5.4 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 Warehouse Studio is now a required companion product to Industry Warehouse Studio.

5.5 Analytics applications visualized for Business Objects

Version 4.1 of the Industry Warehouse Studio product family includes the add-on Analytics applications Media Advertising Analytics and Media Circulation Analytics visualized for Business Objects client/server and WebIntelligence environments.

See the Release Bulletin Industry Warehouse Studio for Media Applications for more information about these add-on applications.

5.6 Support for view column business names and descriptions

In this release of IWS for Media, PowerDesigner extended attributes provide support for view column business names and descriptions. Two new attributes, IWS Business Name and IWS Description, are now visible on the properties sheet for all view columns. This new information is available as metadata to the Warehouse Control Center, and is therefore available for export to front-end tools.

Any new views added to the IWS model automatically inherit these new attributes. However, if you want to add these attributes to a new model or an older version of the IWS, follow this procedure.

To create PowerDesigner extended attributes:

  1. With the model open in PowerDesigner, open the Extended Model Definitions folder in the object hierarchy tree view.

    The Extended Model Definitions folder is the last folder at the main model level.

  2. Create a new extended attributes object or double-click the Imported Attributes object (if it exists) to open the Extended Model Definition Properties dialog.

  3. Right-click the Profile folder in the tree view on the left of the properties dialog. A menu appears.

  4. Select Add Metaclasses on the menu. The Metaclass Selection dialog appears.

  5. Check the box next to ViewColumn on the list in the Metaclass Selection dialog.

    ViewColumn appears in the tree view on the left of the Imported Attributes property sheet.

  6. Right-click the ViewColumn object in the tree view on the left of the properties dialog. A menu appears.

  7. Select NewExtended Attribute from the menu.

  8. In the panel on the right side of the properties sheet, for each new attribute enter Name and Comment, then select Data Type. For the IWS Business Name attribute and the IWS Description attribute, enter or select the values in the following table.

    Name

    Data Type

    IWS Business Name

    (String)

    IWS Description

    (Text)

  9. Click Apply.

  10. Click OK to close the Extended Model Definition Properties dialog.


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 a version older than 4.0.2 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.1 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. If you have questions, contact your Sybase representative to be sure that you have the correct and latest data model for your application.

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.5.2 Repository to display changes in the Version 4.1 submodels.

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

Refer to the PowerDesigner online documentation for more information.

To view model changes in PowerDesigner 9.5.2:

  1. Click File Open to open the Version 4.1 PDM file in PowerDesigner 9.5.2. This file is CRM.pdm for the CAI, or Media.pdm for the Media BAI.

  2. Click FileOpen to open an old WAM or PDM file in PD9.

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

  3. If using a WAM file, click FileSave As to save the WAM file as a PDM file.

  4. Click RepositoryConnect 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.1 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.5.2. 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:

If using a WAM file, 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.1 is compatible with the components included in Warehouse Studio 4.1. For more information on Warehouse Studio, refer to the Release Bulletin Warehouse Studio for version 4.1

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

8. Known problems

This section describes known problems in the CAI and Media BAI for this release. See the Release Bulletin Industry Warehouse Studio for Media Applications for more information.

8.1 Error when consolidating models to the repository

If you have made a change to the IWS model and you want to consolidate the change as an update to the prior version in the PowerDesigner repository, you may receive the following error:

“Unexpected error while executing the following action:
Changing value of attribute Create Date of object Shortcut of Column <Column Name>
The consolidation of the document has been canceled.”

Workaround

There is currently no workaround for this error, except to consolidate the model as a new document to the repository, rather than as an update. PowerDesigner Engineering is tracking this problem as CR 317794.

8.2 License Agreement does not display properly

When running Setup.exe, if you choose the install location Korea, Japan, Peoples Republic of China, Taiwan, or Thailand, the License Agreement may not display properly.

Workaround

If you cannot read the license agreement for your location, go to the Sybase Software Licenses web site and follow the instructions to select your geographical location. After you read the License Agreement, return to the installation procedure and click Yes, if you agree to the terms and conditions.

8.3 SQL inserts

There are records in both the D_CORE_RPT_STRC.csv and D_PRODUCT.csv 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.

The ampersand character within data values causes no problem for Adaptive Server IQ, but may be an issue if the .csv files are used to load data into another RDBMS.

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 StartProgramsSybaseIndustry Warehouse Studio 4.1, select the IWS component, then select the appropriate document name.

9.1 Industry Warehouse Studio CAI documentation

The table below lists documentation for the Industry Warehouse Studio CAI. For add-on application documentation, see the Release Bulletin for your application.

Title

Description

Filename

Name in menu

Introduction to Industry Warehouse Studio

Data warehousing and data model concepts, instructions for changing IWS models and loading data, and steps for implementing a demonstration warehouse. Intended for users, system integrators, project managers, and system administrators.

iwsintro.pdf

Also provided in print

Introduction to IWS

Industry Warehouse Studio System Integrator's Guide

Methodology for planning and implementing an IWS data warehouse. Intended for system integrators and system administrators.

sysintguide.pdf

System Integrator's Guide

Methodology project plan

Microsoft Project file for implementing IWS, used with the System Integrator's Guide. Intended for system integrators and system administrators.

METHOD.MPP

Methodology Project Plan

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. Intended for application developers and system integrators.

ModelDescCAI.pdf

Customer Analytics Infrastructure Model Descriptions

Industry Warehouse Studio Customer Analytics Infrastructure

Application guide to Customer Analytics SQL templates. Intended for users and system integrators.

cai_apps.pdf

Industry Warehouse Studio Customer Analytics Infrastructure

<CAI_application> Impact Analysis

Spreadsheet for determining impact of model changes on SQL. Intended for 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

Campaign Impact Analysis

Customer Care Impact Analysis

Customer Profile Impact Analysis

Customer Loyalty Impact Analysis

Sales Impact Analysis

Note that the Industry Warehouse Studio System Integrator's Guide is version 4.0.2.

All documents are installed in the \Documentation folder within the installation directory for Industry Warehouse Studio CAI. 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 Industry Warehouse Studio Media BAI documentation

The table below lists documentation for Media BAI. For add-on application documentation, see the Release Bulletin for your application.

Title

Description

Filename

Name in menu

Introduction to Industry Warehouse Studio

Data warehousing and data model concepts, instructions for changing IWS models and loading data, and steps for implementing a demonstration warehouse. Intended for users, system integrators, project managers, and system administrators.

iwsintro.pdf

Also provided in print

Introduction to IWS

Industry Warehouse Studio System Integrator's Guide

Methodology for planning and implementing an IWS data warehouse. Intended for system integrators and system administrators.

sysintguide.pdf

System Integrator's Guide

Methodology project plan

Microsoft Project file for implementing IWS, used with the System Integrator's Guide. Intended for system integrators and system administrators.

METHOD.MPP

Methodology Project Plan

Industry Warehouse Studio Business Analytics Infrastructure for Media Model Descriptions

Descriptions of the tables and columns in the Media model. Intended for application developers and system integrators.

ModelDescMedia.pdf

Media Model Descriptions

Note that the Industry Warehouse Studio System Integrator's Guide is version 4.0.2.

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

9.3 Warehouse Studio documentation

You receive Warehouse Studio documentation when you purchase Warehouse Studio, a required 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:

For more information on Warehouse Studio documentation, refer to the Release Bulletin Warehouse Studio.

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 ViewZoom To and enter 250 (or higher) in the Magnification box. You do not need to zoom the document in order to print visible PDM 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 ViewGo To Page. You can also use Tools Find and enter the text you are looking for.

10.2 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 an IWS 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.3 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 StartProgramsSybaseIndustry Warehouse Studio 4.1, selecting the IWS component and product, if necessary, then selecting IWS Update Utility.

10.4 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.5 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.6 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. Technical support

Each Sybase installation that has purchased a support contract for Warehouse Studio has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem with Warehouse Studio components using the documentation, please have the designated person contact Sybase Technical Support:

Customers in North America, call 1-800-8SYBASE. Customers outside North America, please call your local Sybase office.

You may find additional help from the Sybase online support Web site MySybase. MySybase is a free service that allows you to search through closed support cases, latest software bulletins, and resolved and known problems, using a view customized for your needs. You can even open a Technical Support case online.

MySybase can be used from most Internet browsers. Go to the Sybase support home page and click the MySybase tab for information on how to sign up for and use this free service.



Customer Support Note

When you contact Technical Support you may be asked to provide the model version number. To find this number, open the PDM file in PowerDesigner. Next, go to ModelModel Properties. Click on the General tab and copy down the number in the box labeled Version.


12. Other sources of information

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

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


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