Switch to standard view 
  Sybase logo
 
 
 



DOC ID: DC76941-01-0410-01
 

Topic

1. Accessing current release bulletin information

2. Product summary

3. What's in the box?

4. Installation instructions

6. Known issues

7. BusinessObjects limitations

8. Documentation

9. Documentation updates and clarifications

10. Technical support

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) for Media Applications Version 4.1. The IWS for Media applications provide a set of customizable reports designed to support the business needs of Media industry decision makers in understanding their customers, advertisers, and prospects.

This release of Industry Warehouse Studio for Media includes the Advertising Analytics and the Circulation Analytics applications. Advertising Analytics provides a series of reports that you can use to analyze advertising effectiveness. Circulation Analytics provides a series of reports that you can use to analyze customer service and circulation effectiveness, the success of campaigns and special offers, and trends in home delivery and single copy sales.

This version of IWS for Media is integrated with BusinessObjects®. You can run the Advertising Analytics and Circulation Analytics reports in both a BusinessObjects client/server environment and a BusinessObjects WebIntelligence? web client/server environment.

IWS for Media relies on the Sybase Industry Warehouse Studio infrastructure, including the data model, and the Warehouse Studio executable tools. The Industry Warehouse Studio product family gives you full access to the underlying data models, sample data, and tools, so that you can customize the applications and models to meet the needs of your customers.


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


This release bulletin:

3. What's in the box?

Industry Warehouse Studio for Media includes application, data model, sample data, and executable components.

The Advertising Analytics and the Circulation Analytics applications are packaged separately and each has its own installation CD. Your site may have purchased one or both Media applications.

3.1 IWS for Media components

The Industry Warehouse Studio for Media CD includes files you need to install and run the application as a BusinessObjects client and in your web browser, including:

An Installation Key (serial number) is required to install each IWS for Media application. This confidential key is on a paper document enclosed in the package. Be sure to keep installation keys and product CDs in a safe place.

3.2 IWS executable components

To view the data model for the IWS for Media application, customize the model or application, access the data, or change the warehouse design, you also need the tools supplied on the Warehouse Studio CDs.

Warehouse Studio is a separate, but required, companion product to Industry Warehouse Studio. For more information on Warehouse Studio components, see Release Bulletin Warehouse Studio for Version 4.1.

Use this product...

To do this...

PowerDesigner®

Work with your IWS data model

Warehouse Control Center®

Manage warehouse metadata

Adaptive Server® Anywhere

Create and manage repositories for PowerDesigner and Warehouse Control Center

Sybase Central? Java Edition

Administer Sybase databases

ODBC client-side drivers

Access Sybase databases

jConnect?

Access Sybase databases with JDBC connectivity

4. Installation instructions

This package contains reports, universes, and other related components required to run Industry Warehouse Studio for Media Advertising Analytics or Circulation Analytics in a BusinessObjects client/server environment and in a Business Objects WebIntelligence web client/server environment. You install all of the IWS for Media application, model, and data components from the Industry Warehouse Studio for Media CDs.

You install Warehouse Studio tools from the Warehouse Studio CD and PowerDesigner 9 from the PowerDesigner CDs. See the Release Bulletin Warehouse Studio for information on installing the Warehouse Studio components.

4.1 Prerequisites

Before you install and use IWS for Media, you need to install the following components. The tables below list the software and base-line requirements that must be installed to run this release. These components may all be on the same physical machine or on separate machines.



Note

Industry Warehouse Studio 4.1 applications have been certified on Windows 2000.

The Industry Warehouse Studio 4.1 applications have been certified with BusinessObjects 5.1.6 and WebIntelligence 2.7.2. Sybase suggests contacting Business Objects for the latest maintenance version of these products.


BusinessObjects client/server environment

The following table identifies the components you need to run IWS for Media in a BusinessObjects client/server environment. An asterisk appears next to items you create after you install IWS for Media.

Client-based components

