TM1 Forum

Hi I've been using a macro that I found online to replace TM1 formulae with values. It searches for the formulae beginning with "=DBRW" and "=-DBRW" and various other combinations, which so far has been working great. However I've now got DBR within IF formulae, and the true/fals...

What is it that you want? A dynamic list of the elements in the subset along the rows or just one row that has the total of your subset elements? if it is the former then you either use an Active Form or you use my approach. You just have to add enough SUBNM formulas to cover for when the list expa...

Create a subset of the elements you want and then reference them in a column using the SUBNM function going down the rows, incrementing the index parameter as you go. Thanks for the reply. The issue I've got is that the subset needs to be quite flexible as the elements will keep changing, so I'm no...

Hi Does anyone know if there's a way to roll up elements and reference them in a slice report? I know this can be done on an Active Form using the hidden tab with elements listed. I wanted to do something similar on a slice but couldn't get it to work. Essentially, I've got a list of elements in a c...

All calculations for the cell is done regardless you read the cell or not. Yeah I was worried that might be the case. I was hoping to avoid reading from the cube if a certain condition was satisifed, as the local calculations in Excel are much faster than the TM1 ones. I'm not familiar with SKIPCHE...

Hi Does anyone know of a way to conditionally prevent a DBRW cell from performing it's calculation? I've got a lot of TM1 formulae in my workbook and it takes an age to reload. Depending on the data, a lot of these cells don't actually need to be loaded and can be skipped. I think wrapping inside an...

The CTRL+ALT+SHIFT+F9 worked, definitely something I'll keep in mind, many thanks Alan.

They seems to work as normal after edit/enter. It was only 4 cells that were affected on the sheet. I guess I was hoping to find out the cause to avoid having this happen in future. I know that I grouped tabs together to do a bulk edit, and maybe this triggered a bug. It's possible this was an excel...

Hi all I'm not sure if this has come up before, but I've got a strange situation with a slice. I've got some DBRW cell forumulae which update ok, however SOME dependant cells don't seem to want to recalculate (e.g. a Sum formulae). I've tried using Shift+F9, F9 and Alt+F9 but these dependant formula...

Thanks all.

As I suspected this can't be done without a TI process, which i'll take a look at.

Thanks all!

Hi I am looking to find a way to create a temporary consolidation based on cells in Excel. I've seen that Active Forms have the functionality (where the TM1RPTROW formula references a hidden worksheet called {AR01} and the user can add elements to the list). However I've tried to do something simila...

Thanks all!

Hi all I have a websheet which contains multiple SUBNMs on the same page referring to the same dimension. I also use hyperlinks with the TITLE parameters to populate these SUBNMs. However I'm unsure how exactly to specify which cell's SUBNM I want to populate. e.g. The hyperlink says something like ...