Named Ranges in DBRW

Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: Named Ranges in DBRW

Post by Gregor Koch »

Hi Martin,

No request, I was just curious. And the questions was only whether the Key Error tracer can handle a DBRW that is using a TM1RPTVIEW function.

Cheers
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Named Ranges in DBRW

Post by Andy Key »

Martin, check your inbox for some code to update the Tracer to take the last part of the TM1RPTView into account when identifying the cube name.
Andy Key
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Named Ranges in DBRW

Post by Wim Gielis »

Hello Andy,

Could you please forward that message to me too?
I spent some time on Martin's TM1 tracer code, so I would be interested in other enhancements.

Martin, Gregor,

I recently added an article to my website to enhance that functionality of the tool, and while investigating the code I included extra code to handle named ranges.
You might be interested to have a look at it.

When time permits I would be happy to make further useful enhancements to the tool.

Wim
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Named Ranges in DBRW

Post by Andy Key »

Wim,

It's in your forum inbox.
Andy Key
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Named Ranges in DBRW

Post by Wim Gielis »

Andy Key wrote:Wim,

It's in your forum inbox.
That's correct, thank you.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply