4 Replies Latest reply on Jul 24, 2014 8:02 AM by Kalyan Chukkapalli

# Estimating levels in the dimension hierarchy.

Hi,

I have created a time dimension hierarchy like this

Year > Quarter > Month > Week > Day.

When i perform the consistency check it's giving a warning like this

Dimension "OE"."TIMEDim" has defined inconsistent values in its levels' property 'Number of elements'.

Basically i could not understand the concept of "number of elements" at the logical level window.

Regards

CK.

• ###### 1. Re: Estimating levels in the dimension hierarchy.

Hi,

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!

• ###### 2. Re: Estimating levels in the dimension hierarchy.

HI,

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.

For eg:

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.

Regards,CK

• ###### 3. Re: Estimating levels in the dimension hierarchy.

Gurus,

Request you all pls respond to my query.

regards, CK

• ###### 4. Re: Estimating levels in the dimension hierarchy.

Hi Chandra,

Have a look at Nico's blog link to understand Number of Elements concept.

OBIEE - Configure Level Number of Elements in Dimensional Hierarchies | GerardNico.com (BI, OBIEE, OWB, DataWarehouse…

Mark it as Helpful/Correct, if it is.

Best Regards,

Kalyan Chukkapalli

http://123obi.com