TM1 Forum

Hi,

Is there a why how i could create a cube from a csv source by using TI. In the csv there would be a list of dimension.

CreateCube(CubeName, d1, d2,....n)

How i could generate this script based on a list of n dimension from csv file.

Regards,
K

kastellu wrote: CreateCube(CubeName, d1, d2,....n)

First of all the the correct function to create the cubes is CubeCreate() - not CreateCube which you have mentioned.

Personally I think that creating cubes from the CSV might not be a good idea but yes you can create the cubes using a CSV files. You can have two columns in the CSV - one for the Cube Name and another for the Dimensions of that cube. You will have to make sure that the Dimensions are listed in the order which you want for your cube to be created.

In your TI before you CubeCreate() you need to parse through the CSV and put the dimensions column values into different variables.

Rather then going down the path of using CSV files I would simply create different variables in TI and will use those variables in the CubeCreate() function.

kastellu wrote:Hi,

Is there a why how i could create a cube from a csv source by using TI. In the csv there would be a list of dimension.

CreateCube(CubeName, d1, d2,....n)

How i could generate this script based on a list of n dimension from csv file.

Regards,
K

This is all covered in the Turbointegrator Guide, in the section appropriately entitled "Creating a Cube From a Text File". Imagine that.

Or... use Cognos Insight (TM1 10.1)