Calculated Time Periods Hierarchy

• ElviraD

  Old Hand

  Points: 331

  More actions

  December 13, 2023 at 1:45 pm

  #4345223

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

  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)

  

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

  

  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

  Thank you in advance

   

   

   

   

  • This topic was modified 1 year ago by  ElviraD.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  December 14, 2023 at 2:10 pm

  #4345922

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.