how to get the real boundary of "time" dimension of a subcube dynamically?
e.g.
CREATE SUBCUBE [SMS2005] AS
(
SELECT
(
[time].[date].[date].&[2007-01-01T00:00:00] : [time].[date].[date].&[2007-01-10T00:00:00]
)
ON COLUMNS
FROM [SMS2005]
)
go
I want to create a global measure that show the stocks on the boundaries of the subcube'range
(in this case , they are 2007-1-1 and 2007-1-10).
Whenever a different new subcube (focused on time dimension) is built,
this measure can behave differently based on the subcube.
To this problem ,
I think the key is that
how to get the real boundary of "time" dimension of the subcube dynamically
in the definition of the globally wanted measure.
Does anyone has a inspiration?
3x.
So eagerly for the answer.|||I wrote the following measure,but it does not work.
create calculated member
sms2005.measures.w as
([time].[date].[date].members.item(0) , [Measures].[stocks])
go
No comments:
Post a Comment