May 17, 2017 at 8:24 am
While this query works, it doesn't work in the report because the report is looking Amanda P-D which doesn't exist. Does anyone have any solution for renaming back to Amanda D?
WITH MEMBER [Underwriting Facts].[Underwriter].[All].[Amanda P-D]
AS [Underwriting Facts].[Underwriter].&[Amanda D]+[Underwriting Facts].[Underwriter].&[Amanda P]
SELECT NON EMPTY { [Measures].[UW Submissions] } ON COLUMNS, NON EMPTY { ( [Underwriting Facts].[Underwriter].[Underwriter].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM (
SELECT ( { [Underwriting Facts].[Underwriter].&[Andrea W],
[Underwriting Facts].[Underwriter].&[Ann F],
[Underwriting Facts].[Underwriter].&[Aubrey S]
} ) ON COLUMNS,
ORDER ( { [Underwriting Facts].[Underwriter].[Underwriter] }, [Measures].[UW Submissions], ASC )
FROM [Submissions by Submission Date] )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
There is an exception to every rule, except this one...
May 18, 2017 at 12:22 pm
You're creating a member [Amanda P-D] that adds Amanda D and Amanda P., but then you don't use it in your query. Jut looking at this, it looks like your report brings back the submissions for Andrea W, Ann F and Aubrey S.
Am I guessing correctly?
What if you just add to your columns axis:
SELECT ( { [Underwriting Facts].[Underwriter].&[Andrea W],
[Underwriting Facts].[Underwriter].&[Ann F],
[Underwriting Facts].[Underwriter].&[Aubrey S],
[Underwriting Facts].[Underwriter].&[Amanda P-D]
} ) ON COLUMNS,
I'm just guessing here. I hope that sparks a thought on your part.
Good luck,
Rob
May 18, 2017 at 1:04 pm
Thanks, I'll give it a try.
There is an exception to every rule, except this one...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply