This paper looks at advanced design issues involved in mapping ER models to dimensional models. These include slowly changing dimensions, minidimensions, heterogenous star schemas and non-hierarchically structured data.