TM1 Forum

Hi,

I have the following task, and i need your suggestion on the best approach:


1) I need to create a template where the users will be able to enter data (or modify) and save to the cube.The users will be accessing the template through TM1 web. (9.5v)

I have a cube named cube1 with 8 dimensions. One of the dimensions, say Product --> The elements of product are Prod1, prod2, prod3, prod4, prod5, prod6,....

And i have five user groups,.. user1, user2, user3, user4, user5

Each user group will have access (able to modify the data,..see #2 below) to a particular product (user1 will have access to prod1, user2 will have access to prod2,...user3 will have access to prod3 and prod4,....).

2) Also, i need all the users to get a notification when any data is changed in the cube. (need to notify - who changed, when the change was done, what is the change, and the previous value)

What would be the best approach to achieve this?


Thank you.

I will answer question 2, that is the more difficult one. Question 1 is nothing than setting up security, and let users for instance pick a product in the Product dimension, using a SUBNM.

You will need to add some kind of Scenario dimension. Let the users do input on scenario called 'Input' and let an action button (and TI process) copy data to a scenario called 'Final'.

You could then easily add sanity checks in the TI process. For instance, don't copy anything if certain cells are not filled in.

Also, at the moment of copying data, you can compare with the previous values (if any).

This could all be used to feed a notification to users: for instance an ASCIIOUTPUT to create a text file to a certain location, or an email notification through a separate TI process, create views for the users to check certain cells, ...

Hope this gives you ideas.

Wim

Thank you very much Wim, i will try it out.