Often, we are required to construct table view dynamically based on the reporting parameter entered at runtime. One approach is writing procedure to create view from parameter passed from AD_PInstance table.
Alternatively, a window can be built consisting of all the required parameter which in turn is joined to the table views for reporting.
In Practical terms:
1. Create a window(ParameterTable) containing Client, Organisation and all required Parameters
2. The reporting Print Format should be based on view(s) with table join to the window table.
For example, the view maybe something like:
CREATE OR REPLACE VIEW Dynamic_View AS ( SELECT * FROM Fact_Acct f, ParameterTable p WHERE f.dateacct = p.dateacct)