Server-based components


  • BusinessObjects 5.1.6


  • BusinessObjects Designer


  • BusinessObjects Supervisor


  • Access to a BusinessObjects repository*


  • Access to the IWS for Media sample database*


  • ODBC DSN for IWS for Media sample database*


  • BusinessObjects 5.1.6


  • BusinessObjects Designer and Supervisor installed on a Windows 2000 server


  • BusinessObjects repository*


  • Access to the IWS for Media sample database*


  • Microsoft Internet Information Services (IIS) 5.0

Business Objects WebIntelligence environment

The following table identifies the components you need to run IWS for Media in Business Objects WebIntelligence.

Web client components

Web server components


  • Microsoft Internet Explorer 6.0


  • Windows 2000


  • WebIntelligence 2.7.2


  • Microsoft Internet Information Services (IIS) 5.0


  • Windows 2000

Database components

The following table identifies the database components you need to run IWS for Media either as a BusinessObjects client or from a web browser. An asterisk appears next to items you create after you install IWS for Media.

Database client components

Database server components


  • Adaptive Server IQ Client Components, including Interactive SQL


  • Adaptive Server IQ 12.4.3 EBF 8


  • IWS for Media sample database*


  • IWS for Media sample database user*


  • ODBC System DSN for IWS for Media sample database*



Note

Although Industry Warehouse Studio models use 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 chapter ?Creating an IWS Sample Database? in either Industry Warehouse Studio for Media Advertising Analytics Installation and Configuration BusinessObjects Integration or Industry Warehouse Studio for Media Circulation Analytics Installation and Configuration BusinessObjects Integration.


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.

Sybase PowerDesigner 9.5.2 is also necessary for generating DDL for the Adaptive Server IQ sample database and for viewing the IWS for Media data submodels.



Microsoft Internet software versions

IWS for Media is certified with Microsoft Internet Explorer 6.0, although you may find that the web client also works with other versions of IE. IWS for Media is certified with Microsoft IIS 5.0.




IWS for Media sample database

Adaptive Server IQ 12.4.3 with EBF 8 is required to use the IWS for Media 4.1 sample database as delivered by Sybase. You can use the sample data load files provided with IWS for Media on all supported Adaptive Server IQ 12.4.3 platforms. Updates to Adaptive Server IQ, including EBF 8, are available for download on the Sybase web site. When upgrading Adaptive Server IQ 12.4.3 to EBF 8, be sure to upgrade both Client and Server.


4.2 Installing your business intelligence tool

This release bulletin does not tell you how to install the BusinessObjects business intelligence tool. Refer to the Business Objects manuals for more information.

4.3 Installing Industry Warehouse Studio for Media

This section describes how to install Industry Warehouse Studio for Media.

You begin by installing IWS for Media onto the Windows 2000 machine where your Business Objects WebIntelligence server resides. This is the machine that will host the IWS for Media reports. After installing IWS for Media on your WebIntelligence server, install the client. Business Objects does not recommend installing Enterprise Server Products on the same machine as its desktop products.



Close all web servers!

Make sure all of your web servers (for example, WebIntelligence for Business Objects) are stopped while you are installing IWS for Media. Otherwise your installation may not complete correctly.




Windows 2000 installation permissions

You should have ?Administrators? permissions to install this version of IWS for Media on Windows 2000.


First BDA component installation

IWS for Media is a component of IWS Business Decision Analytics (BDA). The installation procedure for the first Media product installed on a system is simple using the Setup wizard, as described in the following procedure. If a BDA component is already installed on your system, follow the procedure in the section ?Additional BDA component installation? to install another Media component.

To install Industry Warehouse Studio for Media:


  1. Insert the Industry Warehouse Studio for Media installation CD in the CD drive.

    If Autorun is enabled on your system, Setup begins to install Industry Warehouse Studio for Media. 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 ?6.1.1 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\IWS4.1. Click Next.

    Although the setup wizard installs Industry Warehouse Studio for Media components in C:\Program Files\Sybase\IWS4.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.



