Data Warehouse Story

Solution

Using High Availability for Web Services Hub, a client application can access the Web Service even in the event of failover of the Web Service to another node (when the URL changes). To achieve this, use either of the following:
Third party load balancer
Sample third party load balancers provided by Informatica (used only for test environment)

written by lynx286 \\ tags: High Availability, Web Services Hub

Problem Description
The following error is in session log:

Error XMLW_31213 : Row rejected due to duplicate primary key.

Data is written correctly to target, but above error will appear multiple times in session log and it will grow to very large size. Is there away to stop this message from being written to the session log?

written by lynx286 \\ tags: XMLW_31213

Description:

This document describes how to create a Time Dimension in Framework Manager which is similar to a Time Dimension created in Powerplay Transformer.

Steps:

1.Right-click on the Namespace and choose Create->Regular Dimension.
2.From Available Items drag the date column and drop it under Hierarchies.
3.Click the ellipsis in Source field to open Calculation Definition windows.
4.Change the name of the calculation to Year.
5.Use ‘cast’ and ‘extract’ functions to extract the years from the date column and convert it to character string, e.g.:
cast(extract ( year, [].[].[] ) , char(8))
6.Back in the Dimension Definition windows, click the ellipsis in the Role field.
7.Assign _businessKey and _memberCaption roles.
8.Under Hierarchies, Add Levels for Month and Day.
9.Repeat the steps 3-7 for the Month and Day using expressions:
cast(extract ( month, [].[].[] ) , char(8))
cast(extract ( day, [].[].[] ) , char(8))
Note:
‘cast’ function has to be used to convert a numeric field to a string as _memberCaption Role cannot be numeric.

written by lynx286 \\ tags: dimension, Framework Manager

Description:
How to generate multiple worksheets in excel from a report studio page

Environment:
Windows [All]

Solution:
Use grouping on a query item in the page break to generate separate excel worksheets

Steps:
1. Create a list report
2. Group on a query item in the list report
3. Open the page explorer and click on pages
4. Add a page break using the grouped query item
5. Run the report to generate an XLS output

written by lynx286 \\ tags: Excel, Grouping, Multiple Worksheets, Page Break

Description:
How to publish a package after modifying the model without impacting existing reports based on that package.

Solution:

This is essentially a question about how model versioning works.
If you want all your old reports to still work fine after changing a model, you need to enable model versioning when you publish the package in Framework Manager. With this option checked, ReportNet (or Cognos will create a new version of the model for this package in the content store, instead of overwriting the existing model.
Once done, the published package will have multiple versions of the model in the content store. All old reports will automatically link to the old model, and all new reports will be created against the new model.
Please be aware, however, that if you open an existing report from within the Studios, it will run against the newest model. There may be a validation prompt, and it may result in error messages becasue the old report may not match the metedata of the newest model.

Steps:
1. Check Enable model versioning in Framework Manager in the package publishing wizard.
2. Publish the package.

written by lynx286 \\ tags: model version control, modeling versioning