Microsoft Office Tutorials and References
In Depth Information
FIguRE 2-16 Sample report with OnlineOrderFlag decoded.
You can see that no value has changed but the report is now easier to understand because
you have a clear knowledge of the meaning of the rows. In other words, the values are now
self-explanatory, so the report is easier to use.
Important Whenever you create a PowerPivot workbook, you need to remember that textual
descriptions of columns are always much easier to understand when compared to the underlying
code. It is a bad idea to use code inside PivotTables because it makes the final PivotTable harder
After you delete useless and hidden technical columns, you normally need to decode some columns
and create new ones with better descriptions. Then you need to hide the original columns to allow
users to choose only among self-describing columns.
We do not want, at this point, to investigate further how to define more complex columns
because this first technique is straightforward. We prefer to spend some time showing a
different solution to the same issue, which is to create a new related table. This second
technique is interesting to study because, in developing it, you are going to change the
data model, something you should learn as soon as possible.
There is no table in the database that provides a description for the OnlineOrderFlag, so
you need to create an Excel worksheet that contains the table and then make PowerPivot
aware of this new information. To create the table, simply type in an Excel worksheet the
information (see Figure 2-17) and then, after having selected the six cells, choose Format
As Table on the Home tab of the Excel ribbon. You can find the example in the workbook
CH02-02-Related.xlsx in the companion content.
FIguRE 2-17 Decoding table for the OnlineOrderFlag.