COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Radhika on 28 Jan 2010 04:16:56 AM

Title: how can changes can be automated?
Post by: Radhika on 28 Jan 2010 04:16:56 AM
Hi All,

Can anyone let me know how to automate Process?

elist process: includes concatenation of cost centre + Cost centre description, removing inactive cost centres, elist review and view depth etc;

how to create a dcube based on above things?

Thanks,
Title: Re: how can elist changes can be automated?
Post by: craig_karr on 28 Jan 2010 06:26:03 AM
One easy way to do this is to create a hiearchiacal dlist with appropirate source, for example file, ODBC source or Cognos package. Save the import link and then this dlist can be updated rom its source by an Analyst macro. This dlist can also be saved as an e.list from the dlist menu and that step can also be automated by a macro. When saving the dlist as an elist, settings for view depth etc are automaically generated

So create the neccessary Analyst macro, create a contributor macro executing the analyst macro and schedule it and then you can have an updated elist whenever you like.