TM1 Tools Issues And Discussions (Was *KEY_ERR Tracer)

[rks1]

Hi Wim!
Now that works just fine. Thank you.

There's one more question though:
I want users to use the Bulk-Paste option. But these users are not quite "technically advanced". So I am worried they break something if they click on the wrong button. I just want them to use certain functions. Is it possible to deactivate functions (such as the hierarchy documenter) for certain (or all) users - maybe even through the command lines?

Thanks for your help!
Konstantin

[lotsaram]

Hi Konstantin

The add-in is "open source" and the code is not protected. You can modify it any way you like including disabling functions and removing buttons. So the answer is yes of course.

[ykud]

Hi everyone,

First of all, thanks heaps for the tools, they're brilliant.

Was wondering if there's a version for 64bit office?
I converted the current Version 1.0 from http://www.tm1forum.com/viewtopic.php?f=21&t=2515 by adding PtrSafe to all declare statements and it seems working, but I can't get button icons to display properly (tree view controls are not bundled in office 64, causing quite some grief in bas_GUI), so there's some work to do to change smileys back to icons. Wanted to check if somebody had already done that before embarking on this wonderful journey.

Cheers,
Yuri

[jrizk]

Using concept of TM1Tracer posted earlier I've attached the following add-in (for Excel 2007/10).

There are 2 functions.

DB Tracer - similar to the tracer in TM1 Tools
- traces DB/DBRW/DBRA/DBSS/DBSW/DBSA formulas (also for active forms)
- highlights if the formula is a read or send formula
- highlights if the cube is an attribute control cube
- highlights the cube cell type
- highlights if the cube cell can be written to
- highlights if the DB formula/cube value is modified (ie DBRW()*-1)
- shows the element principal with aliases
- adds the rule for the cube cell if there is a rule (bit limited due to string lengths)
- adds clickable links to visible cell references (ie clicking on the links will take you to a particular cell reference but not if it's on a hidden or grouped row/column and not if the reference is to a closed workbook)

DB Builder - just interested to see if I could get something like this to w work - might do more with this at some stage
- allows a DBRW formula to be constructed based on either
- a selection of elements from each of the cube dimensions.
- the first element from each of the dimensions

I've extracted these components from something else I have been working on, so please advise if there are any problems. Also would be good to get some feedback.

And use at your own risk - as no responsibility will be taken for use of the add-in or the code.