question

FreitasRicardoMagMotaFreitas-3216 avatar image
0 Votes"
FreitasRicardoMagMotaFreitas-3216 asked LukasYu-msft commented

SSAS Tabular - Hiearchies with multiple paths

Hello, i'm working on SSAS Tabular and in need of creating hiearchies with multiple paths up, where the main parent also is part (A and J in this case):

A B C D
A B E F G
A B C H
J I E K

Does anyone know how to do this? Regards

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft edited

Hi,

What does those alphabets represent, attributes or actual dimension data?

If they are attributes, I don't why would you like to have A,J in one hiearchy is quite neccesary here? Why just have another hierachy.


You could consider making a ragged hierachy with following:
A B C D
A B E F G
A B C H
Follow this method :Supplemental lesson - Ragged hierarchies

Another independent hierachy for J I E K


Regards,
Lukas


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FreitasRicardoMagMotaFreitas-3216 avatar image
0 Votes"
FreitasRicardoMagMotaFreitas-3216 answered LukasYu-msft commented

Hello @LukasYu-msft they represent actual dimension data, where multiple paths can occur.

A B C D
E J K D

for example. So when i go to create the column with the PATH function, i get an error "Each Value on Dim[id_parent] must have the same value Dim in Dim[id]. The Value ... has multiple parents

Is the link you've sent still good for this type of problems (multiple paths ) ?


Regards

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, I think the ragged hierachy structure should still fit for the need.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,

I happen to read the original post and you following post, it is not enough just simple a child - parent hierachy that two parents for one child. Such as the E in original post or the D in the following post.


You need to do some extra work , please see the thread that has already discussed this issue : multiple-parents hiearchy


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you resolved this issue with above article , any success ?

0 Votes 0 ·