TM1 Forum

Hi all, I'm new to alt hierarchies, so looking for some advice from the trailblazers! I'm trying an approach utilising alternative hierarchies in PA 2,0 to calculate stock balances. The goal is to store the movements and calculate the balance in any particular week. The approach is as follows: We ha...

New link, due to site update: http://flowolap.com/array-types-in-turbo-integrator/

So I have come across two very annoying TM1 bugs in the past few days. Thought I'd share and see if anyone else has had the same experiences. Problem 1 I'm not sure exactly what conditions cause this, but it seems TI processes with lots of parameters cause Action Buttons in TM1Web / Contributor to s...

Rules are supposedly compiled, so in theory it should make no difference. TM1 is a quirky beast, though, so if you have some evidence it might, I'd be interested to hear it.

Or this: http://blog.flowolap.com/post/2013/02/0 ... rator.aspx

Sorry, not sure how the link got broken...

TM1 does not have any built in functionality to connect to external web services. If you would like to import data from a web source, you would need to write a custom executable or script to do the work. Many approaches are possible. For instance, the program/script might poll the web service period...

Flow Genesis will do this for you, but the future of that product is in doubt . I'm considering continuing it in a free version if there's any interest. You can also use freeware tools like WinMerge, SVN, etc, to do a similar thing, as I did before I developed tools to do it for me. I posted a blog ...

I'm not sure if it's the same issue, but I had heaps of issues installing 10.2.0.0 64-bit on Windows 7: I couldn't run Configuration Manager until I replaced the file JCAM_Crypto.dll in the bin folder with the similarly named one from the bin64 folder Sometimes the tm1_64\webapps\tm1web folder would...

If your main purpose is to hide columns, there might be better ways to do this. I doubt that hacking the TM1Web aspx files (if you're on an older version) or the Java files would end up being a robust solution, even if you could get it to work in the version of TM1Web you are running. If you determi...

Just thinking outside the box a little, is there any reason you couldn't build a reporting cube for this? What you have is a classic case of what I call an "Item Based" input cube. Why not create another cube that includes all the columns you would like to filter by as dimensions? Here's a...

There are various documentation generators for TM1 that might help you get a high level understanding before digging into the details. I just started a new project and found generated documentation invaluable in getting my head around the cubes/dimensions/processes. PM me if you want a few suggestio...

This article might help you. It discusses various approaches that will achieve what you want, with examples and screenshots.

TM1 Applications and cross dimensional security or Access tables with NoData in TM1

Sadly, due to a lack of interest and support, the Genesis product will be discontinued in it's current form. More detail on the reasoning behind this decision can be found on the Flow blog . If you guys have any views on why there was so little interest from the community, or ideas for how to take t...

You could try using rules to achieve what you want also. Performance is a major concern when doing so, but it can work very well if the data size will accomodate it. I have a blog post about the approach you are describing where I refer to it as the "Item-based Approach". Here's the link, ...

You're right Duncan. I did a test and determined that there is no significant difference between the performance of string and numeric attributes. This suggests that numeric attributes are simply regular text attributes with a data input validation and automatically-handled conversion. I would still...

Interesting points Duncan. I'll see if I can get inspired to run a few tests tomorrow and confirm some of these possibilities. I'd be interested if you can provide a link to the documentation that confirms numeric attributes are stores as string. Are you just extrapolating from the behaviour at cons...

When any issue of efficiency comes up, it's always important to do some testing to determine the best solution. TM1 has some complicated internal logic that leads to quirky behaviour in some cases that can be difficult to predict. Generally speaking, I simply count the number of cube reads to determ...

TM1ClientDisconnect definitely exists in the 10.1 API dll. I don't have 10.2 installed on this machine, but I'd be surprised if it was removed, since the front end calls it! There is also a function called TM1ClientDisconnectEx, but since I'm just "peeking" at the dll using Dependency Walk...

Yes, this "feature" makes it very difficult to detect changes correctly for a revision control system. I find it very annoying, but it's usually enough for me to just manually roll back the ones I know for sure haven't changed. This would be a lot more difficult in a large project with mul...

kaazimraza, thanks for the offer. I'll speak with my associates and see if we have the bandwidth to organize it. I think it'd be a great thing for the community and could lead to better adoption of TM1 overall. I'll PM you with the result. PS: The basic API wrapper has been updated to support CAM se...