Izdelava Ad-hoc analize

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.

 
1.  
2.  
3.  
4.  
5. Z uporabo "povleci in spusti" prestavimo željene meritve* s polja Polja v polje Meritve.







 
6.  
7.  
8.  
9.  
10. Z uporabo "povleci in spusti" prestavimo željene dimenzije** s polja Polja v polje Dimenzije.







 
11.  
12.  
13.  
14.  
15. Pritisnemo gumb Generiraj analizo.
     

* - meritve so polja, ki predstavljajo številčne vrednosti, kot na primer Količina, Vrednost, Debet, Kredit, Število zaposlenih itd.

** - dimenzije so polja, ki predstavljajo (večinoma) neštevilčne vrednosti oz. polja nad katerimi ne izvajamo računskih operacij, kot so Identi, Subjekti, Oddelki, Stroškovni nosilci, Datumi, Številke dokumentov, Konti itd.

V primeru SQL poizvedbe, ki ne vrne nobenega rezultata, bomo dobili sporočilo:

Na zavihku prikaz analize:

1. Razpremo Measures s prtiskom na znak +.


2. Z uporabo "povleci in spusti" prestavimo željene meritve na področje <Measure area> v vrtilni tabeli.


3. Z uporabo "povleci in spusti" prestavimo željene dimenzije na področje
   - <Row area> v vrtilni tabeli (dimenzije, ki jih želimo imeti v vrsticah), ali
   - <Column area> v vrtilni tabeli (dimenzije, ki jih želimo imeti v stolpcih), ali
   - <Page area> (dimenzije, ki jih bomo uporabili kot filtre oz. omejitvene parametre) v vrtilni tabeli.

Vodič po PANTHEON-u:

• Ad-hoc analize

Povezane teme:

• Ad-hoc analize