TM1 Forum

Hi,

I'm setting up a drill from one cube to another. I intend to allow users to right-click on a particular measure "Quantity" in an Excel template with DBRW, and the drill process will open a Cube Viewer of another cube. I notice, right now, if the drill is initiated from an Excel file, the resultant view is automatically created as an Active Form in another Excel workbook.

Any idea if there is a config parameter in either ini or cfg file, or any other ways that I can limit the resulting view to cube Viewer only? I have checked the Op and Developed guides, both did not mention this.

thanks!

Hi Harry,

Unless you want to use websheets as the UI you will have to rethink your design. In Excel cube drills open as active forms in 9.4+ (and slices in earlier versions). In TM1 web cube drills will open in the cube viewer but in Excel there is no way to achieve this. Further there is no way to launch the cube viewer in Perspectives to a specific view from Excel programatically (other than via Send Keys, which just isn't reliable enough for an y real solution). This design flaw has always been present through many versions, please add your voice to the enhancement requests in the system but don't hold your breath waiting.

thanks for the reply.

in that case, is it possible to mimic a drill in Excel? E.g. I have template A which I want to allow certain columns to "drill" or open another template B. Can this be done in Excel using Excel functions so that I can right click a cell and the elements associated with that cell will be used to open up Template B.

I'm no good with VBA, so this seems to be quite unachievable.

harrytm1 wrote:is it possible to mimic a drill in Excel? E.g. I have template A which I want to allow certain columns to "drill" or open another template B. Can this be done in Excel using Excel functions so that I can right click a cell and the elements associated with that cell will be used to open up Template B.

Yes. All you have to do is capture an element/subset/colsolidation/etc. where you are "drilling" from and pass it to your target report. Depending on what you want to do this should be reasonably straightforward with VBA.

harrytm1 wrote:I'm no good with VBA, so this seems to be quite unachievable.

Oh. In that case you had better go back to the drawing board or learn VBA or find someone who is good at Excel programming to help you.

harrytm1 wrote: in that case, is it possible to mimic a drill in Excel? E.g. I have template A which I want to allow certain columns to "drill" or open another template B. Can this be done in Excel using Excel functions so that I can right click a cell and the elements associated with that cell will be used to open up Template B.

I'm no good with VBA, so this seems to be quite unachievable.

What you can do is use Action Buttons that enable to jump to a different excel report and if required can populate selected elements in SUBNM cells and row and column elements from the report.

It won't be right clicking, but selecting a cell and pressing the Button.
The report doesn't have to be an Active Form.
You don't need VBA for that.

HTH