Planning Analytics with Watson

HI, I would like to know if there is any feedback on any of the questions I raised in the May AMA For this month, I would like to know how you manage User Groups in TM1 via PAW i.e. How do you add a user to a security group without updating the }ClientGroups ...

Hi Morten It sounds like you are trying to EXEC the stored procedure. You cannot do that if you want to retrieve data from it. The stored procedure needs to end with a SELECT that returns data, and you need to SELECT * FROM the stored procedure ...

Hi Sumit, This document has very useful point on multiple hierarchy approach: Hierarchies: Guidelines and Proven Practices . The hierarchy functions should be explicitly used in order to avoid confusion between the objects. Best Regards, ------------------------------ ...

Hi, The "traditional" views don't allow for alternate hierarchies as you have highlighted. But you can use them within MDX views, which can be used in PAW, PAX and as a TI datasource. Thanks, Declan ------------------------------ Declan Rodger Technical ...

Hey I am trying to pull data from MS SQL table where there is security on 1 column. I have a stored procedure witch make med able to see the data in that column. I have seached for help, but cant seem to fin good guides for creating a TI proces that ...

Hi Everyone, We are working with alternate hierarchies in our PA model. While working with hierarchies we got to understand that currently available function don't allow the use of subsets created under alternate hierarchies with views. ViewSubsetAssign( ...