You install reports, models, and data into the installation directory.

Throughout this documentation ?your installation directory? refers to the directory you select in the setup wizard.


Additional BDA component installation

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

To update the current Industry Warehouse Studio for Media installation:


  1. Insert the Industry Warehouse Studio for Media installation CD in the CD drive.

    If Autorun is enabled on your system, Setup begins to install Industry Warehouse Studio for Media. 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 ?6.1.1 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 BDA 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 in the Maintenance Complete dialog.


4.4 The installation directory structure

The Industry Warehouse Studio for Media installation process creates either the \Advertising and \Classified Advertising directories or the \Circulation directory under the \Sybase\IWS4.1\BDA\Media\Apps directory, depending on whether you install Advertising Analytics or Circulation Analytics.

When you install Advertising Analytics, Industry Warehouse Studio for Media creates a directory structure similar to the structure shown below.

When you install Circulation Analytics, Industry Warehouse Studio for Media creates a directory structure similar to the structure shown below.

Within your installation directory, there are five major subdirectories:



Note

IWS for Media Advertising Analytics and Circulation Analytics 4.1 both use the same Adaptive Server IQ sample database. You only need to create the sample database once.




Note

The case of characters in folder and directory names may display differently on different operating systems. For example, the folder IQ may display as Iq and BO may display as Bo.


4.5 Setting up your environment

After installing, see the Industry Warehouse Studio for Media Applications Installation and Configuration Guide Business Objects Integration for configuration instructions. Be sure to follow the steps there before you try to modify or run the IWS for Media applications.

4.6 Installing Warehouse Studio tools

The Warehouse Studio tools on the Warehouse Studio CD can be installed from a single menu. For installation instructions and a list of Warehouse Studio components documents, see the Release Bulletin Warehouse Studio.

4.7 Viewing model differences

The IWS for Media 4.1 release relies on the data model that is installed in the \Media\Model folder in your installation directory. 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 Media Version 4.1 PDM file (Media.pdm) in PowerDesigner 9.5.2.


  2. Click File ? Open 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 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.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.


5. New features and enhancements

This section describes new features and enhancements in this version of IWS for Media.

5.1 Classified Advertising Analytics

IWS for Media Advertising Analytics now includes the Classified Advertising category. Classified Advertising examines the volume and net revenue generated by classified advertisements, using key elements such as classified ad category, product, day of week, salesperson, and sales team. You can quickly see the numbers of renewed, canceled, and make good ads, as well as the number of lines of classified ads, for a product, day of week, or classified ad category. You can also view classified advertising net revenue by ad category, day, and salesperson.

For more information on the Classified Advertising reports, see the Industry Warehouse Studio for Media Advertising Analytics User?s Guide.

5.2 New and enhanced sample reports

In addition to the new Classified Advertising category, this version of Media includes new sample reports for both Advertising and Circulation Analytics. The new reports and descriptions are listed in the following table.

Category

New report name

Description

Advertising

Advertiser Cross Sell Report

Shows the products in which advertisers have advertised and the number of times they have advertised in a particular product

Home Delivery

Home Delivery Holiday Circulation

Shows the circulation on holidays during the year

Offer Analysis and Retention

Retention and Subscriber Value

Displays the retention rate and subscriber value by postal code in four week increments

Single Copy Sales

Single Copy Delivery Cost and Returns

Shows the cost to deliver a single copy of a product to a district and the number of copies returned

Many of the sample Media reports from previous releases have additional drills and report tabs in this new version.

For more information on the new and enhanced Media sample reports, see the Industry Warehouse Studio for Media Advertising Analytics User?s Guide or the Industry Warehouse Studio for Media Circulation Analytics User?s Guide.

5.3 Media default installation path shortened

The default installation pathname for the Media applications has been shortened to C:\Program Files\Sybase\IWS4.1\BDA. This path was formerly C:\Program Files\Sybase\Industry Warehouse Studio 4.1\Business Decision Analytics Business Objects.

