Number of elements is distinct count of each column which we have in each level.
So Just keep that in mind and give number of level from top to bottom with the ascending order like in year 1, and quarter 4, month 12, week 52 and day 365.
and we can just keep 1->2>3>4 just to define level and that issue will pass through.
Before that, check that you have checked in time dimension and created chronological key in each level.
Hope it helps!
The dimension is checked with time dimension and created Chronological key. There is no problem with this.
I need clarity with number of elements with each logical level. I still unable to understand clearly. I will give two scenarios below, please clarify me with your answers.
Time dimension: Each logical level of dimension having only one column assigned. What is the number of elements at each logical level.
Logical level Calender YEAR and column assigned is YEAR
Calender Quarter and column assigned is Quarter
Calender Month and column assigned is Month
Calender Week and column assigned is Week
Calender Day and column assigned is Day. (DETAIL LEVEL)
What is the number of elements at each logical level in the above one.
Product Dimension: Each logical level is having only column assigned.
Eg: Logical level PRODUCT CATEGORY and column assigned is Product_category
PRODUCT SUB CATEGORY and column assigned is Product_sub_category
PRODUCT NAME and column assigned is Product_Name
PRODUCT ID and column assigned is Product_ID (Detail level)
What is the number of elements at each logical level in the above one also.
Please answer in the above two scenarios.
Have a look at Nico's blog link to understand Number of Elements concept.
Mark it as Helpful/Correct, if it is.