DSXchange

Code: Select all

@ECHO OFF
REM Identify business terms in previously imported Cognos assets.
REM Authentication information is in local file "E:\Data\Authfile\ServiceBGAdmin.txt" (password is encrypted).
REM Configuration file is "E:\Scripts\Cognos\bi2bgconfig.ini" (supplied by IBM and edited).

:processing
REM Domain name uses DNS entry to mask real server name
set domainName=ATOBusinessGlossary
REM Pathname of istool command
set istoolCmd=E:\IBM\InformationServer\Clients\istools\cli\istool
REM Pathname of authentication file
set authFile="E:\Data\Authfile\ServiceBGAdmin.txt"
REM Pathname of bi2bg configuration file
set configFile="E:\Scripts\Cognos\bi2bg_config.ini"
REM Pathname of log file
set DateTag=%date:~-4,4%%date:~-7,2%%date:~0,2%
set logFile="E:\Scripts\Cognos\logs\bi2bg_%DateTag%.log"

echo.Started %date% %time% 
if exist "E:\Scripts\Cognos\bi2bg_preview.csv" DEL "E:\Scripts\Cognos\bi2bg_preview.csv" && echo."E:\Scripts\Cognos\bi2bg_preview.csv" deleted.
if exist "E:\Scripts\Cognos\bi2bg_duplicate_terms.csv" DEL "E:\Scripts\Cognos\bi2bg_duplicate_terms.csv" && echo."E:\Scripts\Cognos\bi2bg_duplicate_terms.csv" deleted.
echo.
echo.Command being executed:
REM Process business terms in imported Cognos assets.
REM To create a preview file only, use configuration file bi2bg_config_previewonly.ini; to actually populate the metadata
REM repository, use configuration file bi2bgconfig.ini.
echo %istoolCmd% glossary bi2bg -cfg %configFile% -domain %domainName% -authfile %authFile% -verbose -log %logFile%
%istoolCmd% glossary bi2bg -cfg %configFile% -domain %domainName% -authfile %authFile% -verbose -log %logFile% 
set result=%ERRORLEVEL%
echo.Finished %date% %time% - status = %result%

if %result%==0 echo Processing of Cognos terms complete.  Details in "istool_glossary_bi2bg_%DateTag%.out".
if %result%==0 goto finish
echo. Processing of Cognos terms failed. See "istool_glossary_bi2bg_%DateTag%.out" for details.

:finish

Code: Select all

# Specifies the names of the models to be processed.
ModelsToProcess = *

# String to be displayed in the Example attribute of the term in Business Glossary.
MemberTypeRegular = Dimension
MemberTypeMeasure = Fact

# If TRUE, BI collection members are assigned to the terms that are created from them.
ClassifyMemberTargetSource = TRUE

# List of categories to exclude.
CategoriesToExclude = test

# Specify the merge option to use when the categories and terms are imported.
# MERGE_SOURCE_BIAS merges the asset and overwrites existing attributes that cannot be merged.
# MERGE_TARGET_BIAS merges the asset and ignores imported attributes that cannot be merged.
MergeOption = MERGE_SOURCE_BIAS

# If TRUE, sets the IsModifier attribute of all imported items to "Yes".
IsModifier = FALSE

# Specify the Business Glossary status attribute of all imported terms.
Status = ACCEPTED

# Type specifies the Business Glossary type attribute of all imported terms.
Type = NONE

# Specify whether to create a Business Glossary preview in a CSV file or in the log file.
# If a preview is selected, nothing is written into the Business Glossary itself.
# If a preview is not selected the other three settings in this group are ignored.
CreateBusinessGlossaryPreview = FALSE
BusinessGlossaryPreviewFormat = CSV
BusinessGlossaryPreviewCSVFilePath = E:\\Scripts\\Cognos\\bi2bg_preview.csv
FirstRowColumnNames = TRUE

# Category under which to store terms migrated from Cognos assets by the bi2bg utility.
ImportToTopCategory = TRUE
TopCategoryName = Enterprise Reporting

# Handling of duplicate terms.
CheckForDuplicateTerms = TRUE
DuplicateTermsFileName = E:\\Scripts\\Cognos\\bi2bg_duplicate_terms.csv