TM1 Forum

Hello all

I need to export data from 2 cubes on the same file.
I used 2 TI processes with ASCIIOuput to export data from my 2 cubes but I get 2 files.

Is there a way to feed an existing file with ASCIIOuput ? Or concatenate 2 files in TI process ?

Thank you for your help.

StoneDX

My understanding is that even within a single TI process using ASCIIOutput or TextOutput on different tabs will overwrite a file, let alone using two separate processes.

A couple suggestions (I'm sure there are others):

1. If you are handy with a scripting language (e.g., vbscript) you could have two processes write two files and then call a script from TI that joins the two files.

2. you could create a separate reporting cube that is populated with values from the two original cube via TI or rules and then use this single combined cube to write to a single file.

3. you could have a TI process with no data source and on the same tab use two loops to scroll through separate views of the two cubes and write to the same file. I know you can loop through dimensions (nested loops if required) and use the current elements from each dim in a cellgetn formula and write that to a file. there may also be a way to create and loop through cube views on the fly (as opposed to using a cube view as the data source) but i've never done that so someone else can say yay or nay...

Executecommand(copy file1 + file2 file3),0);

or so..