Jedox Web Studio

Jedox Web Studio is a crucial component of the Jedox Suite, offering a comprehensive web-based platform for business intelligence (BI), performance management (xPM), and collaborative planning. It serves as the central interface for users to access, analyze, and share data-driven insights, leveraging the power of the Jedox Suite in a convenient and accessible web application.

Challenge

Functionality-wise, the application is designed to be a central place for two major types of users, each with their own set of features and capabilities:

• Designer: The designer role is tailored for users who are responsible for creating and customizing reports, dashboards, and data models. They have access to a wide range of design tools and features to build interactive and visually appealing reports that meet the specific needs of their organization.
  
  
• End-user: The end-user role is intended for users who consume reports and dashboards created by designers. They can interact with the data, drill down into details, and gain insights from the visualizations presented to them.

It is also a container for the majority of Jedox Suite modules, such as:

• Reports: The report viewer allows users to interact with reports and dashboards created by designers, providing a user-friendly interface for exploring data and gaining insights.
  
• Views: Users can create and customize views of data cubes, enabling them to focus on specific slices of data and analyze them in detail.
  
• File Management: Users can store and manage files, such as reports and other resources, in a centralized repository, making it easy to organize and share information.
  
• Modeler: The database modeler is an integral part of Jedox Web Studio, providing users with the tools to design, build, and manage multidimensional data models for analytical and planning applications.
  
• Data Integration: Jedox Suite supports data integration capabilities, allowing users to import data from external sources, transform it, and load it into the Jedox in-memory OLAP database for analysis.
  
• Scheduler: The Scheduler allows users to automate tasks, such as data imports, report generation, and data processing, saving time and improving efficiency.
  
• My Models: Users can access and manage their solution models, reports, and other resources in the My Models module, making it easy to find and work on their projects.
  
• Marketplace: The Marketplace provides access to pre-built solution models with templates, reports, and other resources that users can download and use in their own projects.
  
• Administration: Administrators can configure system settings, manage user roles, monitor user activity, and ensure that the platform is running smoothly.

File Management

Jedox Web Studio provides a centralized repository for storing and managing reports and other types of files. Users can organize their files into folders, share them with colleagues, and access them from any device with an internet connection.

Reports

The report viewer is a key feature of Jedox Web Studio that allows users to interact with reports and dashboards created by designers. It provides a user-friendly interface for exploring data, applying filters, and drilling down into details to gain deeper insights.

Administration

The Administration module of Jedox Web Studio is dedicated to managing users, groups and roles, connections, licenses, and other system settings. Administrators can monitor logs, users' sessions, performance and audit data.

Settings

The Settings module allows users to customize their Jedox Web Studio experience by adjusting preferences related to login page, start page shortcuts, notifications, collaboration, language, theme, experimental features and many more. It also exposes properties of pre-built and custom-made solution models.

Roles

The Roles module is where administrators can define user roles and permissions within Jedox Web Studio. By assigning roles to users, administrators can control access to specific features and functionalities, ensuring that sensitive data is protected.

Connections

The Connections module is where administrators can configure data connections to external data sources, such as databases, flat files, and so on. By setting up connections, users can import data into the Jedox in-memory OLAP database for analysis and reporting.

Profiler

The Request Profiler for the Jedox in-memory OLAP database provides detailed insights into specific value calculation requests. When activated, it compiles a history of requests for each user session. This data, which includes metadata about the calculations, is accessible in the Request Profiler panel located within the Performance module of Jedox Administration. Furthermore, for complex value calculations, the Request Profiler can create visualizations of prolonged calculations within the request list, displaying data such as the rules processed and the duration of each calculation.

Licenses

The Licenses module displays information about the licenses that are currently active in Jedox Suite. Administrators can view details such as the license type, expiration date, and the number of users allowed under each license.

Audit

The Audit module provides a comprehensive overview of user activity within Jedox Suite. The changes made to values in cube cells in the in-memory OLAP database can be tracked by enabling the Audit feature for specific cubes. The Audit modules displays a log of all changes made to cube cells, including the cell path, time of change, user, new value, and operation (splashing, copy, etc.).