SSAS Tabular Cube (Character discrepancy between source and Destination)

Question

Hi There,

I am facing an issue while processing the data from Hive Database to SSAS Tabular Model with respect to Character discrepancy.
Whenever the data at source level having same data with different case characters but trying to process the data to SSAS Cube , the data is having only lowercase characters only.

Answer 1

Hi,

Does this resolve your issue ? We are happy to know your feedback and progress! :)

Answer 2

Hi,

This issue is caused by SSAS Tabular Database collation. When duplicated data appears the first one will win.
To avoid this and have a case sensitive Tabular database, we must create first a case sensitive tabular database.
For this we need have Tabular Editor tool.
In Tabular Editor, we create a SSAS database (with 1500 compatibility level I have tried). Then we firstly change the collation of it. Change it to Latin1_General_CS_AS

Then we deploy the database with the name you want.

After this you could continue develop the Tabular Model in the Tabular Editor . Or , you could in Visual Studio create a new project by Import from Server(Tabular ) see :

Since the collation can only be changed before any object was created, we cannot change it in your existed project. We'd need to start a new project for you task and remake the Tabular database design.

See my test result, with data similar to yours:

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 3

Could the above answer with pictures be seen ? I hope it could help for your question.