TM1/Cognos User Description

[bradohare]

Hi,

Currently in our environment we use Cognos for authentication within TM1. Up until recently, all user creation, authentication and user-to-group assignement was handled automatically by Cognos and TM1 interacting with each other. This also automatically handled user/client metadata population, specifically the }TM1_DefaultDisplayValue attribute that displayed at the top of the browser when logging into TM1Web.

Due to requirement changes we need to adjust our security model to use both Cognos and native TM1 security. Each night have have a set of tables that are getting refreshed and a subsequent TI job that runs that assigns users to half of their appropiate groups (the Cognos layer automatically handles the other half). My issue comes when I a new user is on-boarded into the system. The Cognos portion of the security is done automatically but I still need to maunally via TI assign the user to some groups. Because the user was just added their user ID doesn't exist in the }Clients dimension (i.e. they haven't logged in yet).

To remedy this I can add the user manually (by reading the aforemetioned tables) to the }Clients dimension and do the appropiate group assignments. This all works fine, however by manually adding the user, the user description defaults to the CAMID and their name isn't displayed when they login. Unfortunaly, the tables I reference don't have the user description so I can't set it when manually adding the user. In turn, any newly added user won't have their name displayed unless they happen to log in prior to this process running that adds them.

Is anyone aware of a way to "tell" TM1/Cognos to refresh the }TM1_DefaultDisplayValue or a way for TI to somehow pull this information from Cognos (we can't just set it manually)?

Thanks,
Brad

[jim wood]

Hey Brad,

Have you looked in to extracting the user information from the Cognos BI Content Manager DB? If I undertsand you right and the user details are in there you should be able to update the user dimension in the same way as any other??

Jim.

[bradohare]

Thanks Jim. I hadn't thought of that and that a good idea. However, client infastructure doesn't allow me to connect to application metadata databases/tables......