Hi Guys,
I’m trying to build a report using Pulse, the idea is to have a data table that shows when a specific set of users access a specific set of workbooks (by name/wildcard).
We can certainly do this now within the pulse-server-state* index, but we are limited the up to 2 months.
Do you think you can extend the new variables, particularly:
- Product
- Workbook
- Worksheet
To the pulse-tm1-session-history index? Considering this table also has Committing count, running count, etc. and that by default it goes back up to two years, it’s a solid place to build this kind of usage reports.
Let me know your thoughts.
Cheers!
nico
@nbisurgi ,
pulse-server-state-* index is a monthly index, by default you’ll have only 2 months of historical data by default
pulse-tm1-session-history-* is a yearly index, by default you’ll have only 2 years of historical data by default.
tm1-session-history index already has field Context and Product, These fields are used to save the user sessions across different tm1 clients including websheet and workbook.
You can increase the historical period duration using the following properties in Pulse.cfg. Currently this is the default settings.
ElasticHistoricYears = 1
ElasticHistoricMonths = 1
ElasticHistoricDays = 3
Note: These parameter would affect pulse-opensearch performance which would require additional diskspace and jvm memory.
pulse-tm1-session-history index is already used by Pulse to generate the following report
- Reports/License Optimisation report
- Reports/User Analytics/User Sessions
License Optimisation Report already has product summary,
this report only summarize user session across tm1 instances. It doesn’t summarize the committing, running count.
There is already following dashboards in
which should provide the information your are looking for.
Would be good to know what additional information could be included in this reports that would be helpful ?
Cheers,
Johnson
Hi Johnson,
In our case the client wants to track a specific set of users (from their operations team) that have used a specific set of workbooks (wildcard) on the last 6 month-end closes.
Unless I create a formula on Opensearch to parse the Context variable in the tm1-session-history index, or use wildcards to the entire Context (which might be expensive) I don’t know how could I get that data. That’s why I thought about including these fields into the tm1-session-history for this case, but for multiple others, so it can be easily retrieved.
Let me know your suggestions.
Cheers!
