IcCube - excluding members on schema level -
edit (copy&paste errors): i use time wizard dimension , having dates being not in future. since have set end date, obviusly not change every day hand, set high , remove afterwards members lying in future. tried use "advanced" methods "scripts" , "perspectives". prefer first, since make members vanish , not being invisible, if there no way of doing so, second ok well. if filter dates in mdx statement, works fine: filter([date].[date].[day].members, [date].currentmember.key < now()) using script tried drop members: drop member filter([date].[date].[date].members, [date].[date].currentmember.key > now()) and gave me syntax error: syntax error: unexpected statement '(' (open_paren) trying use perspective -filter([date].[date].[day].members, [date].currentmember.key > now()) told me: syntax error: unknown function/property 'key' what have do, rid of dates? while loading schema @ latest.