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-22 : 11:01:26
|
| Hi, when i try and add a new parameter to my report, and then preview the report, for some reason it gets hung. It doesnt do anything. I have 1 parameter there already and that is fine, in the query view when i add the filter and the query executes that is fine too, but when i try to preview the report it keeps getting stuck.Any ideas anyone. Please help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 11:09:43
|
| how long does query behind takes to execute?have you tried running this in query analyser? |
 |
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-06-22 : 11:11:20
|
| The results come up immediately in the query designer |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-06-22 : 11:12:52
|
| Here is the query if it helps SELECT NON EMPTY { [Measures].[Page Views Per Session] } ON COLUMNS, NON EMPTY { ([Time].[By Calendar Week].[Date].ALLMEMBERS * [VAR Program].[VAR Program By VAR].[VAR Program].ALLMEMBERS * [b2r User].[By Location].[B2R User].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@UserSessionByBrowser, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@VARProgramVARProgramByVAR, CONSTRAINED) ) ON COLUMNS FROM [B2R Analytics])) WHERE ( IIF( STRTOSET(@UserSessionByBrowser, CONSTRAINED).Count = 1, STRTOSET(@UserSessionByBrowser, CONSTRAINED), [User Session].[By Browser].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 12:08:39
|
| ah! never realised source was MDX. b/w whats the default value you pass for parameters? how much data does it return for parameter? were you trying using same parameter values in designer tab? |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-06-22 : 12:54:36
|
| It takes 01 seconds behind the scenes.It returns 217 rowsI am passing 'US' as the parameter valueBelow is the same query i have written to test in SQL. Just to give you can idea of what im trying to achieve. the default value for the first one works, but when i put add the second filter for the country it hangs. (As i said, this is just a sql script i wrote to see the results i should be getting) select b.value_added_reseller_id, c.the_date,d.b2r_user_country, sum(a.page_views)/count(a.b2r_session_key) from fact.b2r_session_statistics a, dim.value_added_reseller_program b, dim.time_by_day c,dim.b2r_user d where a.value_added_reseller_program_key = b.value_added_reseller_program_key and a.time_by_day_key = c.time_by_day_key and a.b2r_user_key = d.b2r_user_key and b.value_added_reseller_id = '1' -- this parameter works by itself and d.b2r_user_country = 'US' -- when i add this, it doesnt work group by b.value_added_reseller_id, c.the_date,d.b2r_user_country order by 2 |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-06-22 : 13:58:48
|
| Please help |
|
|
|
sgandhi
Posting Yak Master
115 Posts |
Posted - 2009-06-25 : 08:24:11
|
| Can anyone help with how to put multiple filters on the report. My report works with 1 filter, but when i add additional filters it hangs. Can someone please help |
|
|
|
|
|
|
|
|
Hangs when adding new parameter