When querying data from a dimension that has multiple hierarchies, query performance may improve if you query the data in the following way:
Including dynamic hierarchy members and stored hierarchy members in the same query may require a large internal memory cache, which decreases query performance.