OfficeConnect Ad Hoc Analysis
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
Apply and Expand Custom Dimensions and Attributes
Release: 2021-03-12
You can now apply and expand all parent custom dimensions and attributes.
Select the Direction for Expanding Parent Elements
Select the Direction for Expanding Parent Elements
Release: 2021-03-12
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
Expand All or Expand to Leaf Level
Release: 2021-03-12
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
Focus on Parts of an Expansion
Release: 2021-03-12
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 Onlyoption to show only the selection and remove other parts of the expansion.
- Remove Onlyoption 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.