Hi,
I have been given the job of creating a report that needs to be burst to some 200 UserClasses and I'd like to know if there's a simple way of populating the burst table I need to build. (There is no requirement to burst to email or an external directory)
Each UserClass is a project and there are a number of users assigned to each project, some to more than one project. I have created the project UserClasses in AccessManager (using SunOne LDAP) and populated them.
I now need to create a burst table. My understanding is that the burst table needs to have a column of project numbers and their appropriate CAMID values which can be found by looking at the UserClasses' search path in CognosConnection under tools>directory>Default>Root User Class>ProjectNNNNN where NNNNN is the project number
ProjNbr CAMID
------- ------------
12345 CAMID(“Default:r:authid=3609142184”)
12333 CAMID(“Default:r:authid=3609145673”)
In order to populate the full table I need to manually go in to each project and copy the search path and paste it into the list which is very tedious given the number of UserClasses I have.
I've gone through the Cognos KB and can't find anything about getting a list of UserClasses and CAMID values except by using the SDK which we don't have.
What I think I've determinied is that the CAMID() function will take a C8 role as an argument such as CAMID(":Everyone") but requires some cryptic number when dealing with the LDAP UserClasses as shown above.
I've also found a reference to an alternative syntax for determining the CAMID that I think works with Users but I'm not sure if it will work with UserClasses:
directory/namespace[@name="Default"]//account[@name="Administrator"]
So, does anyone know how to generate a list of AccessManager UserClasses with their search path i.e.
12333, CAMID(“Default:r:authid=3609145673”)
OR has anyone succesfully used the alternative syntax with LDAP UserClasses.
OR have I got this completely wrong and I should be taking a different approach to bursting
Thanks
I have been given the job of creating a report that needs to be burst to some 200 UserClasses and I'd like to know if there's a simple way of populating the burst table I need to build. (There is no requirement to burst to email or an external directory)
Each UserClass is a project and there are a number of users assigned to each project, some to more than one project. I have created the project UserClasses in AccessManager (using SunOne LDAP) and populated them.
I now need to create a burst table. My understanding is that the burst table needs to have a column of project numbers and their appropriate CAMID values which can be found by looking at the UserClasses' search path in CognosConnection under tools>directory>Default>Root User Class>ProjectNNNNN where NNNNN is the project number
ProjNbr CAMID
------- ------------
12345 CAMID(“Default:r:authid=3609142184”)
12333 CAMID(“Default:r:authid=3609145673”)
In order to populate the full table I need to manually go in to each project and copy the search path and paste it into the list which is very tedious given the number of UserClasses I have.
I've gone through the Cognos KB and can't find anything about getting a list of UserClasses and CAMID values except by using the SDK which we don't have.
What I think I've determinied is that the CAMID() function will take a C8 role as an argument such as CAMID(":Everyone") but requires some cryptic number when dealing with the LDAP UserClasses as shown above.
I've also found a reference to an alternative syntax for determining the CAMID that I think works with Users but I'm not sure if it will work with UserClasses:
directory/namespace[@name="Default"]//account[@name="Administrator"]
So, does anyone know how to generate a list of AccessManager UserClasses with their search path i.e.
12333, CAMID(“Default:r:authid=3609145673”)
OR has anyone succesfully used the alternative syntax with LDAP UserClasses.
OR have I got this completely wrong and I should be taking a different approach to bursting
Thanks