Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgandhi
Posting Yak Master
115 Posts |
 Posted - 2009-06-26 : 08:07:00
|
| Hi, i have the following filter on my report, it executes but takes over 1/2 hour to run and bring anything back. How can i speed this up. I am setting the default value and it should only bring back 13 rows. Please help meWITH MEMBER [Measures].[ParameterCaption] AS [User Session].[By Browser].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [User Session].[By Browser].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [User Session].[By Browser].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [User Session].[By Browser].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@VARProgramVARProgramByVAR, CONSTRAINED) ) ON COLUMNS FROM [Analytics]) |
|
|
cboss911
Starting Member
1 Post |
Posted - 2009-07-12 : 20:49:07
|
| Hi sgandhi, have you been able to solve the problem? I might be able to help, but would like to know if you have managed to solve it on your own? |
 |
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-07-13 : 07:13:17
|
quote:
Originally posted by cboss911
Hi sgandhi, have you been able to solve the problem? I might be able to help, but would like to know if you have managed to solve it on your own?
Hi, yes i solved the problem. Thank you |
|
|
|
|
|
|
MDX filter running Slow