keys features
FOR USERS

With a self-service dashboard, you can:

 

    • Load what you need in real time
    • Drill down to connected datasets
    • Add/remove widgets or pages
    • Create objects with specific calculations
    • Publish your customized dashboard
    • Schedule it to generate Pdf / Excel / Csv reports and / or send emails
    • Enter data using forms

START MENU

Self-service dashboard are grouped into Start menu. They are visible to users according to business needs.

SPEED-DIAL

Speed dial is the fastest way to open a dashboard with one click. Each tabs contains a set of dashboards grouped by business logic.

LOAD

Load gives freedom to users to get the needed real-time data, based on multi-criteria selection, with param classified by origin of underlying datasets.

DASHBOARD

A Dashboard is like a document. It consist of a table of content, pages, widgets and real-time data from one or several datasets.

WIDGETS

Widgets displays data in many ways, such as KPI, List, Pivotlist, Chart, Map, Report, HTML. They can be added and pin on pages. Widget editor works with Drag and drop , to update or create custom objects. Optionnal widget toolbar is for data navigation.

SYNC WIDGETS

Sync widgets loads and displays connected data of the current selection. It is synchronized on the fly when the selection on main widget  changes. 

DRILL DOWN

Drill down shows all possible connected datasets  for selected item. Each connection is a dashboard you may open with a click.  Number of child elements are displayed.

SNAPSHOT

Snapshot display in a separate windows all the elements behind selected node/cell/chart. 

JAVASCRIPT

Javascript, the most popular language of the world, is used to define a calculated factor. Reference to other column is done with simple syntax: ${Fieldname}

REPORT

Report is a custom layout created with a visual designer. It’s available as widget, Pdf or it may be printed . Report can be produced on user demand or with a scheduled tasks.

EXPORT

Export data into xlsx, csv, json, pdf, on user demand or with a scheduled tasks. Export is controled by user permission.

FORMS

Forms are for data entry. It can be customized for any kind of business need, including constraints and data verification.

CUSTOMIZE

Self-service dashboard can be customized with Drag&Drop, widget’s editor, add/remove pages/widgets.

PUBLISH

Publish a customized dashboard with selected params and preferred layout for a group of users. Data will be loaded real-time according to saved params.

SCHEDULE

Schedule a task at extact time or periodically to generate either a pdf, xlsx, csv, json with or without sending mail.

ANYWHERE

Connect with Storm desktop or via Web / Tablet / Mobile, from anywhere, with a secure connection.

Keys features
FOR DEVELOPERS

Config creator:

 

    • Display database hierarchy as a tree!
    • Calculate all possible drill down
    • Let you select tables for drill down and code tables
    • Generate automatically user-customizable dashboards.
    • Datasets are created with optimized SQL queries.
    • Custom SQL code and objects are managed using dedicated editors.

CONFIG CREATOR

Config creator will generate dashboards, params, datasets, queries with joins, ready to be customized. A config is a set of XML files. Any versionning system may be used (SVN, GIT,..).

DATABASE DRILL DOWN

Database is represented as a tree. Just select top tables, drilldown and code tables. Missing foreign keys can be defined with Storm. Drilldown tree with keys is displayed prior to create a config.

CONSOLE

Run native SQL query and JavasScript with the Console. Log displays history of queries, database messages, warning and error . Query result are displayed in Tabs with database view and list view displaying formatted data.

DASHBOARD DESIGNER

Design default layout of self-service dahsboard by adding pages and widgets displaying current or connected dataset. Customize generated objects and create default objects for each widget.

REPORT DESIGNER

NCReportDesigner is a graphical tool to design report template. A report is made of header and footer, with possibilities of multiple groups with specific header, section and footer. Just add text, html text, variable, line, rectangle, ellipse, image, barcode, chart, table view and etc.. and print it when an expression is verified.

HTML WIDGET

Import, develop or use HTML widget provided by Storm. Use standard placeholder ${FieldName} combined with Javascript to procude any specific HTML5 layout.

QUERY

Query editor is for update native SQL source code, defining placeholder and macro. The compiler will build the query placing selected params according to placeholder. Scripting javascript, defining transposition or default expression will allow to tune the query result.

DATASET

A Dataset is populated by one or several queries, with one paramset per join table. Join queries are executed in a second step and merged in memory. Drilldown and Details screen with related links are defined. Script allow to define data transformation.

JAVASCRIPT

Javascript is also used for data transformation at query and dataset level. For exemple if we have to convert daily value of data into monthly value, with specific complex calculation that cannot be done with SQL. You can also use any external library.

FACTOR

Factor object define a column. It can be a database field, JS expression, concatenation of other factors, a constant, etc… Style, data type, code resolution, agregation for total line, date formatting with Y2K, dictionary for translation, and many options are defined.

DICTIONARY

For each language a dictionnary can be created. You may import all object alias and enter translation, or run a query, or input a text map, this to populate the dictionnary.

REPOSITORY

Repositories are objects folders. Custom objects can be saved and are visible according to user permissions.

Keys features
FOR ADMINISTRATORS

Administrator keeps Storm instances up and running, managing projects, connections to databases and users permissions, this without being a user nor a developer.

PROJECT

Project is a configuration selected by the user on login screen. It define core and business XML repositories,  root folder , IP / Port / SSL certificate for dataserver, global data refresh period, log alert, default options, locale settings and SMTP param.

DATABASE

Database object contains engine, driver, host and port,  DSN and schema. By default, user and password are provided by the user, be can be define here. Variables, missing primary and foreigns keys can be added. Drilldown, code tables and default column for code resolution are stored in this object

USER

A database user, a default user, or a user with the password managed by Storm can be created. Menus, persissions and access to repositories are defined. Startup query and user properties allow to manage any security policy.