This content has been marked as final. Show 5 replies
1 option :
You can try the above suggestion of namespace. Instead of taking hardcoded value as namespace ,Use the column as name space. for ex.
D are four columns in Data source and A,B,C are going to use in Dimension levels.
then you can create use B column as namespace for C and A column for B. But then In MDX query you have to provide namespace for Dimension members. Its working for us.
2 option :
you can concatenate the dimension levels with prefix or suffix. Take a look of IMP model Fiscal Calendar(Time) dimension stagemap.
Concatenate in Data itself and it seems you are using this only.