Frequently Asked Questions (FAQ)

General Questions

What is TM1Connect SmartCache?

Learn about the different types of caching Session: caching, Dimension caching and Global caching along with when and how to use them.

How do Batch and On-Demand modes operate?

This topic explains how the On-Demand and Batch modes operate for a better understanding of configuration and performance considerations.

Refreshing Tableau After Updates in TM1

Tableau strives to be fast, but sometimes fast gets in the way of the real-time nature of TM1. Here are some tips for getting real-time data in Tableau to update on demand.

Troubleshooting

IIS Error 503 - Service Unavailable

After installing TM1Connect, if you get a IIS Error 503 - The Service is Unavailable message on Windows 7 or Windows 2008 you may need to enable permissions to the TM1Connect data folder.

Best Practices

Avoid the "All-Encompasing" view (aka Cube Dump)

It may seem like a logical thing to do, but creating a view which has every dimension on the rows and all attributes into one single all-encompassing view is not only data intensive, it also does not leverage the business logic in TM1.

Dynamic queries using a dropdown menu in Tableau

TM1Connect allows you to incorporate TM1 data directly into your Tableau dashboards. By using dropdown menus, radio buttons (or other selectors), you can make your dashboards dynamic, contextually aware, and leverage all the business logic already in TM1.

Title Dimensions and the SQL WHERE Clause

When dimensions are placed in the titles (filter) area of a TM1Connect view, they are still accessible from an SQL WHERE clause even though they don't show up in the rows or columns. This is the key to "define-once, use-multiple" views in TM1Connect.


 © 2019 CarpeDatum Consulting, Inc.

TM1CONNECT IS POWERED BY CARPEDATUM CONSULTING, INC. IBM, COGNOS, TM1 AND THE PREMIER BUSINESS PARTNER EMBLEM ARE TRADEMARKS OR REGISTERED TRADEMARKS OF INTERNATIONAL BUSINESS MACHINES. TABLEAU AND THE TABLEAU PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF TABLEAU SOFTWARE. QLIK AND THE QLIK PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF QLIKTECH INTERNATIONAL. MICROSOFT AND THE MICROSOFT GOLD PARTNER EMBLEM ARE REGISTERED TRADEMARKS OR MICROSOFT CORPORATION.