Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Tutorial: creating dashboards (Read 6108 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Tutorial: creating dashboards
26.02.07 at 07:53:48
 
Tutorial: creating dashboards
 
Using SQL*XL you can create Excel dashboards where you have attached cells to database values. In example that you can download below I have created a dashboard on the northwind database.  You can download this database as part of the test databases.
Back to top
« Last Edit: 26.02.07 at 07:59:16 by Gerrit-Jan Linker »  

dashboard_001.GIF

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Tutorial: creating dashboards
Reply #1 - 26.02.07 at 07:56:39
 
To download the Excel file please use this link:
Back to top
« Last Edit: 26.02.07 at 07:59:37 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Tutorial: creating dashboards
Reply #2 - 28.02.07 at 07:57:06
 
Another simpel dashboard: ora_sessions.xls. This dashboard shows the summary of the Oracle sessions. To effectively use this dashboard you need to force the recalculation of the worksheet functions. You can do that in a few ways.
 
Recalculation techniques:

  • First connect to the database, then open the dashboard worksheet. Excel will ask you whether you want the formulas to be recalculated.
  • Use the menu: SQL*XL, insert function, calculation, force calculate all  
  • Make a small macro that forces the functions to be recalculated. Use the following code:
    Code:
    Public Sub Recalculate
      Activesheet.Cells.Replace "=","="
    End Sub
     
    
    

Back to top
 

ora_session.JPG

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Tutorial: creating dashboards
Reply #3 - 28.02.07 at 07:58:14
 
Please download the ora_sessions.xls dashboard using the link below:
Back to top
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1