Calculated Time Periods Hierarchy
-
Please help me understand why I am getting the following error:
"A set has been detected that can't contain calculated members."
I have Attributes "Dates" and Hierarchies "Calendar" (YearID/QuarterId/MonthId/dtDate).
I've created Calculated Member a "Current Month" for the 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 message
at the same time I built a Named Set CurrentMonth and it works without any problems
CREATE SET CURRENTCUBE.[CurrentMonth]
AS StrToMember("[Dates].[Calendar].[Month Id].&[" + Format(now(), "yyyyMM") + "]");
- This topic was modified 1 year ago by ElviraD.
-
This is a predominately English speaking forum. Any chance of you posting the translation for all that instead of us having to run it through a translator?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply