How To

How Tos, Tips & Tricks and Tutorials to become a Jedox Power User.

21 09, 2016

How to use Highcharts for creating extendable charts

By |2016-12-09T11:42:05+00:00September 21st, 2016|Categories: How To|Tags: , , , |

Jedox reports and charts give you a rich interactive experience to find relationships, with interactive visualizations to discover insight. For power users, there are smart ways to enhance those standard Jedox charts, especially if you want to edit the tooltip, or if you want to adjust the design of the diagram. For these scenarios you can use "Highcharts", which offer a

12 07, 2016

How to Use the Jedox Integrator to Schedule and Backup OLAP Data

By |2016-12-09T11:42:12+00:00July 12th, 2016|Categories: How To|Tags: , , , , |

As of Jedox 6.0 SR3, it is possible to use a Jedox Integrator Server Job of type Groovy to execute a backup of all OLAP databases. Such a job can then be scheduled and triggered on a regular basis to produce a backup of each database without the need to shutdown any of the services. For every database, a separate

6 06, 2016

Combining chart types and secondary axes in Jedox

By |2016-12-09T11:42:18+00:00June 6th, 2016|Categories: How To|Tags: , , , , |

Jedox charts are a great way to provide a quick overview of your data. Most of us have used graphs before and are familiar with the basic features. However, we all have struggled to create a graph that goes beyond standard. If you have multiple series, for example, you could consider changing chart types. The combination of different chart types

22 04, 2016

How to create two-tone charts with Jedox

By |2016-12-09T11:42:22+00:00April 22nd, 2016|Categories: How To|Tags: , , , |

Two-tone charts…and the challenges of managing multiple series: Dotted line…? One of our customers came with an interesting request: What if you change the graph to a dotted line where it changes from actuals to forecast? Jedox charts are a great way to provide a quick overview of your data. Most of us have used graphs before and are familiar

16 02, 2016

DynaRanges, cell references and conditional formatting

By |2018-03-08T11:33:02+00:00February 16th, 2016|Categories: How To|Tags: , , , |

DynaRanges constitute a dynamic area in a Jedox Web spreadsheet, allowing the user to build reports which dynamically and automatically adjust their layout to changing database contents. When viewing a spreadsheet which contains a DynaRange in Report Manager, the DynaRange is expanded in either horizontal or vertical direction. Each element in the source list of the DynaRange (for example, a

17 12, 2015

Applying user rights in Jedox (2): Model-based security

By |2016-12-09T11:42:34+00:00December 17th, 2015|Categories: How To|Tags: , , , , |

When designing a BI or CPM solution with Jedox we often deal with a wide variety of users with different roles and responsibilities in their business domain. The security structure should therefore mirror these roles and responsibilities in order to restrict the users, if necessary, in their accessibility of data and capability of data entry. In order to realize a