TM1web Action button altering Subnm and not just applying to range

Post Reply
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

TM1web Action button altering Subnm and not just applying to range

Post by Darkhorse »

Hi all

I have used Action buttons in TM1 web before to navigate back and forth using drill throughs from DBRW to Subnms and subnms to subnms however never used the DBRW to range drill through before.

Can someone tell me if this is a fault with tm1 or just the way im doing it.

when i do the DBRW to Range on another worksheet i.e transfer cost center to range B12 on second sheet. the cost centre is going into my selected rangebut its also updating the Subnms at the same time. this isnt what i want to happen.

does anyone else get this same problem?
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1web Action button altering Subnm and not just applying to range

Post by declanr »

Have you left match Title elements ticked?

Would be useful to see a screenshot of what you are doing.

Cheers,
Declan
Declan Rodger
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: TM1web Action button altering Subnm and not just applying to range

Post by Darkhorse »

https://gyazo.com/b3e549ed208e21f6e3fdd8b1b0b0f219

heres what im using but it keeps altering my subnms and loading to the range
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1web Action button altering Subnm and not just applying to range

Post by declanr »

The "Match Title Elements" tick box will make all SUBNMs in source and target sheets the same; if you untick it you can define each individually based on your requirements.
Declan Rodger
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: TM1web Action button altering Subnm and not just applying to range

Post by Darkhorse »

I thought I was missing something, thank you it been a long working night!
Post Reply