I've built a report monitor that helps us measure how people is interacting with the reports we have in Jedox. We would love to have the capabilities of splitting the usage by access type: whether a report was accessed via Jedox Web or Jedox Mobile App.

Do you know of any script, function or log trace that can retrieve that info?

Thanks!

Thanks again. I tried with that approach, but it seems the variables don't have time to initialize when writing on the cube, at least the first time I open the report in the current session. If I re-open the report, then the variables are already at their correct values and the cube gets updated.

Any thoughts on how to solve this in the first opening?

Thanks!

So far, i dont see the other way but seems like to be on the roadmap.

What you can do is to set them up in combo boxes and then hide them.

It make sense, however, when working with canvas, it forces me to create a custom variable (via combobox) with the formula "=CURRENTUSER()" and "=TODAY()". Do you know any way of "initialize" or create those variables withot the need of comboboxes?

Thanks!

Here’s the approach I would take:

First, I would create a cube with the following dimensions:

1. Reports
2. Date
3. Users (optional)

For each report, I’d set up a macro or an "on open" action that writes a value of 1 to the cube at specific coordinates corresponding to the report, date, and user. This data can then be used to generate a usability report.

Let me know if this makes sense to you.

I remember a couple of years ago there was a custom report that retrieved some "report usage metrics", such as:

- how many times a report had been accessed

- how many users accessed the report and how many times per user

Kind of an audit log for reports. Can we build something alike with the current tools?

Thanks!

I would do it this way but feel free to modify my idea:

1. I will create a parallel hierarchy for dates which will have suffix _AVG90 (Example: 2024-08-26_AVG90)
2. Go to Integrator and add two variables type groovy (today ${Today}: return new Date().format("yyyy-MM-dd") and 90 days prior ${Today-90} return (new Date()-90).format("yyyy-MM-dd"))
3. Create an extract from the desired cube and make filtering on dates accept.inAlphaRange
4. Make sure you include empty cells so avg can be more accurate. These empty cells will be presented as null which you can replace by zeros in Groovy Function by just writing "return _input1" and check Null Default.
5. Create a Table aggregation where input will be your day as a constant value ${Today}-AVG90 (meaning you would like to write a value to this cell)
6. In Measure choose #Value and make sure aggregation is AVG.
7. Write this back to the cell and schedule the job to run every day after midnight.

Tadaaaa

I recall using this functionality a few years but I've forgotten how to set it up now. I want to have a routine using palo.setdata that can load data held on multiple rows in a spreadsheet. I recall being able to use the command whereby it would cycle through the list until it reached the bottom and then it would stop. For the life of me I can't remember how to set it up. Any ideas?

Thanks

Gary

Example of CAGR formula: 

CAGR = (Final Value / Initial Value) ^ (1 / Number of Periods) - 1