TM1 Forum

Hello, We're using PAW version 47, creating books etc... For some reason, after modifying a book / sheet on PAW (maybe too much ?) the zero suppression of some cube view just... don't work anymore even though the option is still on and worked before on the view. Recreating the book with the same exa...

Finally I have resolved my issue. I was putting an MDX on my approval subset and then passing this same subset as static in the prolog of my TI. Because of the way the TI works, it was conflicting and not working properly. I passed the second step (dynamic subset to static substep) in the epilog wit...

Welp, I guess my tests weren't good enough since what I implemented has multiple problems.
I'll continue to search how to correct my things and will update this post.

Maybe you can check this post : http://www.tm1forum.com/viewtopic.php?t=13434

I didn't know until I saw this post that it was possible to do an MDX using values of a cube as variables so I can't really help more than that sorry.

Okamasu

Hello, You could try it another way than using a MDX. You could for example in your export script get a view with these criterion : - Total Period - Region - Product - Total Customer - Total Account - Amount Excluding 0, keeping rules and consolidated results, for each result you multiply it with th...

Hello, I applied the method you told me and it seems to work. I just had one issue : I had to apply the new security on the contributor's application once after launching the script for the first time. When I tried my TI for the first time, the contributor told me that the dimension wasn't available...

Hello Again, I think i miss something somewhere but dunno what. I must confess i'm not really understanding well what the Cognos' script do. My script update perfectly fine the dimensions and the approval subset. I created rules for the security cubes so that I don't have to think about it. But the ...

Thank you again for your answers, i'll try some things and when I'm finished I'll put here my method.

Hello again,

I have another question on this subject, is it possible to create rules for the Contributor's security as you'd create rules for Perspective's security ?
I'm asking this since it is not possible to have dynamic approval subset for Contributor.

Thank you in advance !

Thank you very much babytiger, I will try it !

Elessar,

Thank you for your answer.

These are the links I saw before posting.
My question was about if it was possible to do the fifth step without using a "ExecuteCommand" to launch a .bat.

If it is really not possible I'll search a way to use the .bat

Hello, I'm a consultant working on a 10.2 Cognos TM1 application. (So I don't have access of the data folder or the batch or Cognos BI Portal) I have a Business process that I have to do frequently to create new elements in a dimension used in Contributor. So my current process is : 1. TI to create ...