Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Selecting a constant using MDX Expand / Collapse
Author
Message
Posted Monday, November 12, 2012 3:20 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 711, Visits: 2,211
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




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1383582
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse