Within the TM1Web/Scripts folder open the ‘tm1webbook.js’ file within notepad or the preferred editor. You should probably create a backup of this file before making any changes.
Within TM1 all objects names and contents are completely defined by the Developer. Cubes, Public Views, Dimensions, Public Subsets, Processes, Chores and Applications are all named on creation. All too often naming conventions are disregarded within the initial development stages of a TM1 implementation. Usually an attempt is made to bring these in at a later time, often too late – it will never be considered as a value-add enhancement … Continue Reading
Dimension Worksheets are a great way to manage medium sized dimensions and attributes/aliases. All Worksheets (Dimension and Rule) are held in the local data directory set in the ‘Options’ form found in Server Explorer under ‘File’. To create a new Dimension via Dimension Worksheets
There are a few ways to update a dimension within TM1, the first is the simplest and most commonly used. To update a Dimension using the Dimension Editor: Right Click on the Dimension Click “Edit Dimension Structure” Right Click any where and click “Insert Element” Type the name of the element Check the settings are as expected (Element Type) Click ‘Add’ to insert the Element into the … Continue Reading
Conditional feeders can be used to minimize the storage impact of rule feeders. The typical situation occurs when rule values are calculated by multiplying factors, any of which may be zero. This means that the value should be fed only when all the factors are non-zero. Example Given a cube SalesBySalesperson with dimensions: Salesperson, Product, Month, Measures (‘Sales’ and ‘Commissions’) If you calculate Commissions based on Sales using a commission … Continue Reading
TM1 API Programming – Initial Steps: At the start of a TM1 API project a few steps are necessary to get connected, 1. Include the TM1 API Module 2. At the Beginning of the Project use the ChDir and ChDrive function and set the Selected Directory to the Directory that contains TM1api.dll or put the bin dll files in the projects folder. example: ChDir “C:Program FilesApplixbin” ChDrive “C” The Best way … Continue Reading
Overview Security within TM1 is limited to assigning a client to a group then a group to one or many levels and selections of objects. The levels of objects are: Tier 1: Cubes Applications Processes Chores Tier 2 – Dimensions Tier 3 – Elements Tier 4 – Cube Cells/Intersections of Elements The level based security is reciprocated up the tiers meaning in example that if the ‘Final Budget’ Element within … Continue Reading
Creating a new TM1 Server To create a new server you must first create a data directory, this directory must have at very least: ‘tm1s.cfg’ ‘tm1s.lic’ The configuration file (tm1s.cfg) should specify: Server Name Server Admin-host Data Directory Logging Directory Server Port Any Additional Configurations (Max Login Attempt) The typical directory structure of an Application Server is as follows:
It is good practice to create and destroy a view for clearing rather then leaving a large clear view sitting under the cube waiting for a user to click on it. The code below creates a view and assigns subsets to that view, zero’s the view out then destroys the view and subsets.