Hi Everyone, I am trying to put a where clause in the Cube calculation but not getting it to work.
Here is the actual calculation which works:
([DimTime].[TimeHierarchy].CurrentMember .Lag (1),[Measures].[Actual Hour])* 1.25
Now, I want to add a where clause to this calculation which looks something like this:
WHERE ([Company].[Department].CHILDREN -
Can anybody please advise? Thanks a lot in advance for your help guys.
View Complete Post