5.4 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 New ? Extended 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. Known issues

The following issues exist for this release. Workarounds are included when available.

6.1 Installation issues

You may encounter the following issues when running the Setup.exe installation program.

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

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.

6.1.2 Removing shared Media BDA components

If you have both the Advertising Analytics and Circulation Analytics Media applications installed on your system, you cannot use the installation program Setup.exe to remove the Data, Model, Documentation, or Win32 component of just one of the applications. Clearing the check boxes of these components under one application in Modify mode has no effect, as the folders are shared by both Advertising and Circulation. To remove a shared component, you must clear the check box of the component under both Media Advertising and Media Circulation.

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

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.

7. BusinessObjects limitations

The following issues with the IWS for Media reports are due to limitations of Business Objects WebIntelligence or the BusinessObjects client. Workarounds are included when available.

7.1 WebIntelligence reports

The following issues are due to limitations of Business Objects WebIntelligence.

7.1.1 Y-axis values duplicate after drill

The values on the Y-axis of a graphical report duplicate after a drill, when you refine your drill filters with very limited results. There is no workaround for this problem, which has been submitted to Business Objects.

7.1.2 Drilling sort order

In WebIntelligence, sorting can only be performed in ascending or descending order. There is no custom sort option. For example, the Day Full Name drill down is alphabetical by the name of the day of the week, rather than by the chronological order of the days. Also, the Month Full Name and Month Abbreviation drill downs are alphabetical by month name, rather than by month number.

7.1.3 Missing column headers

The crosstab report Complaints by District does not have column headers on all of the columns. WebIntelligence has no option to add headers to columns in a crosstab.

7.1.4 Sum and total sum rows have same label

At the end of some reports, including Complaints by District, Complaint Comparisons over Time, Start Comparisons over Time, Stop Comparisons over Time, and Advertiser Category Analysis, the sum and total sum rows are both labeled ?Sum.? WebIntelligence has no option to modify these row labels.

7.1.5 Horizontal alignment of drill options

On a web browser, the list of drill downs is aligned horizontally, which sometimes requires scrolling back and forth to see all of the drill options. This is the WebIntelligence default display of drilling options.

7.1.6 Salesperson sort order

In the Advertising Analytics reports, the Salesperson drill down is alphabetical by first name, rather than by surname. The names are stored in the sample database as first name followed by surname, so WebIntelligence sorts by first name. If you store your own data with the surname first, then WebIntelligence sorts the names alphabetically by last name.

7.1.7 Drilling restrictions on some reports

Some of the IWS for Media reports have no drilling options when run from a web browser. The BusinessObjects client versions of these reports contain subqueries, which WebIntelligence does not support. You can drill into most of these reports by running the report from the BusinessObjects client.

The Advertising Subscriber Value, Campaign Cost and Benefit, and Campaign Variances reports have no drilling options, even when run from the BusinessObjects client.

Several Media reports also have a restriction on running BusinessObjects client Drill Through.

See the following for drilling restrictions in the IWS for Media reports.

Report name

BusinessObjects client Drill By?

BusinessObjects client Drill Through?

WebIntelligence drills?

Advertiser Cross Sell Analysis

yes

yes

no

Advertiser Cross Sell Opportunities

yes

yes

no

Advertiser Cross Sell Report

yes

yes

no

Advertising Category Analysis

yes

yes

no

Advertising Subscriber Value

no

no

no

Campaign Cost and Benefit

no

no

no

Circulation Campaign Effectiveness

yes

yes

no

Campaign Variances

no

no

no

Complaint Comparisons over Time

yes

yes

no

Complaints by Operator

yes

no

no

Complaints per 1000 Variance Analysis

yes

no

no

Complaints vs Attrition Rates

yes

no

no

Home Delivery Averages

yes

yes

no

Home Delivery Circulation Trends

yes

