The Kimball group has some templates.
http://www.kimballgroup.com/html/booksMDWTtools.html
See the download under "Chapter 2 — Designing the Business Process Dimensional Model" / "Dimensional modeling spreadsheet"
This spreadsheet has macros to generate DDL scripts, which you might not need, but you can see the kind of information they capture in their documentation.