The use of analysis is done mainly via the ribbon in excel. Individual features in the ribbon are enabled or disabled based on the type of data displayed and selected (Greyed out if disabled).
Description of the "Analysis" tab
| Group | Icon | Description |
|---|---|---|
|
| Insert Data source : Insert a query in the selected excel cell/sheet |
| Refresh All Reloads all the queries in the workbook |
| Group | Icon | Description |
|---|---|---|
|
| Undo Undo Last Step Analysis. |
| Ready Redo Last Step Analysis. |
| Group | Icon | Description |
|---|---|---|
|
| Prompt Enter values for Query parameters and variables |
| Filter Define filter criteria for data | |
| Sort – Sort data | |
| Hierarchy – Expansion level / Parent member positions | |
| Calculations – Ranking / Cumulation Add Dynamic calculation, Calculation, Advanced Calculation |
The best way to get IT support is to use the new
Service One Platform.