TM1 Forum

Hello,

I'm trying to load a cube with the information of the "Transaction Log File", created as a result of "Saving all data" process.

This is the structure of my text file, but I have some issues mapping the dimensions:

"3" "20120718064815" "20120718064815" "CognosNamespace\Administrator" "N" "120000" "110000" "Phased Costs" "101" "6310" "Y2" "Version 1" "Full Year Cost"

Has anybody done this before?

Thanks in advance.

Phased Costs (column no. 8) is your cube name and the columns to the right side of it are dimension element names in the same order in which the dimensions are ordered in the cube. Note there is a variable number of columns because of the fact that cubes can have different numbers of dimensions.

If you need to get dimension names for your cube, you can do it using the TABDIM() rules/TI function.

If you look here http://bedrocktm1.org/ then you will find that yes this has all been done before with a fully worked process to do exactly what you are wanting to do in this case.