If you are unable to create a new account, please email support@bspsoftware.com

 

D-list automation , update d-list automatically grab changes from source file

Started by sgan, 19 Jan 2010 04:04:10 PM

Previous topic - Next topic

sgan

How to maintain d-list dimensions automated in analyst .
ie automatically update d-list from a source ( txt or odbc ).


craig_karr

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.