With this release, we improve OfficeConnect ad hoc analysis functionality. We enable users to quickly analyze reporting data by viewing the details using different expansion options. Also, users can apply and expand custom dimensions and attributes in reports.
Watch the video: 4m 20s
Apply and Expand Custom Dimensions and Attributes
You can now apply and expand all parent custom dimensions and attributes.
Select the Direction for Expanding Parent Elements
We now enable you to take these actions on parent elements for all reports or a single report:
- Expand columns to the left or right of the parent.
- Expand rows above or below the parent.
Expand All or Expand to Leaf Level
You can now expand all parent elements including all descendants. We also enable you to expand all parent elements to the leaf level only. This makes it easier to access the rows where you need to enter data.
Focus on Parts of an Expansion
We now enable you to focus on specific rows or columns of an expansion by hiding the other rows or columns. You can select specific rows or columns that are part of an expansion and then select the:
- Keep Only option to show only the selection and remove other parts of the expansion.
- Remove Only option to remove the selection from the expansion.
When you use either option, we shift the data so that the remaining rows or columns are no longer an expansion.