level 200 - module 204 - Confirm that the ACT - Units and Sales data reader is functioning

José Correa
José Correa Employee
First Comment Level 100: Foundations of Building in Board
in Academy

Hi guys!

So yes, I finished the data model and now I am doing the validation phase. When it comes to this specific check:

image.png

My Result does not match the numeric values, this is what I get:

image.png

Why would be my values so high and mismatching?

This is what is shown when I reply "No" to that step in the course:

image.png


I validated 1 and 2, as those are the only that Apply to my scenario.

I am stuck!

Answers

  • John Williams
    John Williams Employee
    10 Comments Level 300: Expanding Board in Your Organization Name Dropper Board Developer

    @José Correa

    Thank you for bringing this to our attention. Based on your screenshots, it appears there is a discrepancy in the numeric values.

    Let’s collaborate to resolve this issue together. Based on the screenshot you shared, it looks like the "Material Group" selector is missing.

    To better understand what might be causing this, could you provide the following details:
    1) Can you share a screenshot of your Data Model structure, including the Entities and Relationships?
    2) Can you open the Relationships panel and provide a screenshot to confirm the hierarchy setup?
    3) A screenshot of your Cube structure (dimensions used, data type, and sparsity settings).

  • José Correa
    José Correa Employee
    First Comment Level 100: Foundations of Building in Board

    Hi! thanks for the attention, sure here you are:

    1) entities:

    image.png

    2) Relationships ( no errors according to analize button)

    image.png

    3 Cubes:

    image.png


    image.png


    Hope that helps! I am farely new with the tool

  • John Williams
    John Williams Employee
    10 Comments Level 300: Expanding Board in Your Organization Name Dropper Board Developer

    @José Correa

    Thank you for your prompt response. To assist you better in resolving this issue, I would appreciate it if you could check and provide the following details along with relevant screenshots:

    1. Cube Size: Could you confirm the size of both cubes? Please refer to the attached screenshot as a reference.
      200 1.png
    2. Cube Structure: How are both cubes structured? Kindly share a screenshot of their setup for better clarity.
      200 2.png
    3. Data Readers Validation: Can you verify the valid records within the Data Readers? If possible, please provide a screenshot to help analyze the data consistency.
    200 5.png

    These details will help us diagnose the issue more effectively. Looking forward to your response.

  • José Correa
    José Correa Employee
    First Comment Level 100: Foundations of Building in Board

    Hi Jhon!

    Thanks for the follow up!

    Sure here we go:

    1) Sizes of cubes:

    image.png


    2) Structure of each cube:

    image.png


    and the second one:

    image.png


    3) Validation on data readers

    image.png


    Please tell me if anything is missing, Thanks again!

Categories