Preparing manual input for importing business intelligence reports (IBM Knowledge Catalog)

Business intelligence reports are created in reporting and analysis tools. For some tools, you must provide an input file for the metadata import.

You can import technical metadata for business intelligence reports that are created and maintained in Microsoft SQL Server Analysis Services and Statistical Analysis System.

Before you can view business intelligence assets in the catalog, you must complete some prerequisite steps and make sure certain conditions are met:

1. Create an input file for imports from Microsoft SQL Server Analysis Services or Statistical Analysis System.

   Microsoft SQL Server Analysis Services (SSAS)

   Make sure all XMLA or BIM files extracted from SSAS are in the /input/ssas/${ssas.dictionary.id} folder, where ssas.dictionary.id is the identifier of the SSAS server.

   Create a .zip archive from the /input/ssas/${ssas.dictionary.id} folder.

   Statistical Analysis System (SAS)

   For versions before R40, make sure all SAS code files are in the /input/sas/${sas.system.id} folder, where sas.system.id is the identifier of the SAS project.

   For version R40 and later, also make sure all SAS metadata collection for predefined library table definitions are in /input/sas/${sas.system.id}/${sas.extractor.input}. This is required when datasets are predefined or defined in different scripts than where they are used.

   Create a .zip archive from the /input/sas/${sas.system.id} folder.

   Make sure to not include any folders or files other than the listed ones.

2. Upload the input .zip file to a project in IBM Knowledge Catalog for further processing. When you create the metadata import, this .zip file constitutes the data scope.

3. After you upload the .zip file to your project, create a metadata import and select this compressed input file as import scope. You can select one input file per import from your project. After you set the scope, you must also make the originating reporting tool known to IBM Knowledge Catalog. The metadata import service relies on this information for evaluation of the file format and structure after unpacking the .zip file. Metadata import then creates business intelligence assets in the selected catalog based on the content of the report input file.