template v5 october 12, 2012 1 copyright © 2012. infor. all rights reserved
TRANSCRIPT
![Page 1: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/1.jpg)
1Copyright © 2012. Infor. All Rights Reserved. www.infor.com
![Page 2: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/2.jpg)
2Copyright © 2012. Infor. All Rights Reserved. www.infor.comCopyright © 2012. Infor. All Rights Reserved. www.infor.com 2
Infor Query & Analysisfür
StarlightOliver Daring
Project Manager Professional Services
This document reflects the direction Infor may take with regard to the specific product(s) described in this document, all of which is subject to change by Infor in its sole discretion, with or without notice to you. This document is not a commitment to you in any way and you should not rely on this document or any of its content in making any decision. Infor is not committing to develop or deliver anything
described herein.
![Page 3: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/3.jpg)
3Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Topics
• Über Query & Analysis
• Wie verwendet man Query & Analysis mit Starlight
• Beispiel Reports
• Zusammenfassung
![Page 4: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/4.jpg)
4Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Was bedeutet Query & Analysis?
Query & Analysis - bedienerfreudliches Reporting und Analyse Tool:
• Echtzeit Starlight Daten
• Bedienerfreundlich und einfach zu lernen
• Bekannt und vertraut – integriert und angelehnt an Microsoft Excel®
• Installiert, konfiguriert und anwendbar in wenigen Tagen!
![Page 5: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/5.jpg)
5Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Was bedeutet das für Sie?Zugriff auf Ihre Starlight Daten
• Jede Kartei – Jedes Feld des Daten-Links
• Jedes Feld hinzufügbar
• Per Mausklick, “drag and drop” zur Feldauswahl
• Jedes Feld filtern und anzeigen
![Page 6: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/6.jpg)
6Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie funktioniert die Starlight-Integration?
Daten-Link
• Reservierungs-Daten
• Kartei-Daten
• Gruppen-Daten
• Finanz-Daten
• Statistik-Daten
![Page 7: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/7.jpg)
7Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Technische Voraussetzungen für Query & Analysis?
• ODBC (open database connectivity) Treiber• SQL Server
• Datenbank• Microsoft SQL Server
• Microsoft Excel (Integriert)• 2003, 2007, 2010
![Page 8: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/8.jpg)
8Copyright © 2012. Infor. All Rights Reserved. www.infor.comCopyright © 2012. Infor. All Rights Reserved. www.infor.com 8
Infor Query & Analysis für StarlightWie schreibt man einen Report?
![Page 9: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/9.jpg)
9Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 9
Infor Q&A Reiter & Klick “Anmelden”
![Page 10: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/10.jpg)
10Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 10
User ID und Password
![Page 11: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/11.jpg)
11Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 11
Funktionen zur Berichtserstellung
![Page 12: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/12.jpg)
12Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 12
Datenbank Table aus der Liste auswählen
![Page 13: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/13.jpg)
13Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 13
Filter setzen
Spalte auswählen und “ziehen”
![Page 14: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/14.jpg)
14Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 14
Report starten
![Page 15: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/15.jpg)
15Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 15
Layout Design im report Designer
![Page 16: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/16.jpg)
16Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Wie schreibt man einen Q&A Report
Copyright © 2011 Infor. All rights reserved. 16
![Page 17: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/17.jpg)
17Copyright © 2012. Infor. All Rights Reserved. www.infor.comCopyright © 2012. Infor. All Rights Reserved. www.infor.com 17
Infor Query & Analysis Beispiele
![Page 18: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/18.jpg)
18Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report – Stornierte Reservierungen
Copyright © 2011 Infor. All rights reserved. 18
![Page 19: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/19.jpg)
19Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report – Buchungs-Übersicht
Copyright © 2011 Infor. All rights reserved. 19
![Page 20: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/20.jpg)
20Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report – Preis-Code Statistik
Copyright © 2011 Infor. All rights reserved. 20
![Page 21: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/21.jpg)
21Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report – Firmen-Kartei Statistik
Copyright © 2011 Infor. All rights reserved. 21
![Page 22: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/22.jpg)
22Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report – Absagen (Turnaway)
Copyright © 2011 Infor. All rights reserved. 22
![Page 23: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/23.jpg)
23Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Report - Grafisch
Copyright © 2011 Infor. All rights reserved. 23
![Page 24: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/24.jpg)
24Copyright © 2012. Infor. All Rights Reserved. www.infor.com
Query & Analysis Starlight Zusammenfassung
• Sie können die Reports selbst nach Ihren Bedürfnissen erstellen
• Queries können gespeichert und jederzeit wieder aufgerufen werden
• Die Report-Ausgabe in Microsoft Excel® erlaubt weitere Darstellungs- und Filtermöglichkeiten
• Grafische Report-Anzeige
Q&A gibt Ihnen die Möglichkeit jegliche Datenanalyse zu starten!
![Page 25: Template v5 October 12, 2012 1 Copyright © 2012. Infor. All Rights Reserved](https://reader036.vdocuments.us/reader036/viewer/2022070310/55204d7c49795902118ccdae/html5/thumbnails/25.jpg)
25Copyright © 2012. Infor. All Rights Reserved. www.infor.com