SSAS Tips
If you have a diminision made up of 3 tables (i.e. normalized hierarchial data) make sure the wizard creates one diminsion, not 3.
If you have referential integrity problems, read this article.
If you have a diminision made up of 3 tables (i.e. normalized hierarchial data) make sure the wizard creates one diminsion, not 3.
If you have referential integrity problems, read this article.