You create a PerformancePoint Add-in for Excel report. Your report contains three matrices that are based on a model. The model contains a dimension named Products. You need to apply a linked filter to the three matrices by using the Products dimension. What should you do?
A.
Create a global filter on the Products dimension. Set the Locked property of the filter to True.
B.
Create a global filter on the Products dimension. Set the Hidden property of the filter to True.
C.
Create a global filter on the Products dimension. Apply the filter to the three matrices.
D.
Create a filter on the Products dimension for the first matrix. Copy the filter and paste it to the other two matrices.