Matrix relationship SQL not working 🤔

NAJARINE
NAJARINE Active Partner
First Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board Name Dropper
in Platform

Hello dear community,

I want to do a matrix relationship via SQL datareader (same as explained in the resources below) :

https://community.board.com/discussion/16889/how-to-manage-mapping-data-entry

Here is a screen of the ETL :

Screen 12_03.jpg

The result is an empty cube with no discard and "1" as a validated record

Thank you in advance for your help

Tagged:

Accepted Answer

  • NAJARINE
    NAJARINE Active Partner
    First Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board Name Dropper
    Answer ✓

    It was because the data types were different, the data type validation must be done before the ETL, in other way the number "1" must be written directly in the mapping, and it worked fine for me 😎.

    Thank you

Answers

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

    Hi @NAJARINE,

    are you using the "add new item" option for Dim1 and Dim2?

    What about Dim3 tied to the cube? Dim3 must be numerical like your cube.

    If no transformation is applied, the ETL itself is useless.

    Regards,

  • NAJARINE
    NAJARINE Active Partner
    First Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board Name Dropper

    Thank you @Tommaso Riva,

    Im using dicard new item on Dim1 and 2, and the Dim3 is a (random) numerical dimension like the cube

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

    Are Dim1 and Dim2 given with members?

    If not, then try using "add new item" for Dim1 and Dim2 and check if the cube is fed.

    If the above is not your case, the problem might be with the cube type or with the Input Field type or with the SQL syntax.

Categories