Hi,

I am facing performance issues while trying to pull data in to an excel pivot table from SSAS 2005. When I try to have an attribute named "Product Category" as a filter among other filters and then pull in the attribute "Product ID" in the row labels, the cube performace is very very slow, even for 30 rows. But when I keep the Product Category in the row labels and then filter on it for some categories and then pull in the Product ID, the performance is very good. Here, the Product Category and Product ID attibutes are related : Product Category is the parent of Product ID. Is there any rule that related attributes should be used together in row labels or so. Please let me know if I am doing something wrong here, or is this the expected scenario.