tag:blogger.com,1999:blog-3892348099407749444.post5347859244302330329..comments2017-04-02T16:36:54.623-07:00Comments on Blog BI Microsoft de Patrice Harel: Challenge MDX : Generate, TopCount et restriction sur un set... en 2005Patrice Harelhttp://www.blogger.com/profile/16287269246969578094noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3892348099407749444.post-15723781593212175602014-09-13T12:17:17.397-07:002014-09-13T12:17:17.397-07:00normalement avec cette raquette tu auras ta répons...normalement avec cette raquette tu auras ta réponse :) Anonymoushttps://www.blogger.com/profile/03546607782346789822noreply@blogger.comtag:blogger.com,1999:blog-3892348099407749444.post-16404978688470647872014-09-13T12:15:29.615-07:002014-09-13T12:15:29.615-07:00WITH SET [Top Product] AS
GENERATE(
[Geography].[...WITH SET [Top Product] AS <br />GENERATE(<br />[Geography].[Country].Members<br />,{[Geography].[Country].currentmember }<br />*TopCount(<br />[Product].[Product].Members<br />,5 <br />,[Measures].[Quantity] <br />)<br />)<br /><br />SELECT [Measures].[Quantity] ON 0,[Geography].[Country].Members<br />*[Product].[Brand].Member<br />*[Time].[Month].&[201304]<br />*[Top Product] ON 1<br />FROM [MyCube]<br />Anonymoushttps://www.blogger.com/profile/03546607782346789822noreply@blogger.comtag:blogger.com,1999:blog-3892348099407749444.post-77670596608491251552013-09-18T08:51:41.461-07:002013-09-18T08:51:41.461-07:00N'empêche, ça fait 5 mois que j'attends la...N'empêche, ça fait 5 mois que j'attends la réponse :pDavid Jouberthttps://www.blogger.com/profile/06412908356861134932noreply@blogger.com