Thousands Format an Excel Report
Here we explain how to format an Excel based report to show values in thousands, even though the source is in whole numbers.
Here we explain how to format an Excel based report to show values in thousands, even though the source is in whole numbers.
Annotations in Planning Analytics for Excel allow you to record notes on a specific cell of a TM1 cube direclty in PAX or PAW.
The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.
Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.
Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the rows, rather than the element IDs from TM1.
SUBNM allows you to use a subset from a TM1 dimension for drop-down selection in an Excel, PAX, TM1Web or PAW report or form and open the subset editor to select elements.
Dynamically refer to the current TM1 server with the TM1PRIMARYDBNAME Excel function. It will mean all your server references in TM1 formulas will dynamically update and refer the model you are currently logged into.
The Control Tab in Excel is a great way to keep system relevant variables for your TM1 Excel based reports.
Need to create a dynamic print area in a TM1 Dynamic Report or Active Form? Here are detailed instructions of exactly how to do this really easily!
Do you have Excel based TM1 reports with hard coded Excel SUM formulae? Or manually entered line descriptions on your P&L or Balance Sheet, or a General Ledger cube with negatives for credits and positives for debits, when your users want to see all positive values? Here’s a quick case study for what we achieved for a new client last week that delivers all this and enables the GL cube to be easily used in Planning Analytics Workspace.
Virtual Dimensions and Hierarchies in TM1 and Planning Analytics explained. You can add virtual dimensions, or hierarchies, to any physical dimension in TM1 to expand the analytics available from a TM1 cube. Here we explain what they are.
Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.
Here is how to create a snapshot of a TM1 report in Planning Analytics for Excel – PAX. This essentially does a copy, paste special, values on the TM1 formulae only, leaving all your Excel formulae untouched. It is very useful for creating a version of a TM1 report that is disconnected from the underlying TM1 data.
This is a comprehensive guide to configuring TM1 to use Cognos CAM security. It includes why you might connect Cognos security to TM1, TM1 environment changes and how to deploy and configure the BI Interop files to your BI application and gateway servers.
TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.
Use Active Forms to create dynamic list reports in Excel using TM1 data, that can be zero suppressed and allow users to expand and contract hierarchies.
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we run through how to get it all sorted!
There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop
Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976