Calculated Member for Time Periods Hierarchy

13 Views Asked by At

I need to create Calculated Member for "yesterday", "current month", "current year", but but I keep getting an error message

please help me figure out why I'm getting the following error:

"A set has been encountered that cannot contain calculated members."

I have Attributes "Dates" and Hierarchies "Calendar" (YearID/QuarterId/MonthId/dtDate)

enter image description here

I created Calculated Member "Current Month" for Parent hierarchy "Dates.Calendar.[all]"

enter image description here

CREATE MEMBER CURRENTCUBE.[Dates].[Calendar].[All].[Current Month]

AS StrToMember("[Dates].[Calendar].[Month Id].&[" + Format(now(), "yyyyMM") + "]"),

VISIBLE = 1 ;

I'm getting an error

at the same time I built Named Set CurrentMonth and it works without problems

CREATE SET CURRENTCUBE.[CurrentMonth]

AS StrToMember("[Dates].[Calendar].[Month Id].&[" + Format(now(), "yyyyMM") + "]");

it's important to me that there is a Calculated Member and not a Named Set

0

There are 0 best solutions below