Post reply

sass hirarchy

  • February 13, 2019 at 5:37 pm

    #377016

    I’m working on tabular model. I need to create a hierarchy from two different dimensions table. Is it possible? For e.g, I have wholesaler in one dimension and customergroup in another dimension. I’d like to have hirarchy like this Wholesler—->customergroup as 1 wholesaler May have multiple customer groups.

    If this is not possible, is there a workaround? I’m fairly new to this and any help is greatly appreciated.

  • February 14, 2019 at 7:16 am

    #2022062

    SQL_Surfer - Wednesday, February 13, 2019 5:37 PM

    I’m working on tabular model. I need to create a hierarchy from two different dimensions table. Is it possible? For e.g, I have wholesaler in one dimension and customergroup in another dimension. I’d like to have hirarchy like this Wholesler—->customergroup as 1 wholesaler May have multiple customer groups. If this is not possible, is there a workaround? I’m fairly new to this and any help is greatly appreciated.

    It might be possible, but only if your data contains the relationship.  For example, if the Wholesaler data has a single column to identify the customer group, then you are good to go.  If not, then you need some kind of relationship table that can tie the two together.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply