TM1 Forum

Hi,

I have a cube with 3 dimensions. One dimension has an element with a pick list as an element attribute. The pick list is another dimension. The pick list brings a forecast curve into the cube - depending on what curve you select it spreads a total budget cost over the forecast months by multiplying the total budget by the monthly % breakdown accosiated with that forecast curve. All of this works fine.

I now want to re-build the cube with an extra dimension (currency). As soon as I build it the pick list stops working...you can still select an element of the picklist but as soon as you do an error message appears "Data Spread Failed".

I have experimented building the cube again with just the original 3 dimesnions (with no rules attached) and the picklist and data spread works (in as much as the error message does not appear). I have then re-built with the 4th dimension (again no rules attached) and the picklist/data spread error message appears.

I do not have much experience using pick lists but have read all help guides etc and cannot see what is tripping me up....although I will be the first to admit that it is probably something very basic!

Any advice would be welcomed.

Many thanks.

Well, first off, a picklist can't data spread. All a picklist is is a drop-down of valid values from which you can use to enter something in a cube. You can take the picklist chosen value and spread it by selecting one of the spread methods in the TM1 menu but this is a secondary task and it is not related to the picklist. You could have manually entered an amount in the cell, minus the picklist, and done the same data spread. If your spread operation is not working then you are trying to do something that is not allowed. The biggest mistake I see people do is trying a proportional spread when all the cells are zero. This is not a valid operation as it can't propertionally spread a number when all the cells in the spread area are blank (think about it). Make sure the spread operation you are trying to perform is valid. Forget about the picklist.

Tomok,

many thanks for your help so far. I still have probloems with picklists though.

I have created a new cube for setting up a project. In the measures dimesnion there is an element called Project Currency. I wanted a picklist /drop down list here of all currencies so I went into the Edit Element Attributed, created a new attirbute called Picklist; typed subset:Currency:Level0. The picklist is visable in the cube. However, when i select a currency I get teh same message "Data spread failed" - and I'm not trying to data spread anything! All I'm trying to achive in thsi cube is inserting a pick list from a subset.

Any advice would be most welcome.

Many thanks

I suppose this is a text cell (S on the last dimension) that you are using. If you set a picklist of non-numeric items on a numeric cell you will get this error message. Perhaps one for John Hammond's list.

Hello Everyone,

I am working with Picklist. I want to create a String Picklist. I have created a cube with 3 dimensions, 2 of which are used in other cube as well. And sine they are used in another cube (Which holds numeric data), the elements of these two dimensions are also numeric.

So now when I want to use these 2 dimensions in my new cube in which I have created a String Picklist, it gives an error as "Data Spread Failed". I understand that a numeric element cannot hold String Picklist. So please suggest how can I implement String picklist using the already existing numeric element dimensions..\\

Any help would be greatly appreciated.

Thanks

Your third dimension (the one specific to this cube) needs to have a "String" element against which the data will be held and this also needs to be placed as the last dim in the cube.

You then can hold the string picklist against that String element, the most common way being to hold it againt the "PickList" attribute for that dim... just search for picklist in the guides and it will get you most of the way.