I Have several fact tables and dimensions in my cube. Among the dimensions are Division and Vendor. I have a report with the first parameter being Division. I would like the Vendor parameter to display only those vendors that belong to
the division selected. I have a Division Number in the Vendor table but no direct relationship between the two tables.
How would I filter the Vendor query to only return those vendors with the division parameter already selected? Do I need some sort of relationship inside the cube between the two dimension tables?
View Complete Post