Usability enhancements
Usability enhancements are those enhancements that can significantly improve the overall user experience when interacting with the data model. In order to ensure a successful handoff and adoption of the work you have done, it is important to not overlook these rather basic improvements.
Â
In this section, we are going to cover the following usability enhancements:
- Hiding tables and columns
- Renaming tables and columns
- Changing the default summarization property
- How to display one column but sort by another
- Setting the data category of fields
- How to create hierarchies
Hiding tables and columns
Some tables are available in the data model simply in a support capacity, and would never be used in a report. For example, you may have a table to support many-to-many relationships, weighted allocation, or even dynamic security. Likewise, some columns are necessary for creating relationships in the data model but would not add any value when added to a report. Tables or columns that will...
