TM1 Forum

Hello all, We installed TM1 9.5 on AIX 5.3. We installed an Oracle 10G client and where able to query our Oracle Database from the server. We added a line in our tm1s.cfg file to read: ODBCLibraryPath= path to the odbc .so file as per IBM Support. When we try to browse for an ODBC datasource we get ...

Oliver, I am most interested. I have come accross some issues trying to Bind subsets to drop downs. It seems when I changed and element in a Column Subset header or Row header, the calulated value was one off the selected element. I thought this was because the elements in the API are indexed 0 vs o...

I will post more as I devlop further. This example is how to get a View in TM1 from a Cube and turn it into a DataTable in C#. Once you have a Data Table as part of a DataSet. You can then do a lot in ASP.NET. You might ask "Why bother?". Well because you can programically Create a TM1 Vie...

Hello all, I have been working with the TM1 .NET API and was wondering if anyone would be interested if I posted a "How To" guide to create a dynamic Data Table in C# (which you can then import into a GridView in a ASP.NET page). Let me know if anyone is interested and I will put something...

Hello, I am working on a cube that has the following dimensions: Tickets (ticket number), Date (The day the data was updated), Status (open, closed, etc..), and Measures (Count, # of closed tickets, # of open, etc..). I created 2 attributes for the ticket dimension (Date Opened and Date Closed) both...

Wim,

Wow.. Too easy.

Thanks for your help!

~Kevin

Hello All!

Does anyone have a quick method or function that returns the number of elements in a subset?

Thanks!

~Kevin

I tried adding a 'No of Stores' element to the Product dimension and created a rule: ['No. of Stores'] = N:if (['Amount'] > 0, 1, 3); This did not work as all products just returned a 0. Wouldn't I create the element "No. of Stores" in the Scenario Dimension and somehow tell the rule to on...

Hello all! Is there a function that returns the count of dimension elements (N-Level specifically) for a given cell value? For example If I have a 6 dimension sales cube with store, product, period, category, employee, and scenario and I am looking at ALL Stores (Top Consolidation) and the total amo...

Thanks Steve. Unfortunatly the consolidation information is not stored in Oracle (At least no one seems to know how to query it.) I have had to load it from a spreadsheet into TI. That is why I don't want to re-create the consolidations. If I did make a separate Accounts update processs and ran it b...

Our Accountants update/change accounts all the time and I am trying to find the best way to update the Account (add attributes such as account name) in TM1 when we load data from Oracle. During my Load Actuals for the current month process, I am trying to create a way where If the account does not e...

I am having the exact same problem and could use some help. I am installing TM1 9.1.4 (x64) on Windows 2003 Server x64 and have had major issues with ODBC processes in Turbo Integrator. The Oracle DB I am connecting to is 9i and I downloaded and installed the Instant Client Package - Basic 10.2.0.3 ...

I installed TM1 9.1.4 64bit Server on Windows 2003 x64 Server with Oracle 9i. I did install the Oracle Instantclient 10.02.00.02 for the ODBC driver. I finally got the TI process to connect to Oracle but running a process takes a ridiculous amount of time! The Oracle query would fetch about 800 rows...