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!