COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: sgan on 19 Jan 2010 04:04:10 PM

Title: D-list automation , update d-list automatically grab changes from source file
Post by: sgan on 19 Jan 2010 04:04:10 PM
How to maintain d-list dimensions automated in analyst .
ie automatically update d-list from a source ( txt or odbc ).

Title: Re: D-list automation , update d-list automatically grab changes from source file
Post by: craig_karr on 20 Jan 2010 02:05:26 AM
Well, it si simple. When you create your d-list you get a question if you want to use the source as import link. Answer yes and then create an Analyst macro which runs dlist update on the d-lists you want to update. Schedule the macro and then your'e done. Don't forget that in the case of ODBC you need a macro step that opens the ODBC connection before the d-list update step.