In OLAP (Online Analytical Processing) cubes, dimensions are ways to categorize data. For example, in a sales cube, you might have dimensions for Time, Products, and Geography. Each dimension can have a hierarchy, and the top level is often represented as "All," which aggregates the data across all members of that dimension.
By default, the top level of each dimension is labeled as "All" followed by the dimension name. For example:
This default labelling can be redundant and might not add clarity to the reports generated from these OLAP cubes.
Simplify and unify the representation of the top level in each dimension to improve the clarity and appearance of reports.
Adjusted Setting: The 'All Caption' property for each dimension is set to "All" without the dimension name.
Dimension Caption: "All Products" Dimension Caption: "All Time" Dimension Caption: "All Geography"
❌ Figure: Bad example (Before adjustment) - In this scenario, the prefix "All" followed by a space and the dimension name can make reports look cluttered and does not add meaningful information
Dimension Caption: "All"
✅ Figure: Good example (After adjustment) - In the improved scenario, each dimension's top level simply reads "All," eliminating redundancy and making the data presentation cleaner and more straightforward
Adjusting the 'All Caption' property in your OLAP cube dimensions simplifies report headings and enhances readability. This minor change can significantly impact the professionalism and clarity of your reporting solutions.