Tag: reports

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...