Cube: How do I use Sampling in a Cube?
It is possible to apply the same sampling techniques used in a selection to the cells of a cube i.e. Limits, Top N records or N records per table. This means that when a selection is created by dragging cells off a cube, the selection will include the sampling options specified.
-
Create a cube of Income and Occupation at the People table.
-
Click on the Sampling button to activate the function.
-
Highlight the cells that cover Occupation Director, Manager Professional with Income bands 30-40k, 40-50k, 50-60k.
-
Right click on one of the highlighted cells and select the option Apply Sampling Limits…
-
Define the sampling to select a Random 10%.
- Left drag
the highlighted cells onto the workspace to create a Limited selection
to find a random 10% of the records in each cell.
Use the Top N and Nper functions in the same manner as described above to have that sampling method applied to each cell selected.