}Stats cubes tools

[Wim Gielis]

Hi all,

Attached is a TI process I wrote to do 2 things:
- if pMode = 0, add elements and rules for the cube }StatsByCube
- if pMode = 1, export data from the cube }StatsByCube

Have a look in the TI process for more details.

With respect to exporting values, the idea is that a chore is run every hour. This export TI process will create a file in a custom folder in the TM1 logging directory (unless you specify your own file and folder).
Each file will have the data of the cube from the PAST hour, at minutes 0 / 5 / 10 / 15 / 20 / 25 / 30 / 35 / 40 / 45 / 50 / 55.
Like that, you can easily merge text files in the folder, over time, and use that combined file in an analysis in Excel (or similar) to show cube statistics over time. Or use Power Query in Excel to merge the files from a folder and let Excel do the heavy lifting for you. Or create a cube to store the values and a fancy dashboard in PAW for reporting/analysis.

The TI process is easily extendable to other }Stats cubes. You can decide to incorporate the 0 values or not.

Added benefits: interesting dates and times functions are used, and all in all, it's good to have a look at it.
It's probably better to have this export process running once an hour instead of once every 5 minutes (even though it's very quick and only treats data, no metadata and I use temporary subsets/views).

TECH_StatsByCube_additions.pro

(9.63 KiB) Downloaded 1202 times

Any remark, let me know. A 'thank you' is also appreciated but my experience is that this is seldom done.

[PavoGa]

Thanks!

[Wim Gielis]

You're welcome

[HighKeys]

Thats more then genuis! Got some time to try it, and love it! Thanks for sharing wim!

[Wim Gielis]

Thanks for the kind comment !