TM1 Forum

Hi! There are two types of view, vue and xbv. This is a simple example. I have two view. Named test1.vue and test2.xbv. If i use ViewExists command, these return 1 value, so these views EXIST. If i use ViewConstruct command, the test1.vue is precalculated and etc. but test2.xbv is not and i get erro...

Hi!

I have a user who has permissions to processes Y, but not to a cube named X.
The Y process has a cellputs('text','X cube','dim1','dim2') command that it can run, so it can essentially write a cube that it doesn't have rights to.
Is that OK? How could this be avoided?

Thanks in advance!

Thank you so much.
The solution was to turn Application.EnableEvents on and off.

Has it been resolved since then?

Hey! How can i use vba code to override the DBRW formulas? No matter how i try the DBRW formulas remain, they are not overwritten with the value. Overall, I would like to see the snapshot function in vba code form. https://qmetrix.com.sg/wp-content/uploads/2019/12/pax-snapshot-function.png Thanks.

I tried this https://www.ykud.com/blog/cognos/cognos ... ew-in-sql/ ms sql script. Only the mentioned table missing.

They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.

Hi!

Thanky you Ellesar!!! These are useful links.

I have got only one problem with it. We haven't got "groups_unwrapped" table in our database... and similar neither.

What is your opinion? Is it possible?

Have you found any solution to sync without clients log into web/architect?

We use it on TM1, it can delete clients from }Clients on TM1, but we have to delete them from Cognos BI security group too.

But how can i sync }ClientGroups with Cognos BI?
Pls let me any help for TI process code.

Hi all! We have got some security groups in cognos which sync with TM1. If we have to delete some people from groups, we have to solve it manually one by one. Where can i find database of these groups? What is it stored in anyway and how can it be accessed? It is important, because if we get more th...

Hi all! If we delete clients from security group on cognos, then the }ClientGroups cube is only updated when they log into Application Web or Architect. We have to update it without clients login. We have to know, if there is anyone who is not in any group. Is there any solution for this? Scheduled ...

Thank you!
I see that version 76 includes this feature, but how can I solve this problem in version 72?

2.0.72

Hello!

How or where can i modify the interface of PAW's appbar?
In administration/customizations we haven't got 'theme' panel.
We need to change the color of application bar at the top of site.

Thanks