Izdelava Ad-hoc analize

Creating Ad-Hoc analysis

When window with Ad-Hoc analyses appears you can create your own analyses or edit exisiting one. In the upper section you first write name (has to be unique) and description of your analysis. Combobox beside name ia used to establish hierarchy of analysis.

Below you can start creating analysis by writing SQL statement that will extrtact data from database. Instead you can also use a tool that helps you create SQL statment without SQL knowledge. You can access this tool with right-click inside the SQL Query window.

When you finish writing SQL Query you can simply click on Fields and query will automatically update. Fields will show list of all feilds that were extracted with SQL Query. Afther that you have to appropriatelly distribute Fields either to Measures* or Dimensions** by drag and drop. With right click on Measure you can determine if you want to calculate SUM, AVG or COUNT for selected measure.

Once fields are sorted you can open Ad-Hoc analysis by clicking on button . This will also automatically save your analysis. If you want to return to SQL Query editor, you simply click button .

In Ad-Hoc panel you will first get empty panel with dimensions in top row (acCostDrv, acDept, acIdent) and measures below (anPrice anQty). Measures are automatically added to grid whereas you have to manually distribute Dimensions either to row or column (also with drag and drop). Your final result is grid with all data in it.

You can also add chart to your analysis by clicking button  for vertiacl chart or  for horizontal chart.

Another importan feature of Ad-Hoc panel is also filtering. If you click on filter button on Dimension you can select only desired values in analysis.

If you select filter on Measure you can limint values that you would like to see of apply filter ony ti specific level.

Ad-Hoc analyses can be limited with authorisations that can be defined in Authorisations tab. If you set permissions to None for analysis this means that it wont be visible in the menu. Consequentially it may happen that you have analysis in your database but menu is not visible due to authorisations.