TM1 Forum

Hello All,

I an creating a Cube that tracks skill level of all the members in the team. The measure dimension will hold a value for Skills of team members as "Basic, Intermediate, Expert". For this I want to create String Picklist. But the problem is that I am using "Staff" dimension in the cube which has the list of all the team members, and it has all the numeric type Elements (Since in other Cube it holds numeric data).

What is the way I can create String Picklist in this scenario to assign - Basic, Intermediate & Expert skill level to the resources?

Any response would be a great help.

Thanks

Sukhen Sharma wrote:Hello All,

I an creating a Cube that tracks skill level of all the members in the team. The measure dimension will hold a value for Skills of team members as "Basic, Intermediate, Expert". For this I want to create String Picklist. But the problem is that I am using "Staff" dimension in the cube which has the list of all the team members, and it has all the numeric type Elements (Since in other Cube it holds numeric data).

You should be creating the picklist on a string element in the measures dimension, not in your staff dimension though right?

Hey,

Yes I am creating Picklist on Measure dimension itself. But If I try to create a String Picklist, it gives an error that "Data Spread Failed"

I believe since the cell is an intersection of All the dimension elements, and other dimension elements are numeric in nature, it does not allows me to create a String Picklist on measure dimension.

I am not able to paste the screenshot here...... Thus I am forced to create a numeric Picklist.

Please advise.

Thanks

Is the element within measures to which your picklist relates a string element?

Can you enter string manually into the cells without the picklist?

Do you have rules on the cells?

Is your measures dimension the last dimension in the cube?

1) If I make the Element Within Measure Dimension as String, then as I said, when I create String Picklist, Error pops up saying "Data Spread Failed"

So to answer your question - Yes, the element in measure dimension is String, but it is not working that way for me.

2) I am not able to enter String Manually even though the measure dimension element is String - When I enter a String into Cell, it says - "Not a Number"

3) No, there are no rules on the cell. Infact there are no rules in the cube itself.

4) Currently the measure dimension is not the last dimension in the cube - I shall try with that also.


Thanks

If you want to be able to enter string into a cube, the element which defines it as string (which should near enough always be the measure dim) has to be the last dimension in the cube. Or at least thats the way it used to be, I don't think it has changed but it may have.

I expect if you redesign the cube with your measures as the final dimension and make the element string, you will be able to get your picklist to work.

ok, I shall try that and will post my observation in couple of hours.

Thanks

Hello All,
Sry to post my reply so late... (I thought I did)

The above solution did help. Putting the picklist dimension as last removed the error of "Data Spread Failed".

Thanks All

Sukhen

Hello Friends,

I wanted a suggestion. I was working with String Picklist. I preferred a dimension based Picklist, so that whenever there is an update made to the dimension, it gets updated in the Picklist.

Can we De-select a cell if the picklist is dimension based?

What I want to ask is, when we create a static Picklist, We have an option of creating a blank element (Static::Jan:Feb:Mar)
If by mistake somebody did select a value of Jan or Feb or March, he has the option of De-selecting by picking blank value.

Is it possible to achieve same using dimension picklist?

Plz share your thoughts.

Thanks

I believe that you will have to create an item of the dimension which you interpret as meaning "deselected".

As far as I am aware there is no way using dimension (or subset) picklists to get a blank item. I would be very happy to be proved wrong.

Hello Duncan,

Even I have the same views. I also dont see a way of inserting a blank element through dimension picklist.

But even I will be happy to prove wrong.

Thanks

Suharsh wrote: What I want to ask is, when we create a static Picklist, We have an option of creating a blank element (Static::Jan:Feb:Mar)
If by mistake somebody did select a value of Jan or Feb or March, he has the option of De-selecting by picking blank value.

Is it possible to achieve same using dimension picklist?

If at an intersection, some one does pick a value from picklist (which uses a dimension) and then you want to blank it out, all you to do is click on the cell and hit delete. Does that not work?

Or am I missing something?

sachin wrote:

Suharsh wrote: What I want to ask is, when we create a static Picklist, We have an option of creating a blank element (Static::Jan:Feb:Mar)
If by mistake somebody did select a value of Jan or Feb or March, he has the option of De-selecting by picking blank value.

Is it possible to achieve same using dimension picklist?

If at an intersection, some one does pick a value from picklist (which uses a dimension) and then you want to blank it out, all you to do is click on the cell and hit delete. Does that not work?

Or am I missing something?

In TM1Web this indeed works. In Excel this will delete the DBR(W) formula instead of the cell value.

Michel

Michel Zijlema wrote: In TM1Web this indeed works. In Excel this will delete the DBR(W) formula instead of the cell value.

From Architect, TM1 Application this works. Never really looked into excel! Thanks for clarifying.