yes

no

Home Delivery Holiday Circulation

yes

yes

no

Home Delivery Individual Cost by District

yes

yes

no

New Starts

yes

no

no

New Starts to Plan

yes

yes

no

Retention and Subscriber Value

yes

no

no

Retention by Demographics

yes

no

no

Retention by Offer

yes

no

no

Retention by Sales Source

yes

no

no

Single Copy Delivery Cost and Returns

yes

yes

no

Single Copy Penetration Ratio

yes

yes

no

Single Copy Returns

yes

yes

no

Single Copy Returns by District

yes

yes

no

Start Comparisons over Time

yes

yes

no

Stop Comparisons over Time

yes

yes

no

Top 100 Advertiser Analysis

yes

yes

no

For complete details on drilling options for the IWS for Media reports, see the Industry Warehouse Studio for Media Advertising Analytics User's Guide BusinessObjects Integration or the Industry Warehouse Studio for Media Circulation Analytics User's Guide BusinessObjects Integration.

7.1.8 ?No data to fetch.? message from WebIntelligence

WebIntelligence returns the message ?No data to fetch. (WI0500)? if you select Run Query to the database and there is no data that matches the drill values you have specified. This is normal behavior.

7.1.9 ?This page is empty.? message from WebIntelligence

WebIntelligence returns the message ?This page is empty. (WI0100)? if you select Run Query and there is a problem connecting to the database. This is normal behavior.

Check that your database server is running and restart the server, if necessary.

7.1.10 Drilling to a low level

If you drill a graphical display report to the point where most of the data has been filtered out, the resulting graph may look unusual.

7.1.11 Axis labels overlap the chart

When drilling a report in WebIntelligence, the axis labels sometime overlap the chart when the report redisplays. This is a BusinessObjects limitation, as the current version of WebIntelligence does not allow the repositioning of axis labels.

7.2 BusinessObjects client reports

The following issues are due to limitations of the client version of BusinessObjects.

7.2.1 No Drill Through for some reports

Do not use the Drill Through method of drilling with the following reports, as BusinessObjects will return an error: Complaints by Operator, Complaints per 1000 Variance Analysis, Complaints vs Attrition Rates, New Starts, Retention by Offer, Retention by Sales Source, Retention and Subscriber Value, and Retention by Demographics.

7.2.2 Axis labels do not change after drill

The axis labels for all reports containing bar charts (two dimensional and three dimensional) do not change when you drill on the chart. BusinessObjects cannot link the label to the chart. An enhancement request has been submitted to Business Objects for consideration in the next release.

7.2.3 Some columns too narrow after drill

After drilling, some columns are not wide enough to display the entire column header or the entire field of data. To work around this problem and widen the column, use your mouse to drag to the right the right column divider of the narrow column.

7.2.4 Border around drilled down table headers

After the drill function for a non-graphical report with table headers is turned off (by clicking the Drill magnifying glass button), the drilled down table headers redisplay surrounded by a border. This is normal BusinessObjects client report behavior.

7.2.5 No headers on ?Move to block? columns

Some columns created by selecting ?Move to block? in the drop-down drill box do not have headers. This is normal BusinessObjects behavior. To move the column back to a drop-down drill box, right click on the column and select Set as Drill Filter.

7.2.6 Additional drills available

If you right-click Drill By in some reports, you find that there are more dimensions available for drilling than are listed in the original drop-down menu drills. The drop-down items act as Drill Filters. The format of the report does not change when you use a drop-down drill; only the data returned changes. The right-click Drill By changes the format of the report based on where you click and which item you select; the data returned for the selected dimension is unfiltered.

7.2.7 Drilling to a low level

If you drill a graphical display report to the point where most of the data has been filtered out, the resulting graph may look unusual.

7.3 Universe export procedure issue

If the total length of the pathname of a universe (.unv) file is greater than 128 characters, then BusinessObjects Supervisor does not respond when you click the Parameters button in the Export Universe dialog or when you attempt to remove the universe from the universes list.

