TM1 Forum

I created a Cube. Its has Measure Dimension with 2 elements : Say Sales and Price

Measure
- Sales
- Price

Cube has 4 Dimensions including Measure Di.

I have a CSV file where all 'Sales' for a Product are given. Now how do I load these Sales values from CSV to Sales element of Measure Dimension.

In TI, in update cube option its giving error, that Element variables and Dimension of Target cube not matching.
I read about CellPutN.... not sure how to use it.

Thinking of a while loop where it will fetch SALES from csv and use CellPutN to insert it.

Perhaps it might be worth looking at a training course or getting a few days consultancy to get you up and running.
You are not going to be able to get very far without if you are asking questions like this.

What can I say friend .... but I did google search to find existing Solution related to this ..... I didn't find a close solution.... may be I missed this time if this is basic and there is an easy solution for this.

The point AmbPin is trying to get across to you is that your question is a very, very, basic question relating to how to create a Ti process to import data into a cube. This is an example where not all the data necessary to import is included in the file, so you need to either create a variable in TI to hold the measure element, or skip the wizard and hard code the CellPutN code yourself. Either of these will work. If you don't know how to do something as simple as this then you really do need to think about attending a training class.

In particular you should read this page from the IBM Turbo Integrator tutorial which should have given you enough information to get going.

The IBM documentation on the internet includes a rules guide and a TI guide. If you are starting out you should spend at least a week going through both of these and doing the examples. You won't come out of it an expert but you will know enough to answer this question and you will have a much better feel for how the product works.

Thanks Duncan.... Actually I am a TM1 Admin... trying to get more into Development. I have worked on planning and creating Cubes/Dim, also worked on Rules.

But m new to TI loading.
I searched for the error that I am getting on IBM and other website.... but ....... np .... I was aware of using CellPutN (as also confirmed by other members).... just need to figure out how
thanks..

TF34375 wrote:Thanks Duncan.... Actually I am a TM1 Admin... trying to get more into Development. I have worked on planning and creating Cubes/Dim, also worked on Rules.

But m new to TI loading.
I searched for the error that I am getting on IBM and other website.... but ....... np .... I was aware of using CellPutN (as also confirmed by other members).... just need to figure out how
thanks..

I'm not sure how you can be having a problem with CellPutN.

CellPutN is simply the TI equivalent of a DBS or DBSW formula in Excel; it's pretty much TM1 101.

The arguments that you pass to CellPutN are, in order (again exactly the same as a DBS):
- The value that you want to write to the cube;
- The name of the cube that you want to write to;
- The name of an element form each of the cube's dimensions, in order.

The value should be supplied by your data source. The name of the cube can be hard coded as a string. The names of the elements of the three non-measures dimensions should (normally) be supplied as part of your data source, in separate columns. These will then be the Variables shown on your Variables tab.

The variables that represent element names should be specified as having a Variable Type of String and a Contents value of Other. You then use those variables as arguments to your CellPutN formula, in the same way as cell references would typically be used in an Excel spreadsheet for a DBS or DBRW formula.

The Amount column will have a Variable Type of Numeric and a Contents Value of Other.

If your data source does not contain a column representing each of the three dimensions, you can hard code some of them.

If the source file contains nothing but sales, you could specify the fourth dimension as a string.

So if your file looked something like this (assuming that (for example only) Company, Department and Month were your three non-measures dimension):
You would have the variables Company, Department, Month and Amount and your DBRW formula (on your Data tab) would look something like: Note the single quotes around the cube name and measure (since they're fixed strings), but NOT around the variable names.