5
votes
4answers
400 views

How do you keep track of the meaning of your SQL fields?

The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data. I use SQL ...
2
votes
1answer
412 views

What should we include in SSAS cube design documentation?

What should we include in a SSAS cube design documentation? This is the initial phase of the document. I have included: data models, facts, dimensions, surrogate keys, hierarchies and levels ...
1
vote
0answers
474 views

Documenting SQL Server Analysis Services cubes [closed]

We are building SSAS solutions for a client and, obviously, they are keen to get some comprehensive documentation of the stuff we are delivering. For RDBMS projects I usually supply annotated ...