Data Spread Fails error when using picklist

[yuvaraj]

Hi All,

I have 2 dimensions in a cube. one is S.No dimension. other dimension has Currency and Value elements. I wanted to keep a picklist for Currecny element and created a Dimension Picklist. When opening the cube, the default value is 0 for all cells of Currency column but i see the dropdown list. After selecting the currency value from the pick list, it throws "Data Spread Failed" error. I am using 10.1 verison.

Did anyone encounter this issue?

What did I miss?

Thanks in advance!