Assuming the following dimensions and members:
Scenario – Actual, Budget and Year – 2010, 2011, you need to create a data form with two columns. One
column should list Actual for 2010 and the second column should list Budget 2011. You do not want to show
data for Actual 2011 even though the first three months of the year have been loaded from the GL.
What is the best way to only show the 2 columns in the data form?
A.
You cannot build a data form with these two columns, hour columns will display: Actual >2010, Actual
>2011, Budget->2010 and Budget >2011
B.
Use Segments on the data form to create the asymmetric columns.
C.
Use User Variables on the data form to create the asymmetric columns.
D.
Use a composite data form to meet this requirement.
E.
Use data suppression on the data form.
Explanation:
Asymmetric rows and columns are ones in which different sets of members are selected across the same
dimension.