Proper SSAS terminology related to dimensions, measures?

Question

Slowly but surely I'm beginning to understand the basic idea of an OLAP cube. Unfortunately, I'm a little confused on the wording used when talking about it.

For example, I have a physical table called DimPromotion that looks like this:

Which translates to this when Excel connects to the cube:

Let's say I want to add another row to DimPromotion called Touring-5000 Promotion and the fact table will have orders that fall under the promotion. I will eventually drag&drop this new dimension in Excel. Is it correct to say that I'm adding a new promotion dimension? Or what's the proper terminology for this specific action?

Also, in Excel there's an internet sales count of 13 for Touring-1000 Promotion and 58247 orders for No Discount. Is this a measure or measure group of a promotion dimension?

Answer 1

So your "DimPromotion" is a dimesnsion with "PromotionKey" as DimensionKey "EnglishPromotionName" as a Dimension Hierarchy(dont confuse it with user hierarchy. you will experience them soon if you havent already experienced them). If you add another value or row to your dimension you will be adding a new Hierarchy Member.

Now Lets consider a Fact Table that lists the count of sales and the amount of sales in two diffrent columns. Each of these column is a measure CountOfSales and AmountOfSales. Whereas since they both are from the same tables you say their MeasureGroup is same.

Edit