Re: Iterating over a set of members

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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***


.

Relevant Pages

  • Re: elongated double space
    ... I confess I'm with Herb on this one, ... UK English tends to favor "which" even for restrictive clauses, but it always sounds very stilted to me. ... > Microsoft MVP (Word) ... Several of my clients want two spaces after periods and the ...
    (microsoft.public.word.docmanagement)
  • Re: Time Service
    ... Microsoft MVP - Windows Security ... Can you recommend any other way i can get round this problem. ... synchronizing all of the clients PC times. ...
    (microsoft.public.windows.server.general)
  • Re: revised documents showing quotes and paratheses as small boxes
    ... Symbols font for these characters (though parentheses are not usually among ... >> Microsoft MVP ... >>> When my boss revises a document where I have quotes or parentheses, ... >>> document comes back to me for finalization, the quotes, etc. show up ...
    (microsoft.public.word.docmanagement)
  • Re: Any way to force users to log in manually?
    ... But as I understand it now, neither the users nor the clients are ... MCSE, CCEA, Microsoft MVP - Terminal Server ... TS troubleshooting: http://ts.veranoest.net ...
    (microsoft.public.windows.terminal_services)
  • Re: How do I auto-create a list of names listed throughout a Word
    ... Suzanne S. Barnhill ... > "Suzanne S. Barnhill" wrote: ... >> also listing the numbers of the pages where the clients are referenced. ... >> Microsoft MVP ...
    (microsoft.public.word.docmanagement)