Re: MDX Max function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

OK, I got this to work,

With Member measures.[max_sales] as 'Max(time.month.members, sales)'
Select {measures.[sales]} on Axis(0)
{Generate(location.branch.members, {TopCount(time.month.members, 1, measures.
[sales])} * {TopCount(Descendants(location.currentmember, location.branch), 1,
measures.[max_sales])})} on Axis(1)
>From tSales

Let me know if there's a better way.

Thanks
Paul

--
Message posted via http://www.sqlmonster.com
.

Relevant Pages

  • Re: spam
    ... AmericanSPAMMER.com Member ... Paul (We're too young to fall asleep) ... Prev by Date: ...
    (rec.photo.digital)
  • Re: A
    ... Paul wrote: ... >> axioms. ... you can talk about D as being a member of some ... Prev by Date: ...
    (comp.databases.theory)
  • Re: A
    ... >>Cantor's Paradox, ... a member of itself? ... Paul. ... Prev by Date: ...
    (comp.databases.theory)
  • Re: MDX Max function
    ... With Member measures.as ... >From tSales ... Deepak Puri ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)
  • Re: Maintaining a Group
    ... Paul, my misunderstanding. ... was hoping for a single-step script or automator to do the same thing. ... > members one by one "adding" the same group member again and looking to see ...
    (microsoft.public.mac.office.entourage)