COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: frenk277 on 18 Jan 2006 04:51:42 pm

Title: Automation of Apexing
Post by: frenk277 on 18 Jan 2006 04:51:42 pm
Hi,

Could Apexing process be automated using scripts?
Don't know if this is feasible.
Does anybody done this? If yes, please describe this process.
Thank you for your help.

Alex
Title: Re: Automation of Apexing
Post by: Darek on 21 Jan 2006 12:23:01 am
You have a couple of choices: Cognos Macro, Visual Basic, VBS, CMD, MDL, ...
Title: Re: Automation of Apexing
Post by: frenk277 on 23 Jan 2006 09:52:06 am
Hi Darek,
How do you determine what new security must be? For example, my view has been secured for userclass A, B, C. Now userclass D must be able to see this view.
How script will know about this?
Title: Re: Automation of Apexing
Post by: Darek on 29 Jan 2006 04:56:34 pm
This information will have to be supplied externally.
Title: Re: Automation of Apexing
Post by: Kattrix on 28 Jun 2006 06:07:19 pm

FYI
The canned documentation for writing Cognos Script is really quite good - with a few really good examples. In fact, there is an example in there specifically for adding user classes to a cube and defining cube views.

However, as far as dynamically specifying views, if there's no technical logic to which users have which view criteria, you will have to maintain an external file to supply the script with this info (or tweak your script each time, but that is obviously not ideal).
Title: Re: Automation of Apexing
Post by: LSPENNER on 10 Jul 2006 11:38:32 pm

Alex -

Out of curiosity did you ever figure this out.  We are working on the same requirement for automating the apexing. 

Thanks.
Lisa
Title: Re: Automation of Apexing
Post by: Darek on 29 Nov 2006 10:52:06 am
There is a couple commercial solutions available, but most of the time they fall short of specific requirements. By know I've implemented several database driven solutions and they were all unique, meaning some were more complex then others.
Title: Re: Automation of Apexing
Post by: Opher on 05 Dec 2006 06:36:30 pm
You should be able to define a Cube Group which will return a cube for each Apexed category.  At that point if there were some sub-cubes you did not want to build, you can disable them.

Good luck,
Opher

Title: Re: Automation of Apexing
Post by: Darek on 05 Dec 2006 07:45:23 pm
Only if you are lucky to require just apexing ... Usually the requirements are more complex, expecially in a big org.