Changing/Updating Element Weight or Element Type for a Dimension in Cognos TM1:

Follow the below steps to update/change the element weight or element type for a dimension in Cognos TM1.

Steps:

1. Expand dimension and select the specified dimension name. For Ex: Say “account1”.
2. Right-Click on “account1” and also click on “Edit Dimension Structure”, so that Dimension Editor will be opened for the dimension “division” as shown in the Image A.
3. Select the element in the “division” dimension for which you want to change the element weight.
4. Right-Click on the element and also click on “Element Properties”, so that Dimension Element Properties window will be opened as shown in the Image B.
5. Select the element once again and change the Element Weight or Element Type to your requirements as shown in the Image C.

Note: If you change the Element Weight to ‘0’, the data in the element will not be consolidated to its parent element.

In the above case “Sales” element data will not be consolidated to “Gross Margin” element which is a parent of Sales element (please see the Image B).

TM1 Programming Concepts

There are a number of issues that every TM1 programmer encounters when using the TM1 API.
This post describes some of those issues. The following topics are discussed:

• System Functions - Every TM1 program must use the TM1 system functions to communicate with the TM1 server, and manage its connection during program execution. This section describes those functions.
• Simple TM1 Data Types - Description of the types of values supported by the TM1 API.
• Values - Most TM1 functions use values to store and manage information. This section describes the types of values used by the TM1 API, and how those values are manipulated.
• Security - The security of your data is of paramount importance. This section introduces two TM1 objects dedicated solely to security: Clients and Groups.
• Backup and Recovery - The TM1 server offers functions that allow full recovery of all cubes in the event the TM1 server is not properly brought down. This section describes the functions that allow you to recover your data in the event of a crash.

This chapter also includes:

• Creating a TM1 Project in C or C++
• Creating a TM1 Project in Visual Basic

System Functions:

The system functions control the connections between the TM1 client application and the API, and between the TM1 API and the servers. This section describes those functions.

Connecting to the API:

The following sections describe the function call sequence for:

• Connecting to the TM1 API in C
• Connecting to the TM1 API in Visual Basic

TM1 Programming Environment

This manual describes all the functions and features of the TM1 API. It assumes you are familiar with the basic concepts of TM1.

The API is intended to give access to many of the features and functionality of the TM1 OLAP engine. The API is designed for use with Microsoft C, C++ and Microsoft Visual Basic. All the C functions are supported by Visual Basic. However, some of the string and array value handling functions have a special version for Visual Basic. You should use these functions if you are programming in Visual Basic.

For C and C++ applications, include the header file TM1API.H. For Visual Basic applications, include the file TM1API.BAS.

The API has been optimized for use in a networked environment. As a result, the conventions used vary markedly from those used in other Application Programming Interfaces you may be familiar with. For example, all values are passed as pointers or handles to value capsules that contain the actual data. Location of the TM1 API DLLs:

There are three dynamic link libraries that must be loaded before you can use the TM1 API:

• TM1LIB.dll
• TM1SIP.dll
• TM1API.dll

These libraries must be loaded in the order that they are shown here. It is the programmer's responsibility to assure they are loaded in the correct order. There are three ways to do this:

• If the TM1API application resides in the same directory as the three DLLs, the libraries will be correctly loaded at run time.
• If the PATH environment variable includes the /bin directory, the libraries will be correctly loaded.
• You can explicitly load these libraries from within your application. For example, in Visual Basic you can call the Windows system function LoadLibrary() to each of the DLLs. The LoadLibrary() function will have to be called three times: once for each library.

Setting a Path to the DLLs:

The following procedure assumes that you accepted the default settings during the installation, and that the TM1 API .dll files are in C:\Cognos\TM1\bin. Follow these steps to tell the compiler where to find the TM1 API .dll files.

Steps:

1. From the Task Bar choose Start, Settings, Control Panel.
2. Double-click the System icon.
3. Click on the Advanced tab in the System Properties window.
4. Click Environment Variables.
5. Click PATH in the User Variables list.
6. In the Value field, add the full name of the directory in which the TM1 API .dll files are located. The delimiter between paths is the semi-colon (;).
7. Click OK.

Note: The above procedure is accurate for Windows NT 4.0. Procedures for other Windows operating systems may vary slightly.

Supported Compilers:

The TM1 API supports the following compilers:

• Microsoft Visual C++ Release 4.0 and higher
• Microsoft Visual Basic Release 4.0 and higher

Servers:

TM1 servers control access to system and user databases. In TM1, a server is a logical object having no parent of its own. The server has children that include, but are not limited to, cubes and dimensions, blobs (Binary Large Objects), clients (users), connections, and processes.

Servers use control cubes to keep track of databases, clients (users), groups, connections and other information.

