Skip to Content
Technical Articles
Author's profile photo VENKATESH GOLLA

Information Steward SP12-Updates for Data services

Information Steward SP12-Updates for Data services

Hi,

Today, In this blog post, we are going to discuss what are the new updates provided for information steward 4.2 version with latest service pack-12 and what is most useful for data services, the pros, and cons, issues with solutions.

before getting here, please read my previous blog which demonstrated the introduction to Infomation Steward here:

https://blogs.sap.com/2019/09/16/sap-information-steward-insights-and-scorecard/

Introduction:

Version: SAP Information Steward 4.2 with SP12 upgrade package(latest till date).

We can focus a few major things could be related to BODS and reporting purposes as well.

Let us start with the updates:

  • Excel issue: – I can surely say that it is the major issue faced by any developer ?

we are having several issues with excel sheets – like column count cannot be exceeded by 250(as per SP6 update) and excel formatting issue.

While generating a report, it is a big challenge to manage column count in 250 itself.

In this update, we have some relief from above aches. 🙂

  1. From this update, you can choose your wish format to xls/xlsx.
  2. Now from column count has been increased to huge(details below),

But things that we need mind before choosing default format are:

  • Excel XLS file format permits 65536 rows and 256 columns.
  • Excel XLXS file format permits 1048576 rows and 16384 columns.

Being a techie, my suggestion is to use XLSX format as it having all potential advantages for reporting and metadata as well(discussed below).

Data import/export:

As discussed above, Information Steward now supports Excel XLSX file format for exporting metadata relationship views to Microsoft Excel spreadsheets.

Additionally, select XLSX file format when you import user-defined relationships to Information Steward whereas previously Metadata Management supported only XLS for these tasks.

From this version, for importing or exporting metadata from excels you can use new format-XLSX.

 

The procedure is here:

You need to create a file connection in CMC by providing the file path.

Then login to IS, go to DataInsight and follow the below steps-

  1. Go to the File format, click New, select file format.
  2. Give file format name and description, upload the sample file, where the schema is exactly matching to your source file (flat file) or you can upload the flat file directly.
  3. Select the Delimiter whether your file is separated by tab or space or comma etc..
  4. Select first row contains field names, then propose schema.
  5. Save it and close it
  6. Go to Workspace home, add files by selecting the file connection and file format
  7. Then add files to Project.

The detailed information here:

Step1:

Go to data insight tab: select your project and create a workspace

And add files.

Step2:

Go to the File format, click New, select file format.

Step3:

Fill the file format as shown below and save:

Give file format name and description, upload the sample file, where the schema is exactly matching to your source file (flat file) or you can upload the flat file directly.

Now you can view the saved file format and once you click on it, you can view the file format as well.

Finally, once the file(Excel) format has been created:

Go to Workspace home, add files by selecting the file connection and file format

 

SAP ECC Support:

This is an interesting topic whereas it involves ECC support.

SAP has added 2 new integrator objects:

  • SAP Extractor
  • SAP Function Module

Along with objects 2 new parameters too:

  • collectDomains false
  • collectDataElements false

With these extractors as part of the data retrieval mechanisms in the SAP source system. An extractor can fill the extraction structure of a DataSource with the data from SAP source system datasets.

There are application-specific extractors, each of which is hard-coded for the DataSource that was delivered with BI Content, and which fill the extraction structure of this DataSource.

In addition, there are generic extractors with which you can extract more data from the SAP source system and transfer it into BI. Only when you call up the generic extractor by naming the DataSource does it know which data is to be extracted, and from which tables it should read it from and in which structure. This is how it fills different extraction structures and DataSources.

 

In the next blog posts, we can discuss more on processings.

That’s all about this blog post.

Happy Learning!!!

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Noor Shaikh
      Noor Shaikh

      Nice Blog. Quick Question: Is there a way to download more than 500 profile records in the SAP Information Steward ?

      Author's profile photo VENKATESH GOLLA
      VENKATESH GOLLA
      Blog Post Author

      Hi Noor,

      There are 2 waya to achieve it.

       

      1. Information Steward provides option to 'View More Failed Data' from failed data repository. If you have configured 'Failed Data Repository' to collect all failed records, you are able to access those from Information Steward UI and export those to Excel.

      you can identify a 'For data that failed rules' data connection in CMC > Information Steward > Connections and select that connection in your Rule task under Save all failed data to:. This can capture all failed data rows instead of just a sampling.

      2. Our solution was to export the business rules to Data Services and use them in a validation transform. All validation transforms are put in a data flow in a batch job where we use the same sourcedata as we use in Information Steward. This batch job runs daily, so the failed data is being refreshed on a daily basis. The failed records from the validation transforms are exported to an Excel-file on a network share from where the business users can open then and perform their required actions.

      Author's profile photo Noor Shaikh
      Noor Shaikh

      Hi Venkatesh,

      Thank you for taking time and providing response. Is the above could also be applicable to display profile data.

      For example. if I need to download more than 500 records from the profile tab, it does not providing the option to download the profile the results or configuring the profile task using the failed data to: option.

      The default option to download Profile results are not providing all the profile results .  Another example is <OTHERS> have huge profile values but there is no way I can download and analyze the values.

      Any thoughts ?

      Author's profile photo VENKATESH GOLLA
      VENKATESH GOLLA
      Blog Post Author

      No, this option I explained for only failed data.