WITH
Member [Account Name].[No. Accounts]
AS
'COUNT(
crossjoin(
nonemptycrossjoin([Account Name].[Account Name].MEMBERS,
{[Measures].[Total Sold Products]},1),{[Measures].[Total Sales Amount]}),
Excludeempty)'
SELECT
{ [Account Name].[No. Accounts] } ON COLUMNS,

{[Transactions].[Transaction Type].Members} ON ROWS
FROM
[Total Revenue]


I get 0 results from this query. Can someone tell me why?

this formula could provide wrong results regarding some connectionstring
parameters.
try this first:
'COUNT(
crossjoin(
[Account Name].[Account Name].MEMBERS,
{[Measures].[Total Sales Amount]}),
Excludeempty)'

(remove the nonemptycrossjoin)

slower, but should always provide the right result


"SAM" <SAM (AT) discussions (DOT) microsoft.com> wrote

I was using the the suggested query and got the results. I was using the
nonemptycrossjoin to see if it helps with performance but I received zero
when in the Cube browser or MDX sample application.

"Jéjé" wrote:

Jeje,

Do you have any suggestions on how to improve the performance of this query?
It runs the same in AS2005.

"Jéjé" wrote:

in AS2005 you no longer need this formula!

the distinct count aggregation in AS2005 works fine in any combination
(simple and multiple filters, visuatotal works fine too)
so create a standard measure using the distinct count agggregation option
and its all!


"SAM" <SAM (AT) discussions (DOT) microsoft.com> wrote

ok thanks. I guess there is no hope for this in AS 2000?

I haven't tried adding a measure in the Fact table to count the number of
clients in AS 2000.

"Jéjé" wrote: