Matrix relationship SQL not working 🤔

NAJARINE · 2024-03-12T12:07:35+00:00

There was an error rendering this rich post.

NAJARINE

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 :

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

Thank you in advance for your help

Find more posts tagged with

Relationship

Data Reader

SQL Server

Accepted answers

NAJARINE

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

All comments

Tommaso Riva

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

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

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.

NAJARINE

Thank you