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?
TM1web Action button altering Subnm and not just applying to range
-
- 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
Have you left match Title elements ticked?
Would be useful to see a screenshot of what you are doing.
Cheers,
Declan
Would be useful to see a screenshot of what you are doing.
Cheers,
Declan
Declan Rodger
-
- 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
https://gyazo.com/b3e549ed208e21f6e3fdd8b1b0b0f219
heres what im using but it keeps altering my subnms and loading to the range
heres what im using but it keeps altering my subnms and loading to the range
-
- 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
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
-
- 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
I thought I was missing something, thank you it been a long working night!