MDX support owc

[michael v]

When I use this sentence in MDX sample application I get the desired
result - on account for 19 and another for 20.

But when doing the same in OWC both accounts are shown under each store -
how can I limit this as desired ?

/Michael


select
{[Measures].[Amount]} on columns,
non empty
{
(
[Store].[All Stores].[Canada].[BC].[Vancouver].[Store 19]
,[Account].[All Account].[Net Income].[Total Expense].[Lease]
)
,
([Store].[All Stores].[Canada].[BC].[Victoria].[Store 20]
,[Account].[All Account].[Net Income].[Total Expense].[Marketing]
)
}
on rows
from Budget
where [Time].[1998]