19 10, 2015

Special spreadsheet functions for Jedox Web Reports

By |2016-12-09T11:42:36+00:00October 19th, 2015|Categories: How To|Tags: , , , , , , |

Besides Spreadsheet functions that are known from and work similar to Microsoft Excel, Jedox Web adds a set of unique helper functions that may come in handy when designing Jedox applications. Some of these, such as HIDEROW() / HIDECOLUMN(), or CURRENTUSER(), are probably pretty well-known. A couple of others are maybe not as prominent, but still can be quite useful

6 08, 2015

How a fashion retailer made planning and reporting more agile

By |2016-12-09T11:42:41+00:00August 6th, 2015|Categories: Customer Success|Tags: , , , , , |

Payless Shoes is the largest specialty family footwear retailer in the Western Hemisphere, offering a comprehensive range of everyday and special occasion shoes, including Champion and American Eagle. Payless operate over 4,400 stores in over 30 countries throughout 5 continents. Payless Shoes Australia operates 141 stores throughout Australia.   With Jedox, Payless Shoes Australia have transformed merchandise planning, daily sales

24 10, 2014

Managing Web Reporting – Part 2

By |2016-12-09T11:43:03+00:00October 24th, 2014|Categories: How To|Tags: , , , |

After being out in the wild for over 12 months, the Performance Dashboard has been one of the most popular posts on our blog. As it was originally written for in Jedox 5.0, we have updating it to reflect the latest functionality in 5.1 SR2. New Features Hits chart now using a Stock type chart, that allows zooming in to specific days

9 01, 2014

Application structure in Jedox Web: how to use application bundles

By |2016-12-09T11:43:34+00:00January 9th, 2014|Categories: How To|Tags: , , , |

In previous posts, I described that in order to make efficient use of hardware resources of the Server where Jedox Web is installed, you should attempt to limit both worksheet and workbook sizes. An application in Jedox Web will then most likely be comprised of several workbooks, potentially spread across various folders or even file groups. This may at first

25 11, 2013

Application structure in Jedox Web: memory usage

By |2016-12-09T11:43:38+00:00November 25th, 2013|Categories: How To|Tags: , , |

I previously described that it is recommended to not put too much data into a single worksheet, in order to make efficient use of the Jedox Web server's CPU resources and limit the scrolling necessities for the end user. Workbook size and memory usage So, a possible conclusion would be to just separate all the data from one sheet into

22 11, 2013

Application structure in Jedox Web: resource usage

By |2016-12-09T11:43:39+00:00November 22nd, 2013|Categories: How To|Tags: , , , |

You probably know it from working in Microsoft Excel: Spreadsheet files that contain 20, 30, or more worksheets, with thousands of rows of data. In Excel, this works (mostly) fine, as Excel was designed as a single-user desktop application, meaning that one user has all hardware resources of the given PC available. This way of designing spreadsheets also is so

15 11, 2013

Web Reporting with Dynaranges and Attribute Filters

By |2016-12-09T11:43:46+00:00November 15th, 2013|Categories: How To|Tags: , , |

On the Web, with Dynaranges, you can make your report length determined by how the user interacts with the report. Dynaranges allow you to specify a single row of data and then determine what happens to that row when the user interacts with it in report mode. It is a powerful Web component because you can create completely customised, dynamic