Wednesday, September 5, 2012

How to create a left join between 2 dimension or lookup tables?

There are two tables Product Group and Product. If we add attributes Product Group and Product derived from the respective above 2 tables and set the join type of attributes to outer using Data->Report Data Options->Attribute Join type the left join will not happen. The solution is to create a metric out of the attribute say count(Product), add it to report objects of the report and  in Data->Report Data Options->Metric Join Type set it to outer.

No comments:

Post a Comment