What are the hierarchies of Member Dimension attribute MemberID in fitness retail centre dataware house for sales identify dimensions, map dimensions to data sources, and specifydimension hierarchies. For each dimension, you should identify its data sourcesand attributes in each data source. For hierarchical dimensions, you shouldindicate the levels from broad to narrow.