IcCube - excluding members on schema level
<p>EDIT (copy&amp;paste errors):</p>

<p>I would like to use the time wizard dimension and having only dates being not in the future. But since I have to set an end date, which I obviusly would not like to change every day by hand, I would like to set this very high and remove afterwards all the members lying in the future. 
For this I tried to use the "Advanced" methods "Scripts" and "Perspectives". I would prefer the first, since it would make those members vanish and not only being invisible, but if there is no way of doing so, the second would be ok as well.</p>

<p>If I filter those dates in an MDX statement, everything works fine:</p>

<pre><code>filter([date].[date].[day].members, [date].CurrentMember.KEY &lt; now())
</code></pre>

<p>Using a Script I tried to Drop the members:</p>

<pre><code>DROP member filter([date].[date].[date].members, [date].[date].CurrentMember.KEY &gt; now())
</code></pre>

<p>and it gave me a syntax error: syntax error: unexpected statement '(' (OPEN_PAREN)</p>

<p>Trying to use a perspective</p>

<pre><code>-filter([date].[date].[day].members, [date].CurrentMember.KEY &gt; now())
</code></pre>

<p>told me: syntax error: unknown function/property 'KEY'</p>

<p>What do I have to do, to get rid of those dates? I would like to do this while loading the schema at the latest.</p>