Exporting an Excel Report's DBRW cells with all their dimension elements information

[Sandy]

Hello everyone,

As we know that the DBRW function is used to retrieve values from a specific Cube, or to write values to the cube, based on the dimension element intersections.
Conversely, could anyone help me to get a simple .csv export of all the dimension elements along with the measure value for each cell in the TM1 excel report, while taking the Excel application report as the input.

Thanks in advance.

[Steve Rowe]

Hi Sandy,
Suggest you read up on the help for TI processes and search the forum and other on line resources for information on this.

It is pretty much as straightforward as you can get with a TI process and you'll learn a lot more researching the issue yourself.

Feel free to come back after you have worked on the problem yourself and encounter any problems.

Cheers,

[Sandy]

Hi Steve,

I am not trying to retrieve the cube data with a TI process- quite the contrary.
I want to -
* Take a TM1 Perspective Excel Report as the Source [not the Cube].
* For each DBRW cell in the Report, retrieve all the dimension elements[as seen in the 'Function Arguments'], and put them in a seperate .csv file, along with the cell amount value.

Thanks in advance.

[tomok]

You can't do what you want using any functionality in TM1 that I know of. An Excel report can only be used as a data source in a TI when you have a range in the workbook defined as a table and you have that workbook defined on your server as an ODBC data source. Even in this case you would not see the DBRW, only the value that the DBRW last evaluated to before your process was run.

You might be able to write some sort of Macro in VBA that would do what you want. I've never had the need to do something like this so I can't tell you where to start. Good luck.

[declanr]

MyString=ActiveCell.Formula

The above can be used in VBA to get the formula of a cell as a string. You would need to loop the whole worksheet or book; get the formula as a string for each cell... check if it starts with DBRW and then cycle through the delimiters to get each next dim element... but if the dim element is a formula itself you would need to keep cycling back until you find the element name.

Sounds like a lot of work...