Explains what the feature is or what its benefits are to the user or customer.
After modeling the data, create worksheets to make searching easier. A worksheet groups multiple related tables together in a logical way.
- To pre-join multiple tables together.
- To give a user or group access to only part of the underlying data.
- To include a derived column using a formula.
- To rename columns to make the data easier to search.
- To build in a specific filter or aggregation.
Users are often unfamiliar with tables and how they are related to one another. For example, a sales executive might need to search for information about retail sales. The required data could be contained in several tables (sales, customers, products, stores, etc.), with foreign key relationships between them. An administrator who is familiar with the data model can create a retail sales worksheet, that combines all of the related fact and dimension tables into a single, easy-to-use view, and share it with the sales executive. This provides access to the data without requiring an understanding of how it is structured.
You will typically create one worksheet for each set of fact and dimension tables. For example, you may have a sales fact table and an inventory fact table. Each of these fact tables shares common dimensions like date, region, and store. In this scenario, you would create two worksheets: sales and inventory. The following diagram depicts the workflow for creating the sales worksheet.
The process for creating a worksheet is:
- Decide which tables to use for the worksheet.
- Create a new worksheet.
- Add sources (tables) to the worksheet.
- Choose the inclusion rule to apply.
- Choose the worksheet join rule.
- Select the columns to include.
- Create formulas, if needed.
- Save the worksheet.
- Share the worksheet with groups or users.
An alternative way to create a worksheet is to do a search and save it as a worksheet.