SSAS Tips 
Process only one partition so you can browse the cube
Process only one partition so you can browse the cube
| Process only one partition so you can browse the cube |
| Tuesday, 25 September 2007 19:13 | |
|
If you want to browse the cube and validate dimensions, hierarchies and calculations using the data from only one partition, here is what you can do. Deploy the new cube solution, run a process structure for the cube and then process only one of the partitions. Process Structure will process all the dimensions plus mark all the measure groups as processed. That way, you can start browsing your cube with all the dimensions and one small partition processed.
|
Comments (1)
Most read
- Process only one partition so you can browse the cube
- Create hierarchies in non-parent child dimensions
- Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration ...
- Define a time dimension
- Do not forget to set properly attribute relationship type (rigid or flexible).
Top Rated
- Define a time dimension
- Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration ...
- Avoid redundant attribute relationships because these relationships may prevent data from being ...
- Break distinct count measures into separate measure groups
- If you can, list in SELECT statement real measures first and calculated measures after
- Do not forget to set properly attribute relationship type (rigid or flexible).
- Process only one partition so you can browse the cube
- Remove aggregation designs that are not used by any partitions
Tiago.