# Unable to view all members within a dimension

**URL:** <https://visier.discourse.group/t/unable-to-view-all-members-within-a-dimension/263>\
**Category:** Open Studio & Visier People Extend\
**Created:** [May 25, 2024, 5:28am UTC](https://visier.discourse.group/t/unable-to-view-all-members-within-a-dimension/263 "2024-05-25T05:28:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sharan2795](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@Sharan2795](https://visier.discourse.group/u/Sharan2795)\
**Post date:** [May 25, 2024, 5:28am UTC](https://visier.discourse.group/t/unable-to-view-all-members-within-a-dimension/263/1 "2024-05-25T05:28:37Z")

</div>

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

 ![Screenshot 2024-05-25 at 2.28.56 AM](https://canada1.discourse-cdn.com/flex035/uploads/visier/original/1X/cb1c074966834f8266eab34b8d48362282edbfc3.png)  
 ![Screenshot 2024-05-25 at 2.28.01 AM](https://canada1.discourse-cdn.com/flex035/uploads/visier/original/1X/b64f84cbe387b479251b7ae7cc1b2a3b6df23d92.png)

Any help would be very much appreciated!

---

<div class="post-metadata">

**Author:** ![vincent.chu.visier](https://avatars.discourse-cdn.com/v4/letter/v/e95f7d/32.png) [@vincent.chu.visier](https://visier.discourse.group/u/vincent.chu.visier)\
**Post date:** [May 28, 2024, 2:19am UTC](https://visier.discourse.group/t/unable-to-view-all-members-within-a-dimension/263/2 "2024-05-28T02:19:08Z")

</div>

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](https://docs.visier.com/embedded/Studio/data/validation/debug-inspector.htm) 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.

---

<div class="post-metadata">

**Author:** ![Sharan2795](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@Sharan2795](https://visier.discourse.group/u/Sharan2795)\
**Post date:** [May 31, 2024, 7:43am UTC](https://visier.discourse.group/t/unable-to-view-all-members-within-a-dimension/263/3 "2024-05-31T07:43:37Z")

</div>

Thanks Vincent! Let me give this a shot!