Google
 

Tuesday, August 26, 2008

Tips from Train the Trainer Sessions – Day 3

More nuggets:

  • You can use Associations in your model to clear data from a model using Full Replacement option.
  • Almost always use Scoped Replacement when running associations against a model.
  • Select False to validation will ignore unknown member data.
  • The record count shown for ‘deleting records’ with associations isn’t the actual record count, just the possible count.  So when you see 108 records deleted, there could be 108 possible combinations.
  • When dealing with loading hierarchies in SSIS, look at the H_ tables.
  • Always perform data manipulation in the staging database.  Never adjust the production database.
  • Associations has an exclamation point in the icon for Actions.  This doesn't mean anything.  Don’t worry about it.

 

  • Any user in a business role can be made the owner of a job and then they can run the job without being a modeler.   This does not include data movement jobs, where you need to be a data administrator.
  • Every night or on a scheduled basis, you can automatically run jobs to aggregate data up to summary info - balance sheet, income statement, currency translations.  All data in any currency. 

TechNet Forums

No comments: