Master Data Services 2019 - Excel Add-in Filter Pane Option Hierarchy Tree View

Matthew Chapman 1 Reputation point
2022-02-02T12:58:21.423+00:00

What does the Hierarchy Option in the Filter pain do? I used it on an entity where I have a recursive hierarchy containing a general ledger account structure and it appears to only report the top Parent Level or give me the option to select a parent code. Is that all this does or is there more functionality I'm missing out on?

170572-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,693 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. YufeiShao-msft 7,056 Reputation points
    2022-02-03T06:47:44.257+00:00

    Hi @Matthew Chapman ,

    Try to add attribute in the columns first,and then operate
    Filtering with MDS Add-in for Excel

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments