Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 MDX partial sums using cross join Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, October 3, 2013 11:02 AM
 Forum Newbie Group: General Forum Members Last Login: Friday, September 9, 2016 5:50 PM Points: 2, Visits: 25
 Hi, I'm trying to using this MDX query to get partials sums by region, cities and projects (first image), but unfortunately I get this (second image).This is the right approach? How I can remove the red regions (second image)?Thanks in advance.WITHMEMBER [Measures].[PLAN] AS ([Dimension - Proyecciones].[Proyección].&[12],[Measures].[VPE - Escrituraciones])SELECT { [PLAN]} ON COLUMNS, NON EMPTY ( ( ( EXCEPT([Dimension - Proyectos].[Región - Alias].children,[Dimension - Proyectos].[Región - Alias].[All].UNKNOWNMEMBER) ,[Dimension - Proyectos].[Ciudad].members ) ,[Dimension - Proyectos].[Proyecto].members ) ) ON ROWS FROM [BIGS - vivienda]WHERE( [Dimension - Línea de Tiempo].[Calendario].[Mes].&[2.01309E3] --september, 2013 ) desired resultcurrent result with red regions that I'm trying to remove making simple things simple, making complex things possible
Post #1501280
 Posted Sunday, October 6, 2013 11:26 PM
 Ten Centuries Group: General Forum Members Last Login: Friday, September 2, 2016 4:43 AM Points: 1,069, Visits: 1,944
 try this:`SELECT MEASURES.DEFAULTMEMBER ON 0,NON EMPTY { GENERATE([Geography].[Country].[Country],[Product].[Category].ALLMEMBERS)*[Geography].[Country].[Country] } ON 1FROM [Adventure Works]` Regards/RaunakNow a member of LinkedinPlease visit the all new Performance Point Forum Please visit the all new Data Mining and Business Analytics Forum
Post #1501989

 Permissions