How to Track Report Usage with the New Jedox Logs API

How to Track Report Usage with the New Jedox Logs API

by Jedox 4 Beginners2 Comments
Monitoring how your Jedox reports are used is one of the quickest ways to understand adoption, improve usability, and spot training needs. With the new Jedox Logs API, you can finally extract clean, structured data on which reports are opened, by whom, and when, all without digging through raw log files. In this beginner‑friendly guide, we’ll walk through how to capture report‑opening statistics and store them inside your Jedox database for analysis.Our goal is simple - Track report openings.For each date, list which user opened which report and how many times. To make this analysis possible, we prepare a small collection of dimensions: Day - Template User - via ETL Report - via ETL Counter (the number of times the report was opened) - Just simple dimension …and we store everything in a cube called: Report_Statistics You’ve already created these objects in your database — great! Now let’s look at how the Logs API helps us fill them automatically. Step 1: Getting Data from the Jedox Logs API The new...
Read More
Bookmarks in Jedox Reports

Bookmarks in Jedox Reports

by Jedox 4 BeginnersNo Comments
One of the common questions I hear from Jedox beginners is: “Can I save my current report selections and come back to them later?” Think of a sales manager who always wants to review: Region = DACH Version = Actual Year = 2025 Currency = EUR Setting these variables every single time quickly becomes annoying. This is where Bookmarks for variables come in. In this post, I’ll show you a simple, elegant solution to save and restore variable values in Jedox reports — using one dimension and a few report actions. No magic, no complex scripting. What Are Variable Bookmarks? A bookmark is a saved snapshot of variable selections in a report. Instead of asking users to remember or reselect combinations of: Year Version Region Product Scenario …we let them save these values once and reapply them later with one click. Typical questions solve: “Can I save my monthly reporting setup?” “Can different users have their own presets?” “Can I switch between scenarios quickly during a meeting?” The answer is yes, with a surprisingly simple model. The Core Idea (High Level) The solution is based...
Read More
How to create paging in Jedox?

How to create paging in Jedox?

by Jedox 4 BeginnersNo Comments
When crafting reports in Jedox, it's not uncommon to encounter scenarios where the large volume of rows becomes unwieldy. In such cases, the implementation of paging proves invaluable. Paging not only ensures a clear presentation of the table but also serves to optimize server resources during report access. In the example provided below, we illustrate a two-step approach to introduce a paging solution, leveraging the Jedox BikerBest database. Step 1: Create the Table of Elements The table, presented via Dyna-range, reveals an extensive list of elements that stretches to the bottom, posing navigation challenges. To address this, a subset of Dyna-range is strategically employed to showcase all base elements within the 'Product' dimension. Step 2: Limit the number of rows based on the variables and introduce paging It's common practice to incorporate external variables into the subset. StartPosition - > from which element we want to start [Inital 0]. NumberOfElements -> how many elements we want to see in the table [editable but set on 30 for...
Read More