Hello,

I want to build a dimension based on table build from:
- hour (number from 0 to 23)
- minute (number from 0-59)
- seconds (string: 0-9; 10-19; 20-29; 30-39; 40;49; 50-59).

So my table contains records like these:
hour | minute | seconds
0 1 0-9
0 4 10-20
2 1 0-9
etc.

I construct dimension and check 'allow duplicate names' to go through
processing, which ends with success.

But when I try to browse data I get (only for hour = 0, minute = 0,
rest of dimension structure looks correctly) an error:
(Unable to retrieve children: Key is not unique in collection)

How can I correct it (remove this error)?? Thx in advance!

Regards, Mark

Do you have a numeric key on the table that you're going to use to join
on in the cube?