tag:blogger.com,1999:blog-5650243067310933543.post8932377499365218868..comments2024-03-21T05:34:12.449+01:00Comments on BI Future Blog: SSAS/SSRS/MDX : Cascading parameters and M2M dimensionsHennie de Nooijerhttp://www.blogger.com/profile/04946694074745643589noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5650243067310933543.post-73193543533268294132012-10-04T03:55:10.276+02:002012-10-04T03:55:10.276+02:00Hey Hannie,
Great tutorial! Very helpful, thanks....Hey Hannie,<br /><br />Great tutorial! Very helpful, thanks.<br /><br />As Razvan, I wonder what is your take on the default value for cascading parameters. There is a heaps of workarounds for SQL based reports but none for MDX. <br />Would be great to read your thoughts about it. <br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-77650864033874600502012-08-05T13:08:22.817+02:002012-08-05T13:08:22.817+02:00@s: Although the error sounds familiar it's di...@s: Although the error sounds familiar it's difficult to say what the cause is of error. I'm sorry i can't help you with this. I hope you already solved this issue by now ;-)<br /><br />@Anoniem: Bridge Location Department is a N:M relationsship between Location and department.<br /><br />@Charlotte: You're Welcome<br /><br />Greetz<br />@Hennie7863Hennie de Nooijerhttps://www.blogger.com/profile/04946694074745643589noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-10566826312756708032012-05-29T22:57:16.865+02:002012-05-29T22:57:16.865+02:00Thanks Hennie - this was a huge help on my project...Thanks Hennie - this was a huge help on my project!Charlottehttps://www.blogger.com/profile/07515907782681571894noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-76214877213429612882012-03-13T21:24:45.407+01:002012-03-13T21:24:45.407+01:00thask, what is Bridge Location Department????thask, what is Bridge Location Department????Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-70545376499749443352011-11-07T22:48:13.722+01:002011-11-07T22:48:13.722+01:00Hey Hennie,
Great reporting tutorials. Keep it up...Hey Hennie,<br /><br />Great reporting tutorials. Keep it up!<br />I wanted to ask you if you find a way to pass this issue regarding multiple cascading parameters.<br /> <br />https://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters<br /><br />Cheers,<br />RazvanRazvanhttps://www.blogger.com/profile/03675696189897591274noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-70308870313710197072011-11-04T19:59:26.914+01:002011-11-04T19:59:26.914+01:00Hi,
This is my query : WITH
MEMBER [Measures].[Pa...Hi,<br />This is my query : WITH <br />MEMBER [Measures].[ParameterCaption] AS IIF(IsEmpty([Measures].[Country_Name_And_Code]), null, [Geography].[State_Abbr].CURRENTMEMBER.MEMBER_CAPTION) <br />MEMBER [Measures].[ParameterValue] AS IIF(IsEmpty([Measures].[Country_Name_And_Code]), null,[Geography].[State_Abbr].CURRENTMEMBER.UNIQUENAME) <br />MEMBER [Measures].[ParameterLevel] AS IIF(IsEmpty([Measures].[Country_Name_And_Code]), null,[Geography].[State_Abbr].CURRENTMEMBER.LEVEL.ORDINAL )<br /><br />SELECT {[Measures].[ParameterCaption], <br /> [Measures].[ParameterValue], <br /> [Measures].[ParameterLevel]} ON COLUMNS , <br /> NONEMPTY([Geography].[State_Abbr].ALLMEMBERS,[Measures].[Country_Name_And_Code])<br />FROM ( <br /> SELECT ( STRTOSET(@SnapshotMPCIDetailPremiumRyearReinsuranceYear, CONSTRAINED) ) ON COLUMNS <br /> FROM [MPCI_Detail_Premium_Ryear]<br /> )<br /> <br />But When I run this I get an error: <br />Failed to parse the query to detect if it is MDX or DMX. (MDXQueryGenerator)<br /><br />Can you help me with this. Appreciate your help!!shttps://www.blogger.com/profile/05588926167474109892noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-74705797083957427532011-11-04T15:38:21.041+01:002011-11-04T15:38:21.041+01:00Deze reactie is verwijderd door de auteur.shttps://www.blogger.com/profile/05588926167474109892noreply@blogger.com