Excel crosstabs, pivot tables FAQ and best practices

1. Excel crosstabs and OLAP cubes development

1.1. Modify source connection parmeters of Excel Crosstab
1.2. Modify source SQL statement of Excel Pivot Table
1.3. Oqy Excel cube configuration file contents

2. Excel crosstabs and cubes solutions and examples

2.1. Excel olap cube example
2.2. Excel crosstab refresh