first of use sql management studio query (no excel 2007 seems have problems):
with set [project period dates] { strtomember("[time].[date].&[" + [project].[parentproject].currentmember.properties("project start iso") + "]"): strtomember("[time].[date].&[" + [project].[parentproject].currentmember.properties("project end iso") + "]") } member [measures].[test] ([project period dates].count) select { [measures].[test] } on 0, nonempty ([project].[parentproject].members) dimension properties [project].[parentproject].[project duration], [project].[parentproject].[project start iso], [project].[parentproject].[project end iso] on 1 [mycube] ( [orgunit].[orgunit].&[448] ) this query delivers list of projects 3 properties , calculated member based upon calculated set. properties show right values, calculated member shows same: result of first project should calculated for.
i don't understand why, because msdn says:
the current member changes on hierarchy used on axis in query. therefore, current member on other hierarchies on same dimension not used on axis can change; behavior called 'auto-exists'.
they give examples calculated members, think should work calculated sets, have read query-based calculated sets dynamic nature. maybe can tell me if understood wrong or else problem here.
the named set computed once within query. why calculated member return same value.
you have remove named set query:
member [measures].[test] { strtomember("[time].[date].&[" + [project].[parentproject].currentmember.properties("project start iso") + "]"): strtomember("[time].[date].&[" + [project].[parentproject].currentmember.properties("project end iso") + "]") }.count 
Comments
Post a Comment