Info | ||||
---|---|---|---|---|
| If you are looking for
| |||
For more technical information and details please visit BI and reporting domainsthis page: Reporting & Domains |
Introduction
S-360 reports are tables with the possibility to display a simple chart on top.
The configuration screen will allow you to select the proper dataset (domain), apply filters and options (groupings, columns, etc.), and several export possibilities.
...
S-360 reports are grouped in three main kindstypes:
KINDTYPE | DESCRIPTION | NOTES |
---|---|---|
| Any pre-configured report in S-360 is labelled as standard (approx. 70, according to your vertical). | Included by default |
| When editing a standard S-360 report (using its specif domain-based filters and datasets) you create a custom report. |
|
| Reports specifically built to meet more complex needs. | Paid service (if feasibility analysis provides positive outcome). |
...
TYPE OF REPORT (Theme) | DOMAIN | DOMAIN DESCRIPTION | INFO (1 record = ) |
---|---|---|---|
Account follow up | Pending account and credit account follow-up | 1 financial transaction performed on the pending or credit account account of a given contact with information related to payment, operator, sales channel, etc. | |
List of payments | List of payments and refunds | 1 payment or 1 refund with info for about contact, date, amount and method of payment, status, operator .. | |
Voucher management | Voucher management | 1 voucher with info such as product, value, state, order, information on use (date, channel) ... | |
Attendance | Attendance | Attendance statistics | 1 operation/movement with info which product, ticket (if any), tariff, sales channel, geo area .. |
Availability | Product follow up | Product availability | Quota and availability of a product for a given contingent with info on quota, availability .. |
Room availability | Availability of seats in a given room | For a given performance, number of seats in a given seat cat., contingent with the quantity of sold, booked ... | |
Configuration | Product configuration | Configuration information summary | Specific report with tables summarizing the catalogue configuration |
Contact | Cultural history | Cultural history of a contact | 1 cultural contact of a given product on operation (sale or reserved.) with info about product, order ... |
Goods | Purchase diary | Purchase diary (by cultural institution) of a selection of goods | 1 order of purchase of merchandise item intended for a given location, with info on supplier quantity ... |
Stock status | Stock status of a selection of goods | State of the stocks of a certain goods in a certain location | |
Sales | Product revenue payment | Link between operation and payment | 1 sale or cancellation of a specific product on operation with also info on payment method |
List of invoices | List of invoices and payment tracking | 1 invoice with info about contact, invoice itself (e.g. amount, date, etc.), state ... | |
List of sales | Detailed information on sales | 1 sale, reservation o refund of a given product in given date with info e.g. order, advantage, contingent, amount .. | |
Product revenue | Number of sales and revenue | 1 sale or cancellation of a specific product with info about date, channel, tariff .. | |
Summary of fees | Revenue due to fees | Fees amount of a given type charged at the sale of a given product with a given validity date and tariff | |
Seats | List of seats | Detailed information on seats | 1 seat in a specific event/match, order, with info aboutposition, state, contact, price, etc. |
Tickets | Access control | Access control history | 1 electronic control performed on a ticket with information related to date, timetable, product, etc |
List of tickets | List of tickets | 1 ticket with information relating to contact, price, bar code, order etc. | |
Questionnaires | Answers to questionnaires | 1 answer to the questionnaire question connected to a ticket with info on contact, application, ticket .. | |
Visits | Guide planning | Guides availability | 1 availability or unavailability period of a guide with info like date, hour, day of the week of the period |
Visit planning | Visit planning | 1 visit on a given timeslot led by a given guide for a given group with info regarding theme and language, purchase, group info, etc. |
...
2 - Groupings: depending on the domain is it possible to set up to 5 possible groupings as the first 5 columns of the report. NB: it means giving up all the details per row that by nature cannot be added up (example: tariffs name).
NB Grouping allows you to have fewer rows, summing values that are quantities or amounts. It means giving up all the details per rows that by nature cannot be summed (like tariffs names), and sometimes resulting in a loss of columns.
→ If they are important values, you can set them directly as groupings (if available)
→ You may need to use different reports and/or external data manipulation
example: List of payment: Grouping payments makes 'Rate' column disappear.
...
4 - Saving:you can rename the report from here (Save as): be aware that if you "save as" the edit screen will stay on the report originally opened (not the new one just saved).
Results and export options
You can open the read-only screen of each report by clicking on GENERATE or double-clicking on its line. This screen will show only the filters/options ticked during the configuration.
Once generated, each standard and custom report will have:
...