上QQ阅读APP看书，第一时间看更新

Actual versus plan

Actual-to-Plan visuals can now be developed using columns from the Date and Product dimension tables

Subcategory Plan versus Actual Matrix Visual

Any column with the same or lower grain than the product subcategory and calendar Year-Month can be used
- Columns from other other tables or columns without a virtual relationship will not filter the Plan table

Bridge tables to support physical relationships to the Product and Date tables could be created in this scenario . The two bridge tables would contain the unique product subcategory and month values and one-to-many relationships would link the bridge tables to the Plan , Product , and Date tables. The Plan and bridge tables could be hidden from the Report view and bidirectional relationships would be configured between the bridge tables and the Product and Date tables. For better performance and manageability physical relationships are recommended over virtual relationships.