Automation of Apexing

[frenk277]

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

[Darek]

You have a couple of choices: Cognos Macro, Visual Basic, VBS, CMD, MDL, ...

[frenk277]

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?

[Darek]

This information will have to be supplied externally.

[Kattrix]

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

[LSPENNER]

Alex -

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

Thanks.
Lisa

[Darek]

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.

[Opher]

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

[Darek]

Only if you are lucky to require just apexing ... Usually the requirements are more complex, expecially in a big org.