Level 200: 204 Functional Test - Confirm that selectors are functioning

My results should be 10, but it appears the table is duplicating each results because my results are showing 20 instead of 10. I have gone over each of the steps to create the screen, twice. I cannot figure out why the data is doubling.

Answers

  • Tommaso Riva
    Tommaso Riva Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments

    Hi @Crystal Peavy,

    I can confirm that the selectors work perfectly in Board.

    Are you working at the highest level of granularity(means having an active selection on all dimensions of the cube)? You can verify this by activating the the data entry function without split&splat option and the cells should turn yellow.

    If the answer is yes, it means that the calculation process needs to be revised and the data flow step where the units are used should be checked.

    If the answer is no, continue looking for the additional dimension that is missing in the selector and check the result. At this point, do you still get 2 at this level of information? If the answer is yes, then check the procedure described above. If the answer is negative, you have detected the mismatch.