SSAS Tabular - Hiearchies with multiple paths

Ricardo Mota Freitas 1 Reputation point
2021-03-26T15:42:00.74+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-29T05:59:52.077+00:00

    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

    0 comments
  2. Ricardo Mota Freitas 1 Reputation point
    2021-03-29T09:16:17.443+00:00

    Hello @Lukas Yu -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

  3. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-30T05:47:31.503+00:00

    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