Search found 16 matches
- Wed Feb 28, 2024 9:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewConstruct on XBV view
- Replies: 1
- Views: 289
ViewConstruct on XBV view
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...
- Tue Feb 20, 2024 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CubeSecurity and ProcessSecurity
- Replies: 4
- Views: 1957
CubeSecurity and ProcessSecurity
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!
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!
- Thu Feb 15, 2024 8:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX dbrw formula overwrite value with vba
- Replies: 3
- Views: 764
Re: PAX dbrw formula overwrite value with vba
Thank you so much.
The solution was to turn Application.EnableEvents on and off.
The solution was to turn Application.EnableEvents on and off.
- Wed Feb 14, 2024 3:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel VBA, PAFX: make a cell static
- Replies: 6
- Views: 2369
Re: Excel VBA, PAFX: make a cell static
Has it been resolved since then?
- Wed Feb 14, 2024 2:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX dbrw formula overwrite value with vba
- Replies: 3
- Views: 764
PAX dbrw formula overwrite value with vba
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.
- Tue Aug 29, 2023 12:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1435
Re: }ClientGroups cube not in sync. with Cognos
I tried this https://www.ykud.com/blog/cognos/cognos ... ew-in-sql/ ms sql script. Only the mentioned table missing.
- Tue Aug 29, 2023 9:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1435
Re: }ClientGroups cube not in sync. with Cognos
They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.
- Fri Aug 25, 2023 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1435
Re: }ClientGroups cube not in sync. with Cognos
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?
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?
- Wed Aug 23, 2023 6:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos BI
- Replies: 3
- Views: 2506
Re: }ClientGroups cube not in sync. with Cognos BI
Have you found any solution to sync without clients log into web/architect?
- Wed Aug 23, 2023 6:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 917
Re: Cognos security group database
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.
- Wed Aug 23, 2023 6:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1435
Re: }ClientGroups cube not in sync. with Cognos
But how can i sync }ClientGroups with Cognos BI?
Pls let me any help for TI process code.
Pls let me any help for TI process code.
- Tue Aug 22, 2023 12:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos security group database
- Replies: 5
- Views: 917
Cognos security group database
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...
- Tue Aug 22, 2023 11:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1435
}ClientGroups cube not in sync. with Cognos
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 ...
- Wed May 24, 2023 7:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW interface appbar
- Replies: 6
- Views: 1012
Re: PAW interface appbar
Thank you!
I see that version 76 includes this feature, but how can I solve this problem in version 72?
I see that version 76 includes this feature, but how can I solve this problem in version 72?
- Tue May 23, 2023 9:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW interface appbar
- Replies: 6
- Views: 1012
Re: PAW interface appbar
2.0.72
- Mon May 22, 2023 11:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW interface appbar
- Replies: 6
- Views: 1012
PAW interface appbar
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
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