}ClientGroups cube not in sync. with Cognos

monkey97 · Post by **monkey97** » Tue Aug 22, 2023 11:48 am

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

Wim Gielis · Post by **Wim Gielis** » Tue Aug 22, 2023 9:29 pm

Yes, a simple TI process with the necessary loops. There are no builtin functions to give that information.

monkey97 · Post by **monkey97** » Wed Aug 23, 2023 6:23 am

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

Wim Gielis · Post by **Wim Gielis** » Wed Aug 23, 2023 6:25 pm

I haven’t done that, if at all possible.

Elessar · Post by **Elessar** » Fri Aug 25, 2023 7:38 am

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/

monkey97 · Post by **monkey97** » Fri Aug 25, 2023 10:35 am

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?

ardi · Post by **ardi** » Sun Aug 27, 2023 3:56 pm

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)

monkey97 · Post by **monkey97** » 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.

Wim Gielis · Post by **Wim Gielis** » Tue Aug 29, 2023 10:02 am

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 ?

monkey97 · Post by **monkey97** » Tue Aug 29, 2023 12:18 pm

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

Elessar · Post by **Elessar** » Tue Aug 29, 2023 2:18 pm

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 .....

vovanenok · Post by **vovanenok** » Tue Sep 05, 2023 4:16 am

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.

TM1 Forum

}ClientGroups cube not in sync. with Cognos

}ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos

Re: }ClientGroups cube not in sync. with Cognos