I have a parent-child dimension for Clients and Client Groups. I am able to query the levels properly, however I am wondering how to properly filter these when using SSMS query browser, or Excel. For example, there is a client code for both the client and client group. I am able to filter based on the client code for the client, but the only attribute I see for the parent is Client Name. I see the client code in the member properties of the group, but am unable to use these when browsing. It would be nice to be able to filter the client group on the same attributes that I can filter the client on.
Any assitance would be appreciated! Thanks.
View Complete Post