-
MDX Dynamic sets
Hi
I was wondering if anyone would have suggestions on how to solve the following mdx problem. I am trying to add a dynamic set in the Analysis Services form script but nothing happens. When I run the query below in Management Studio I get the expected results:
WITH DYNAMIC SET [test] AS
{STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].currentmember.PROPERTIES("Max Accident Year Development Month")) + "].lag(2)"):
STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].currentmember.PROPERTIES("Max Accident Year Development Month")) + "]")}
SELECT [test] ON 0
FROM [Cube]
WHERE ([Measures].[Value],[Accident Period].[Accident Year].&[2012]);
The code below does not work in the script view of BIDS.
CREATE DYNAMIC SET CURRENTCUBE.[Last 2 Accident Year Development Months]
AS
{STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].PROPERTIES("Max Accident Year Development Month")) + "].LAG(2)"):
STRTOMEMBER("[Accident Year Development Month].[Development Month Hierarchy].[Development Month].&[" + CSTR([Accident Period].[Accident Year].PROPERTIES("Max Accident Year Development Month")) + "]")}
;
I think the STRTOMEMBER function does not agree with the MDX properties string. Any suggestions would be greatly appreciated.
Thanks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|