Optime - forecasting & budgeting, master data management

Good business planning is a foundation of every succesful company. Planning system integrates data from different areas - sales, marketing, production, finance etc - thus creating an unified overview of the business. Combined with analysis of the past performance, a reliable view of the future business is designed, based on which focused action plan can be created. Good planning system is simple, flexible and reasonably priced. Optime is a simple and affordable planning application based on Microsoft SQL Server Analysis Services. Optime includes functions needed to manage and run Microsoft BI based data warehouse and planning solution.

Master data management - management of master data, rules etc. Simple creation and management of UI for relational tables
Planning - Planning & forecasting systems based on OLAP write-back functionality, takes advantage of OLAP functionality - all user rights, calculations etc defined in OLAP apply to planning data. Data is stored directly into data warehouse and is available in real time for reporting. Planning forms can be defined using MDX. Custom filters and variables allow effective management of large number of forms.
OLAP MDX script management - Enables management of MDX script calculations outside Visual Studio. Empower power users instead of IT.
Actions - Actions defined using SQL/XMLA/HTTP for managing and automating data warehouse management
API - REST API for advansed scenarios

Forecasting & budgeting

Effective forecasting & planning

It only takes a web browser to use the forecasting software. User access is controllable and administratable, allowing you to limit each user’s view to only what is applicable to them.The environment for data entry is similar to excel. The online form allows for data entry, copying, saving and ‘dragging’ similar to excel.

integration with Excel - Files can be simultaniously open in excel, where operations can be completed using the full functionality of the excel platform and then imported into the planning form.

Adding comments - Comments can be added to the data, which are accessible for reporting just like the data itself.

Centralized business logic and forms management - centralized planning logics (equations, distributions etc.), that can be managed through the application.

Forecasting & budgeting

Integration with Excel

Files can be opened in excel, more complex operations completed using the full functionality of the excel platform, and then promptly imported into the planning form.

Forecasting & budgeting

Adding comments

Comments can be added to the data, which are accessible for reporting just like the data itself.

Forecasting & budgeting

Centralized business logic and form management

Allows a user familiar with MDX to describe dynamic webforms in MS SQL Server Analysis Service cubes for planning data management. Variables can be used to change filters or elements in different webforms at the same time. For example changing the time period columns on all the forms when the planning period of the project changes.

Master data

Master Data Management

Quality of master data is a basis for a good managemnt information. Quickly declare UI for masterdata / rule /translation tables, apply rules and let businees users acces and manage data.

Master data

Excel integration

Use Excel for large lists, modify and add records.

Data warehouse administration

Data warehouse administration functions

Enable business users to start DW loads, models/cubes processing. Give access to log tables. Free IT from management inforamtion system administration

API

Integrate ERp and other systems through API, use Azure Logic Apps , Power Platform or other tools to build workflows and advanced integrations.

Billed Monthly

Billed Annually

Server

EUR 330 /Month

Server + 5 users

1 server
5 named users

Extra user

EUR 9.6 /Month

1 named extra user

Support contract

ask for a pricing!

User support
BUsiness consultation