MDO-ERR-0016 Drill Down ERROR

[shaikeA]

Hi,

I'm using MSOLAP Cube and I got a Problem when I'm doing my third Drill Down In A Pie Chart.

The drill is went wrong a the following message is shown:

MDO-ERR-0016

"The level business key '[cub_BI].[dim Geo Region].[Geo Region Hierarchy].[TBL 4 country2 Geo Region].[TBL 4 Country2 Geo Region - Key]' has multiple parts. This is not supported for queries requiring local processing.

I analyzed the cube and find that in the last level there is a correct DATA (sum of the previous level)but the data is built from codes, for example:

level 3: India [4,000]

level 4: 0026 [3000]
0031 [1000]

For some reason the drill down in not allowed from level 3 to level 4 and the message is shown.

Does anybody can help??