November 12, 2012 at 3:20 am
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
ConstantInsurerProductN
ConstantInsurerProductN
ConstantInsurerProductN
ConstantInsurerProductN
ConstantInsurerProductN
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply