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??