Search found 13 matches

by NPTM1
Fri Jul 13, 2018 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing TM1 formulae from a sheet
Replies: 2
Views: 417

Removing TM1 formulae from a sheet

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/false conditions will ch...
by NPTM1
Wed Feb 21, 2018 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using {AR01} functionality in a slice rather than Active Form
Replies: 6
Views: 1113

Re: Using {AR01} functionality in a slice rather than Active Form

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...
by NPTM1
Tue Feb 20, 2018 1:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using {AR01} functionality in a slice rather than Active Form
Replies: 6
Views: 1113

Re: Using {AR01} functionality in a slice rather than Active Form

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...
by NPTM1
Tue Feb 20, 2018 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using {AR01} functionality in a slice rather than Active Form
Replies: 6
Views: 1113

Using {AR01} functionality in a slice rather than Active Form

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...
by NPTM1
Wed Jan 24, 2018 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent calculation of TM1 cells
Replies: 3
Views: 688

Re: Prevent calculation of TM1 cells

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...
by NPTM1
Wed Jan 24, 2018 4:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent calculation of TM1 cells
Replies: 3
Views: 688

Prevent calculation of TM1 cells

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...
by NPTM1
Wed Nov 22, 2017 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cells not calculating unless edited
Replies: 7
Views: 906

Re: Cells not calculating unless edited

The CTRL+ALT+SHIFT+F9 worked, definitely something I'll keep in mind, many thanks Alan.
by NPTM1
Tue Nov 21, 2017 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cells not calculating unless edited
Replies: 7
Views: 906

Re: Cells not calculating unless edited

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...
by NPTM1
Tue Nov 21, 2017 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cells not calculating unless edited
Replies: 7
Views: 906

Cells not calculating unless edited

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...
by NPTM1
Wed Sep 13, 2017 11:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User defined consolidations in a slice
Replies: 4
Views: 1079

Re: User defined consolidations in a slice

Thanks all.

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

Thanks all!
by NPTM1
Tue Sep 12, 2017 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User defined consolidations in a slice
Replies: 4
Views: 1079

User defined consolidations in a slice

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...
by NPTM1
Mon Sep 26, 2016 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Specifying title location in hyperlinks
Replies: 6
Views: 955

Specifying title location in hyperlinks

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 ...