I have one fact tables and four dimensions which are related only through fact table. My requirement is to create a single hierarchy with different attributes from these dimensions. After reading the previous posts on the same subject, I created a Named
query in my data source view which is nothing but the a query that joins all the dimensions and a fact table with their SK and I have the required attributes into the select statement. My question is, Do I have to create a relationship with this Named query
with any of the dimensions or Fact table? If so, what would be the foreign and primary key?
View Complete Post