TM1 Forum

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

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.

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

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.