I created a calculated measure called [Previous Year Percent Rejected]. I used the following expression:
(ParallelPeriod([Year],1,[Time].[Time Hierarchy].CurrentMember),[Measures].[Percent Rejected])
The syntax checks out fine. However, when I try to use the calculation, I get an error message -- with a #VALUE! in the column.
The error message reads " The parallel period expression expects a level expression for the argument. A hierarchy expression was used."
I tried many different variations but I'm always receiving the same message. Any suggestions?
David
If you're using AS 2005, the problem could be that there is also an attribute hierarchy associated with [Year]. So, you could try fully specifying the [Year] level, like:
(ParallelPeriod([Time].[Time Hierarchy].[Year],1,[Time].[Time Hierarchy].CurrentMember),[Measures].[Percent Rejected])
|||Thank you Deepak. Your solution fixed the problem.
David
No comments:
Post a Comment