TM1 Forum

This may be a bit abstract, but here goes: Basically, I have a master TI that launches a bunch of other TI's in a certain order. When doing this on my development environment, all is well and the full set of TI's finish in 5 minutes. An exact copy of this TM1 server, migrated to my test environment...

This may be a bit abstract, but here goes: Basically, I have a master TI that launches a bunch of other TI's in a certain order. When doing this on my development environment, all is well and the full set of TI's finish in 5 minutes. An exact copy of this TM1 server, migrated to my test environment,...

Hi Rizwan, That'd be an option indeed, but I haven't found a way to make use of that dimension in a dynamic way. The eventual goal would be to build a fully dynamic solution that could handle a form being saved from one place to another without having to do manual updating to the location line. I'll...

Hi all, I've been playing around a bit lately and I've been wondering whether it's possible in Perspectives to create a dynamic location of the form, including the entire folder structure above it, similar to image below. I assume it's possible since you can link to a form via Action Buttons and the...

You can catch the error if you have the SubsetCreateByMDX in a separate process that you call with ExecuteProcess . This sub-process will bomb but the calling process will continue. You can query the system global variable ProcessReturnCode ( but be aware that you have to declare it first with Nume...

Lotsaram, that is indeed one of the methods I tried to describe, it's a shame that it seems there is no other way to do this though. Declan, the problem is that I am creating this subset solely for the purpose of manipulating some data, the view and subsets are delete by the TI after doing so. The r...

Hello all. I was wondering if anyone knew a good way to handle the problem of having an empty subset on creation by MDX in order to create a view on a cube (for copying purposes, for example). Long story short, I am creating the subset based on a certain value in one of the dimension's attributes, b...

I'm not sure I fully understand your issue, but from the looks of it I'd say take a look at the following things: - Are your rules fetching all the data from the other cubes or just the data you need? - Are you using feeders/are you feeding the rules correctly? - Is your view simply too big for your...

My knowledge on MDX is rather small, as far as I know you'll always need to filter on something somehow, whether it is an attribute or a dimension element value/level/.. What I'd do in this case though, at first glance, is create a dummy element in your time dimension. Then via an entry form or stra...

Unfortunately, there is no TM1 Macro function for rebuilding active forms There is a macro function for that - TM1REFRESH. I have actually tried using that earlier today, the problem I have with that function is that it will just refresh the active form as soon as I alter a value, leaving the old v...

That's what I usually do indeed, because at the end of the day it does the trick. This was more of a test to see if I could achieve it without having to click the button or changing the calculation method from Excel, but as it turns out it is not feasible in this way. Thanks for the great answers to...

Paul, it is indeed an active form. Why exactly does it not work?

I did another check and it turns out what I said initially is not entirely correct. Long story short, what I wanted to achieve with this setup is that if somewhere on the sheet a cell (not necessarily one containing TM1 data, just any cell) is updated, the VBA code is triggered because of the WorkSh...

Hi Tomok, the IF structure is not necessary indeed, but it is not the root cause of the issue I am having. Both with and without the structure, the TM1RECALC1 function doesn't update the consolidated values on the sheet.

Hi, I've been having some issues with the TM1RECALC1 macro function. I would like to see a sheet's data being recalculated. An easy option would be to turn on automatic calculation, but I was wondering whether it was possible to force the recalculations through VBA. Private Sub Worksheet_Change(ByVa...

Thanks for your swift reply, this more or less confirms what I expected, Excel is the culprit. It's a shame it cannot be evaded somehow though.

Hello all, I'm quite new to TM1, perhaps the following may be a rather stupid question, but here goes.. Basically, I am building a form to plan the volume per month, per promotion (action). In order to get this done, I've built a cube with a range of dimensions related to the customers/products/time...