DMR stands for (DIMENSIONALY MODELED RELATIONAL)DATA To create a DMR model we need to create regular dimensions,measure dimensions.
Regular dimensions: These dimensions have hierarchies,levels,members. While creating these regular dimension we should assign A. Member captions B. Business key C. Member descriptions
Business key are usually the code for that particular query item.(say the query item is a product line then its business key would be product line code
and measure dimensions are nothing but the measure
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!