Tag Archives: SQL Server

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just wanted to use the simple method – create a text file and load it up. Problem with Comma Separated Values My problem was that some of the columns contained text that had random commas, so a regular AsciiOutput wouldn’t work … Continue Reading

Sending Cube Data into a Database

Create a new Turbo Integrator Process For now we won’t set the data source for the TI Process because we want this to be a Cube View that we create as the first step (Prolog procedure). So the first thing is to create the view and assign dimensions subsets which will filter the rows of the data source that we will be sending into the source system. An example of … Continue Reading