Hi,

does it possible to define and use a subcube inside a scope or into the
calculate statement?

I have a formula which is really excellent when I use a subcube (Select ....
from (Select ... from mycube))
My subcube definition identify some tuples which reached a particular
threshold value, and then return my measures against this subcube only:
select {[Measures].[Sales Amount]} on 0

, non empty [Calendar].[Month].month.members on 1



from (

select filter(nonempty(stores.[store].[store].members *

employees.[Full Name].[Full Name].members),

[Measures].[# of Sales]>5000 ) on 0 from [Sales]

where ([Promotions].[Promotion].&[1]) )

(its not the real query, but its like this one)


Now I want to use this formula into my cube definition to replace a measure
value.

Scope(measures.mymeasure)
.... some calculation here...
measure.[Special Sales] = ......
end scope;

si, can I create a play with a subcube in my scope?
Can I use a "Select" statement into my formula?

Thanks.

Jerome.