Hi All,
This is regarding case sensitivity of dimenion members:
I understood from several blogs that Dimension collation has to be mapped to the relational collation. I use oracle as relational source for my cube which is case sensitive. I can make Key columns as case -sensitive. But I am confused with name colums.
Are name columns case sensitivity should be same as releational Source or key columns?
The problem I am facing here is
1. If I make dimensions are case - insensitive, it failes with the duplicate key error due to relational source is case - sensitive.
2. If I make key columns/Name columns case-sensitive, dimension data from 'Roles' do not filter it for users. For example 'Users' are part of dimension and if the dimension is case - sensitive, is user 'MARK' is stored in 'Users' and the
if user log in as 'Mark' , are considered as different login than the 'User'. And the user cannot see the data.
Can you give me an idea , how do I resolve this.
With Warm Regards,