TM1: Uploading .XLSM files in Cognos Express Xcelerator or TM1

In order to upload a macro enabled workbook in Xcelerator  or TM1 you must create your own .blob file and place it under the correct directory.

1. Firstly, copy your .XLSM file to the }Externals folder, which can be found under the default Cognos Express data directory:

C:Program Files (x86)IBMCognos ExpressXceleratorCustomTM1DataCXMD

2. Identify which Application folder you would like the file to be located e.g. Budgets or Cashflow in the below example:

Uploading XLSM 1


Those exact folders can be found in the }Applications folder in your Xcelerator data directory (same location as the }Externals folder).

3. Navigate to the appropriate folder and create a new .blob file using a text editor such as Notepad and add the following lines:

FILE_FORMAT=100
ENTRYNAME= name to appear in the Server Explorer (e.g. Budget Input)
ENTRYTYPE=blob
ENTRYREFERENCE=TM1:///blob/public/.}Externalsfilename.xlsm (e.g. Budget.xlsm)

 4. Save the .blob file using an appropriate name e.g. Budget Input.blob and restart the CXMD service.  Once restarted the .XLSM file can now be visible from the Server Explorer under the appropriate folder.

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content