KB314158: How to apply the same attribute qualification to both the fact table and the lookup table in the same report

SUMMARY
This document describes a way to apply an attribute qualification to both the lookup table and the fact table in a report in Strategy 10.x.
 
DESCRIPTION
A user may want to apply an attribute qualification to both the lookup table and the fact table in a report.  For example, consider a report with the Month attribute and the Revenue metric from the Strategy Tutorial Project which filters on Month (ID) = 201401.

By default the filter will be applied to the fact table as seen below:
 

select	a11.[MONTH_ID] AS MONTH_ID,
	max(a12.[MONTH_DESC]) AS MONTH_DESC0,
	max(a12.[MONTH_ID]) AS MONTH_ID0,
	sum(a11.[TOT_DOLLAR_SALES]) AS Revenue
from	([MNTH_CATEGORY_SLS]	a11
	inner join	[LU_MONTH]	a12
	  on 	(a11.[MONTH_ID] = a12.[MONTH_ID]))
where	a11.[MONTH_ID] = 201401
group by	a11.[MONTH_ID]

where	a11.[MONTH_ID] = 201401
 and a12.[MONTH_ID] = 201401

• Create a new attribute form for the attribute that the qualification will be based on.  The attribute form should use the same column as the ID attribute form, but it should only be sourced from the lookup table for the attribute.
  

• Create 2 attribute filters in the report.  One filter uses the original ID form of the attribute
  

• and the second filter is defined in the same way except it uses the attribute form created in  step 1
  

• Confirm that the WHERE Clause Driving Table VLDB property is set to use the fact table, which is the default value.

And the SQL will now be generated as desired.

select	a11.[MONTH_ID] AS MONTH_ID,
	max(a12.[MONTH_DESC]) AS MONTH_DESC0,
	max(a12.[MONTH_ID]) AS MONTH_ID0,
	sum(a11.[TOT_DOLLAR_SALES]) AS Revenue
from	([MNTH_CATEGORY_SLS]	a11
	inner join	[LU_MONTH]	a12
	  on 	(a11.[MONTH_ID] = a12.[MONTH_ID]))
where	(a11.[MONTH_ID] = 201401
 and a12.[MONTH_ID] = 201401)
group by	a11.[MONTH_ID]