|
|
|
SSChasing Mays
      
Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 616,
Visits: 1,877
|
|
Hi,
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...
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]; I'd like the output to look something like this:
PolicyCount Constant Insurer Product N Constant Insurer Product N Constant Insurer Product N Constant Insurer Product N Constant Insurer Product N
The 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,
Simon
MCSA: SQL Server 2012 Follow me on Twitter: @WazzTheBadger LinkedIn Profile: Simon Osborne
|
|
|
|