Re: Iterating over a set of members
- From: ScottC <scarmody@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Oct 2007 12:16:49 -0700
Still did not work for me.
On Oct 5, 11:13 pm, Deepak Puri <deepak_p...@xxxxxxxxxxxxxxx> wrote:
If you compare your query to the expression I posted, the pair of
parentheses you dropped might make a difference - you could check this
version to confirm:
SELECT
{[Measures].[Transactions],[Measures].[Volume],[Measures].[Fee]} on
COLUMNS,
GENERATE([Producer].[Producer].[Producer].MEMBERS,NonEmpty(([Producer].
[Producer].CurrentMember, TopCount( NonEmpty(([Borrower].[Borrower].
[Borrower].MEMBERS, [Trans Status Date].[Trans Status Date].
[Year].&[2007].&[Qtr 1 2007].&[Jan 2007]:[Trans Status Date].[Trans
Status Date].[Year].&[2007].&[Qtr 3
2007].&[Aug 2007])),10, [Measures].[Transactions])))) on ROWS
FROM [CF Clients]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdexhttp://www.developersdex.com***
.
- Follow-Ups:
- Re: Iterating over a set of members
- From: Deepak Puri
- Re: Iterating over a set of members
- References:
- Re: Iterating over a set of members
- From: ScottC
- Re: Iterating over a set of members
- From: Deepak Puri
- Re: Iterating over a set of members
- Prev by Date: Re: NonEmpty mdx don't works!!!
- Next by Date: Re: Automatic MOLAP questions
- Previous by thread: Re: Iterating over a set of members
- Next by thread: Re: Iterating over a set of members
- Index(es):
Relevant Pages
|