I have a calculated measure in my SSAS 2008 R2 cube, that I need to troubleshoot. When I browse this measure, it shows me #Value!  instead of a number. When I hover mouse over, it shows the error

"Current Year Dimension attribute was not found".

For totals cell it says "Current Period Dimension attribute was not found"

My Dashboard Time dimension has attributes with Name "Current Year" and "Current Period".

Copied below is the list of attributes that I have for time dimension:

<code>

<Attributes>
                <Attribute Id="Dim ID" />
                <Attribute Id="Current Period" />
                <Attribute Id="Current Qtr" />
                <Attribute Id="Current Year" />
                <Attribute Id="Period" />
              </Attributes>

</code

Copied below is the expression for my calculated measure:

<code>

'IIF([Dashboard Time].CurrentMember.Level.Name = "(All)", strtotuple("([Dashboard Time].[" + [Dashboard Time].[2005].Properties("Current Period") + "], [Measures].[Stat Unearned Premium])"),
IIF([Dashboard Time].CurrentMember.properties("Current Year") = [Dashboard Time].CurrentMember.Name or [Dashboard Time].CurrentMember.properties("Current Qtr") = [Dashboard Time].CurrentMember.Name, strtotuple("([Dashboard Time].[" + [Dashboard Time].CurrentMember.Properties("Current Period") + "], [Measures].[Stat Unearned Premium])"), IIF([Dashboard Time].CurrentMember.Level.Name="Month", [Measures].[Stat Unearned Premium], ([Measures].[Stat Unearned Premium],ClosingPeriod([Dashboard Time].[Month], [Dashboard Time].CurrentMember )))))'

</code>

Hi kvd123,

According to your description, you get some "attributes was not found" when you browser a calculated measure. Right?

In Analysis Services, this error is thrown when the attribute is not existing in the dimension. It's not related to the expression. Please re-process the dimension to check if all the attributes are processed properly. If the issue persists, please use T-SQL to query the dim table in the database to check the dim data.

If you have any question, please feel free to ask.

Regards,