I have a Time dimension, defined as follows:

Time
Year
Season
Month

When it's used as a dimension in a cube, it works as expected. However,
when I attempt to use it in a YTD call in a calculated member, the cube
populates with '#ERR'.

The specific error essage I get is:
"
Unable to display cell properties
Formula error - specified level type not found across dimension- in the
PeriodsToDate function
An error occurred during attempt to get a cell value.
"

When the calculated member was created, the syntax was fine and no error
were encountered during the processing of the dimension. The cube that
used the calculated member processed with error as well. It's only when
I attempt to use that measure that the #ERR surfaces.

The fact table upon which the cube is based has no blank/missing values
for the column that the Time dimension 'links' to.

I need some assistance in getting this working.

thanks,
Brad

Brad wrote:
Correction on the error message. It should read as follows:
"
Unable to display cell properties
Formula error - required entity missing ("")
An error occurred during attempt to get a cell value.
"

Also, here is the actual calculated member definition:
sum(YTD(Time.CurrentMember), [Measures].[Net Dollars])

It is also possible that not all [Measures].[Net Dollar] members will
have a value.

thanks again,
b.

You should check the Time dimension (within the Dimension Editor) to make
sure that the Level Type (under the Advanced Tab) of each level is set up
properly, i.e., Years, Half-Years, Quarters, Months, ...


"Brad" wrote:

Art wrote:
Excellent suggestion. That's fixed the error condition at the cell
level. However, the 2ns level is 'Season', which does not categorize to
one of the choices in the Level Type list. For example, we currently
have 2 seasons per year, which matches to Half-Yearly,but starting in
January, we move to a 5 season Year. How does one set the Level Type to
account for this?

thanks again,
b.