Hi Enrique,

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.

@info Thanks!

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!

Hi @einfante,

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.

Hi @info ,

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!