Monthly Archives: May 2017


Reporting In STRUMIS Part 2 – Snapshot BI & Web Reporting

Business Intelligence Reporting: To compliment the reporting capabilities that exist within STRUMIS today, Business Intelligence provides all the standard capabilities users expect including reports, ad-hoc analysis, scorecards, dashboards, and Key Performance Indicators (KPIs). The Business Intelligence dashboards allow none developers to access, design and create graphical representations of STRUMIS data as a Web based reporting tool without writing any code which can be viewed from any device that has web browser capabilities.

The advanced capabilities in Business Intelligence delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting you design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases like STRUMIS. It is designed to deliver higher level statistics of the business, for example Facility and Contract figures in comparison to the shop floor reports that are required in Production.

Business Intelligence reporting utilises Microsoft SQL Server Analysis Services (SSAS) and its OLAP cube technology to allow fast analysis of data retrieval that can be found in multiple dimensional business domains. As the term implies data is stored in a three dimensional cube structure and it is because of this cube structure that vast amounts of data can be retrieved relatively faster than traditional reporting techniques.

This is where the term Snapshot is introduced. OLAP cube data retrieval is optimised because it is working on a snapshot of the database it is connected to, i.e. STRUMIS. Usually Business Intelligence applications are setup to take a snapshot of data nightly which will be reported on in the following day’s KPIs, dashboards & reports. Because of this you will never be reporting real-time on data stored within STRUMIS at that time. Real time reporting will remain in STRUMIS as it is today by running SQL reporting procedures and the Active Reports designer until it is replaced by SQL Server Reporting Services (SSRS) in the new Web based service architecture version of STRUMIS.

SQL Server Reporting Services (SSRS): is a Web based reporting tool which will complement the new Service Oriented Architecture. SSRS is a server-based reporting platform that allows us to create and manage a wide variety of different types of report, and deliver them in a range of formats. We can create basic reports containing tables and graphs, or more complex data visualisations, using charts and maps.

The new service architecture of STRUMIS will communicate with the STRUMIS database via Web service calls. All new reports written in STRUMIS using SSRS will also be accessible via Web service calls in the same way allowing them to be viewed from any device that has web browser capabilities. This reporting capability differs from Business intelligence because they will be real time and pull live data from within STRUMIS and over time will replace all the existing reports ran from within STRUMIS.

To see how real time reporting and live data can help you to save time and money visit


5 Reasons to visit IPS 2017

With the countdown to the IPS well on the way, we are reflecting on the reasons why it’s an event you should not miss.

International Partners -In- Steel, 16th-19th May 2017.



With this motto the IPS opens its doors in Lörrach 2017 for the 11th time. We invite you to take part when the KALTENBACH Group present itself together with numerous partner companies. Don’t miss this event of the steel sector!


1/ Education

The IPS has practically oriented seminars as well as exclusive excursions that will inform visitors about the latest state-of-the-art technology. In addition, the technologies and trends for tomorrow can also be seen.


2/ Innovation

The IPS showcases the latest innovations in the industry with unique demonstrations of the latest processing technologies.


3/ Networking

IPS 2017 is the market place for steel experts and presents an attractive support program which offers the chance for successful and effective networks:

  • Sheet metal, pipe, profile processing
  • Handling
  • Separating, cutting
  • Forming
  • Connect, welding, fastening
  • Surface treatment of metal sheets and profiles
  • Tools


4/ Stability

Convince yourself at the IPS 2017 with the stability of the company, including machinery, partnerships and international service presence.


The robust design of all KALTENBACH machines allows a long lifespan.


With over 20 partner representatives around the world and technology partnerships including STRUMIS (new: RSA and Zeman), KALTENBACH is showing an international presence.


KALTENBACH is celebrating its 130th anniversary in 2017 – a figure that speaks for itself today.


A close network of national and international service partners guarantee the immediate presence of a specialist on site.



STRUMIS are partnering with the IPS to demonstrate our unique world leading fabrication management information software which provides unrivalled features and benefits.

Suitable for every steel fabrication company; to minimise overheads and costs, maximise productivity and profitability; in every step of the steel fabrication process. With STRUMIS you can connect your business resources reducing time, cost and wastage for greater efficiencies, traceability and productivity.


To learn more about the IPS click here.

To see all of the benefits that STRUMIS can provide you click here.