The workaround for this problem is to use BusinessObjects Designer to export the universe or to shorten the pathname to 128 characters or less.

8. Documentation

Documentation for Industry Warehouse Studio for Media is provided as PDF files. You need Acrobat Reader to view these documents. Acrobat Reader is a small program you can download for free from the Adobe Systems web site on the Internet.

All IWS for Media documentation except for this Release Bulletin is in the \Media\Documentation subdirectory of your \IWS4.1\BDA installation directory. You can open any PDF document in Acrobat Reader in either of two ways:

This document (Release Bulletin Industry Warehouse Studio for Media Applications) and the Industry Warehouse Studio for Media Applications Installation and Configuration Guide Business Objects Integration are included on the Getting Started Industry Warehouse Studio for Media CD.

See the following table for a complete list of IWS for Media manuals for this release, and the intended audience for each. Note that the application specific documents are installed only for that application (Advertising Analytics or Circulation Analytics).

Title

Description

Filename

Name in menu

Release Bulletin Industry Warehouse Studio for Media Applications

Installation instructions and summary of the IWS for Media applications. Intended for system administrators, system integrators, and users.

iwsmedrb.pdf

n/a

Industry Warehouse Studio for Media Applications Installation and Configuration Guide BusinessObjects Integration

Instructions for setting up the IWS for Media applications for BusinessObjects, steps for creating and loading the sample database, information on customization. Intended for system administrators and system integrators.

mediaicg.pdf

Industry Warehouse Studio Media Installation Guide

Industry Warehouse Studio Business Analytics Infrastructure for Media Model Descriptions

Descriptions of the packages, views, tables and columns in the IWS for Media data model. Intended for system administrators and system integrators.

ModelDesc Media.pdf

Media Model Descriptions

Industry Warehouse Studio for Media Advertising Analytics User's Guide BusinessObjects Integration

Introduction to IWS for Media Advertising Analytics, login instructions, report synopses, examples, business questions, and drilling information. Intended for system integrators and users.

medadvug.pdf

Media Advertising User's Guide

Industry Warehouse Studio for Media Circulation Analytics User's Guide BusinessObjects Integration

Introduction to IWS for Media Circulation Analytics, login instructions, report synopses, examples, business questions, and drilling information. Intended for system integrators and users.

medcirug.pdf

Media Circulation User's Guide

Media Advertising Impact Analysis

List of table and column names used in each report for understanding the impact of model or query changes. Intended for system administrators and system integrators.

MA_Impact_ Analysis.xls

Media Advertising Impact Analysis

Media Circulation Impact Analysis

List of table and column names used in each report for understanding the impact of model or query changes. Intended for system administrators and system integrators.

MC_Impact_ Analysis.xls

Media Circulation Impact Analysis

Some Industry Warehouse Studio documents are also included in the \Media\Documentation folder of your installation directory:

9. Documentation updates and clarifications

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

9.1 Adaptive Server IQ database options reset

The script that loads the sample data into the Adaptive Server IQ sample database (Load_Media_Tables.tst) sets the Adaptive Server IQ database option Query_Temp_Space_Limit to 0. This option setting is necessary for refreshing data when running the IWS for Media reports as a BusinessObjects client.

The load script also sets the Adaptive Server IQ database options Main_Cache_Memory_MB and Temp_Cache_Memory_MB to 32. These values are the minimum requirement for the IWS for Media sample database. More appropriate settings are:

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

For more information on setting these Adaptive Server IQ database options, refer to the version 12.4.3 Adaptive Server IQ Administration and Performance Guide and the Adaptive Server IQ Reference Manual.

9.2 Report examples in the documentation

The report examples in the documentation illustrate running the IWS for Media reports and show possible results. The data in the examples may not match the sample data exactly.

9.3 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. 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 Model ? Model Properties. Click on the General tab and copy down the number in the box labeled Version.


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.