A TM1 network is comprised of multiple local and remote servers.

Local Servers:

A local server runs on a users workstation. The local servers Admin Host machine is the user's workstation. If no Admin Server is running on the local machine, the local server starts one on the user's workstation. To start a local server, execute TM1S.EXE without configuration information or call TM1SystemServerStart.
Other users cannot access the local server by connecting to the admin host on that workstation.

Remote Servers:

A remote server controls access to public data objects. It can run on any workstation, including a users own workstation.

For a user to access the public data objects on a server, the user must be logged in to that server and must have at least READ rights. There are as many potential connections to a public server as there are server ports.
Steps:

1. Set up a configuration file specifying information for a specific server.
2. Create a shortcut to TM1S.EXE and add a -Z switch specifying the location of the server configuration file, TM1S.CFG. A server can be started by anyone.

Introduction to Cognos TM1 API

Introduction:

This post describes the functions and features of the IBM Cognos TM1 Application Programming Interface. The API is intended to give complete access to all the features and functionality of the TM1 OLAP engine. The API is to be used with C, C++, and Microsoft Visual Basic.

The API has been optimized for use in a networked environment. As a result, the conventions used vary markedly from those used in previous versions of the TM1 API.

Business Performance Management is the continuous management and monitoring of Financial, Operational, Customer and Organizational performance across the enterprise. Business Performance Management solutions have the following capabilities to facilitate the proactive steering of business direction:

• Wide deployment
• Collaborative decision making
• Continuous and real-time review and refinement
• Monitoring of Key Performance Indicators

IBM Cognos TM1 integrates business planning, performance measurement and operational data to enable companies to optimize business effectiveness and customer interaction regardless of geography or structure. TM1 provides immediate visibility into data, accountability within a collaborative process and a consistent view of information, allowing managers to quickly stabilize operational fluctuations and take advantage of new opportunities.

Audience:
Programmers or developers familiar with the basic concepts of TM1 with a strong programming background.

Privacy Policy

Privacy Policy for datawarehousingsupport.com

The privacy of our visitors to datawarehousingsupport.com is important to us. At datawarehousingsupport.com, we recognize that privacy of your personal information is important. Here is information on what types of personal information we receive and collect when you use and visit datawarehousingsupport.com, and how we safeguard your information. We never sell your personal information to third parties.

Log Files

As with most other websites, we collect and use the data contained in log files. The information in the log files include your IP (internet protocol) address, your ISP (internet service provider, such as AOL or Shaw Cable), the browser you used to visit our site (such as Internet Explorer or Firefox), the time you visited our site and which pages you visited throughout our site.

Cookies and Web Beacons

We do use cookies to store information, such as your personal preferences when you visit our site. This could include only showing you a popup once in your visit, or the ability to login to some of our features, such as forums. We also use third party advertisements on datawarehousingsupport.com to support our site. Some of these advertisers may use technology such as cookies and web beacons when they advertise on our site, which will also send these advertisers (such as Google through the Google AdSense program) information including your IP address, your ISP , the browser you used to visit our site, and in some cases, whether you have Flash installed. This is generally used for geotargeting purposes (showing New York real estate ads to someone in New York, for example) or showing certain ads based on specific sites visited (such as showing cooking ads to someone who frequents cooking sites).

You can chose to disable or selectively turn off our cookies or third-party cookies in your browser settings, or by managing preferences in programs such as Norton Internet Security. However, this can affect how you are able to interact with our site as well as other websites. This could include the inability to login to services or programs, such as logging into forums or accounts.

TM1 Excel Add-in

Cognos TM1 Excel Add-in

To retrieve data or to upload data from/into Cognos TM1, there should be an interface between Cognos TM1 and Microsoft Excel.

Cognos has provided an Excel Add-in to achieve the above scenario which is "tm1p.xla".
Path where you can find the "tm1p.xla": C:\Program Files\Cognos\TM1\bin\tm1p.xla

To add the "tm1p.xla" Add-in in your excel provided you have already installed Cognos TM1 with perspectives.
Steps to add the Cognos TM1 "tm1p.xla" Excel Add-in:

1. Open Microsoft Excel
2. Go to Tools and Click on Add-ins
3. Click on IBM Cognos TM1 Perspectives check box and click OK button

If you are not able to see IBM Cognos TM1 Perspectives in Add-ins list, please follow the below steps:

1. Open Microsoft Excel
2. Go to Tools and Click on Add-ins
3. Click on Browse... button and traverse through the path where tm1p.xla add-in is located. I have already mentioned the path in the beginning of the post.
4. Select tm1p.xla and click OK to insert the Cognos TM1 perspectives/Excel Add-in into the Add-ins list.
5. If the check box for IBM Cognos TM1 Perspectives is selected, click OK button or check the checkbox and click OK.