MDX CALCULATED MEASURES

hello, please trying count set calculated measure, when set called directly in row , returns fast, when try count set calculated measure(so can slice dimension) query keeps running forever, please ideas.

the queries below

select
{} on 0,
nonempty
(
{([transaction].[rpc count].&[1],[transaction].[account id].[account id])}
,
{([account].[paymentstatus].&[0],[account].[account id].[account id])}
)  on 1

sax
------------------------------------------------
with
member
measures.lil
as
count(
//exists
nonempty
(
{([transaction].[rpc count].&[1],[transaction].[account id].[account id])}
,
{([account].[paymentstatus].&[0],[account].[account id].[account id])}
))
select
 {measures.lil}on 0
sax

thanks

hi i4qr1a,

in scenario, first query applies set of members on rows. second 1 count aggregation on set. however, since 2 sets use different hierarchies, supposed throw error below:

so can count number of members under same hierarchy.

regards,

---

simon hou
technet community support

SQL Server  >  SQL Server Analysis Services