Below we have the nifty MDX filter expressions that gets all descendants from 2 levels above where the user id can be found in the hierarchy. The MDX works but it gets all the siblings as well not only the main agency that the user is actually in (at bottom level).
General Agency ------Main Agency ---------Team ------------Seller_ID
with Acensors.....2 we want to go 2 levels up and get only the Main Agency the seller is part of and not all main agencies-
We figured out that there was an error in the hierarchy.
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.