InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:27:20 GMT20http://www.sqlservercentral.com/Forums/Topic1383582-17-1.aspxHi,I'm a real newbie when it comes to writing MDX. I'm trying to build an ssrs report off a cube and so have used the query builder to build up the query i want to execute. I'd like to know how to select a string constant, if that's even possible...[code="sql"]SELECT NON EMPTY { [Measures].[Policy Count] } ON COLUMNS, NON EMPTY { ( [Insurer].[Insurer].[Insurer].ALLMEMBERS * [Product].[Product].[Product].ALLMEMBERS ) } ON ROWS FROM ( SELECT { [Time].[Year].&[2012] } ON COLUMNS FROM [MyCube] ) WHERE [Time].[Year].&[2012];[/code]I'd like the output to look something like this: PolicyCountConstant Insurer Product NConstant Insurer Product NConstant Insurer Product NConstant Insurer Product NConstant Insurer Product NThe query i've got so far returns the insurer, the product and the policy count but i can't seem to work out how to select the constant. Google doesn't seem to have come up trumps for me either. Hopefully this is going to be dead easy for someone to answer...Thanks,SimonMon, 12 Nov 2012 03:20:28 GMTs_osborne2