Unable to view all members within a dimension

[Sharan2795]

Hi there! I am experimenting with uploading engagement data into the Employee experience blueprint analytic object. I got the employee experience data dictionary template from the visier support website. There is a column in the excel template for survey event response score which I used to upload sample Likert scale responses. This column takes values between 0 and 5 (Likert scale responses). Once I upload the file, create source, I created a new project to create a data dictionary and do the mappings. When I map the column in the excel with the blueprint leveled dimension in the analytic object, in preview, I can see all the values that column has. However, after I run the job for that data dictionary and go to the analytic object and select the dimension, I am not seeing all the values. Can you pls help me understand why? I have uploaded the screenshots of what I am talking about

Any help would be very much appreciated!

[vincent.chu.visier]

Hi there! What you see in the first screenshot is data in your data version, while the values you see in the second screenshot is data in your source.

There could be a number of reasons why the values may not be the same - from different business rules, loading behavior to transform that you could have applied in later stages.

If you have access to the Debug Inspector Debug Inspector you can see where the values got changed.

You can also use a Map from formula instead: “if(column(“Score”) = “”) -1 else toInt(column(“Score”))”, if the column in source is called Score.

[Sharan2795]

Thanks Vincent! Let me give this a shot!