Write, Bureaucrats, Administrators
4,332
edits
Slicing & Dicing: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
(Created page with "{{Stamp|2016-10-25|3.9.7|1.0.3}} The term "slice & dice" became popular when multidimensional databases became a thing. These new (st the time) database systems allowed base...") |
mNo edit summary |
||
| Line 9: | Line 9: | ||
== Preparing for maximal slicing & dicing benefit == | == Preparing for maximal slicing & dicing benefit == | ||
To prepare for subsequent analysis of the data, add related data and calculations to the data and then define aggregations of the data. | To prepare for subsequent analysis of the data, add related data and calculations to the data and then define aggregations of the data. | ||
; Identify the library to center on for slicing & dicing | |||
: You can slice & dice on the entries of any library, and the techniques described here work for slicing & dicing the entries of any library.<br/>However, given any set of related libraries, there is generally one that contains the primary transactional data, while the related libraries may act more like reference or master data. That primary transactional library is generally the one best suited for data analysis.<br/>For example, in the group containing Customers, Products, and Orders, the Orders library provides the best opportunities for analysis, though you can also analyze customer-centered data or product-centered data. | |||
; Calculate within the entry | ; Calculate within the entry | ||