cancel
Showing results for 
Search instead for 
Did you mean: 

Building Web Intelligence or Xcelcius for Information Steward

Former Member
0 Kudos

Dear Experts,

Has anyone built Web Intelligence reports or Xcelcius dashboards showing scorecard data from Information Steward?  The requirement is to get visibility to view the quality of the data without logging into Information Steward.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Nitin,

It might be possible to get the results from the IS repository, but I don't know that for sure. In IS4.1 it is also possible to expose the scorecard via a URL, maybe that suits your needs?

Regards,

Marc

Former Member
0 Kudos

Marc - thanks for the response.  I am really looking for insights in building WebI reports using IS data.  I am sure someone may have done this.

Former Member
0 Kudos
Former Member
0 Kudos

Michael,

Will this guide be the same for building reports for data insight? 

Answers (1)

Answers (1)

Former Member
0 Kudos

We tried to build the Webi report on IS repository with scorecards and failed data reporting as failed data view in IS 4.0 is pretty limited. But the challenge is with every execution of the scorecard task, the failed data table names gets auto generated. There is no constant table name in the failed data connection.

There are other ways to get the failed data for better Webi reporting (Ad-hoc) through staging and combining several failed data tables.

try exploring IS 4.1 on the failed data tables, not sure if they are standard tables.

NielsWeigel
Product and Topic Expert
Product and Topic Expert
0 Kudos

There is a more detailled description on how to use Webi to report on the failed recod database existing in the SCN:

How to Create Detailed Failed Data Reports as Part of your Data Quality Analysis

But keep in mind that this document is on the IS 4.0 version, while we have changed the data model for the failed record database in the current IS 4.1 version, extended the tables and information stored in the tables to make much more information available.

Also we have added a separate table IS_FD_TABLES_MAP that is mapping the table names generated for your Rule Task executions to generic name. So you can add a lookup in the mapping table to identify the generated name:

For example, to obtain all failed records for a task ran on the table Sales.CustomerAddress, you create queries for the following steps:


1. Find the table alias of Sales.CustomAddress.


2. Select the run_id of the rule task based on the START_TIME for the table alias.

3. Select the actual failed data from the <TABLE_ALIAS>_FD table for that run_id.

Niels