Page 1 of 1
}ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 22, 2023 11:48 am
by monkey97
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 process or any settings?
Thanks in advance
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 22, 2023 9:29 pm
by Wim Gielis
Yes, a simple TI process with the necessary loops. There are no builtin functions to give that information.
Re: }ClientGroups cube not in sync. with Cognos
Posted: Wed Aug 23, 2023 6:23 am
by monkey97
But how can i sync }ClientGroups with Cognos BI?
Pls let me any help for TI process code.
Re: }ClientGroups cube not in sync. with Cognos
Posted: Wed Aug 23, 2023 6:25 pm
by Wim Gielis
I haven’t done that, if at all possible.
Re: }ClientGroups cube not in sync. with Cognos
Posted: Fri Aug 25, 2023 7:38 am
by Elessar
Hi,
You need to to search client*group relationships in Cognos Content Store database.
Here is the tables list:
https://cogknowhow.com/t/cognos-content ... iption/906
Here is an example of SQL query:
https://www.ykud.com/blog/cognos/cognos ... ew-in-sql/
Re: }ClientGroups cube not in sync. with Cognos
Posted: Fri Aug 25, 2023 10:35 am
by monkey97
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?
Re: }ClientGroups cube not in sync. with Cognos
Posted: Sun Aug 27, 2023 3:56 pm
by ardi
Is the Client Groups membership defined in Cognos or in LDAP (Active Directory)? If it is in Active Directory, you can run some powershell script to extract the User/Group mappings. If they are defined in Cognos, then you can run a SQL against Cognos Content Store database tables ( as suggested by Elessar)
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 29, 2023 9:44 am
by monkey97
They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 29, 2023 10:02 am
by Wim Gielis
monkey97 wrote: ↑Tue Aug 29, 2023 9:44 am
They are defined in Cognos, but we haven't got "groups_unwrapped" table in our database... and similar neither.
Isn't it something that Yuri scripted in the SQL ?
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 29, 2023 12:18 pm
by monkey97
I tried this
https://www.ykud.com/blog/cognos/cognos ... ew-in-sql/ ms sql script. Only the mentioned table missing.
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Aug 29, 2023 2:18 pm
by Elessar
Are you sure you've copied the whole script?
As Wim said, it's declared in the beginning using WITH clause:
Code: Select all
with groups_unwrapped (parent_group_id, child_group_id, lvl)
as .....
Re: }ClientGroups cube not in sync. with Cognos
Posted: Tue Sep 05, 2023 4:16 am
by vovanenok
You can use the Cognos REST API to check the group members:
https://developer.ibm.com/apis/catalog/ ... up_members
Then you can implement relevant logic to perform tasks such as removing users in TM1.