This forum is ONLY for Sql Developer questions/issues. Unless you can connect this to sql dev somehow then please mark the thread ANSWERED and repost it in the Sql and Pl/Sql forum.
I've been having a problem when trying to create this dimension for a data cube. I assume it is because of the concatination.
I don't see any 'problem'.
Oracle always raises an exception if it has a problem. So when you repost you need to SHOW US (not just tell us):
1. WHAT you do
2. HOW you do it
3. WHAT results you get
4. WHAT results you expected to get