Author Topic: Automation of Apexing  (Read 2892 times)

Offline frenk277

  • Associate
  • **
  • Join Date: Sep 2005
  • Posts: 4
  • Forum Citizenship: +0/-0
Automation of Apexing
« 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

Darek

  • Guest
Re: Automation of Apexing
« Reply #1 on: 21 Jan 2006 12:23:01 am »
You have a couple of choices: Cognos Macro, Visual Basic, VBS, CMD, MDL, ...

Offline frenk277

  • Associate
  • **
  • Join Date: Sep 2005
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Automation of Apexing
« Reply #2 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?

Darek

  • Guest
Re: Automation of Apexing
« Reply #3 on: 29 Jan 2006 04:56:34 pm »
This information will have to be supplied externally.

Offline Kattrix

  • Full Member
  • ***
  • Join Date: Aug 2005
  • Posts: 10
  • Forum Citizenship: +1/-0
Re: Automation of Apexing
« Reply #4 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).

Offline LSPENNER

  • Associate
  • **
  • Join Date: Jun 2006
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Automation of Apexing
« Reply #5 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

Darek

  • Guest
Re: Automation of Apexing
« Reply #6 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.

Offline Opher

  • Full Member
  • ***
  • Join Date: Nov 2005
  • Posts: 41
  • Forum Citizenship: +2/-1
Re: Automation of Apexing
« Reply #7 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


Darek

  • Guest
Re: Automation of Apexing
« Reply #8 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.

 



       
Twittear