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 |
|
narayanac
Starting Member
18 Posts |
 Posted - 2005-12-16 : 07:34:09
|
| Hi! I had deployed an MDX report into report server and I tried to create the New Subcription for that and i had manually clicked New Subsciption button and then i am getting subsciption page with various options. In that I tried to click the SELECT SUBSCRIPTION button. Then it is taking hell of time to open that page. Can any one explains me about reasons for it. Note: The other reports which i had placed in the same directory and connecting to the same server & cube are working fine. i am not facing this problem. Only for this report i am facing this type of problem.Thanks |
|
|
jhermiz
3564 Posts |
Posted - 2005-12-16 : 09:49:56
|
quote:
Originally posted by narayanac
Hi! I had deployed an MDX report into report server and I tried to create the New Subcription for that and i had manually clicked New Subsciption button and then i am getting subsciption page with various options. In that I tried to click the SELECT SUBSCRIPTION button. Then it is taking hell of time to open that page. Can any one explains me about reasons for it. Note: The other reports which i had placed in the same directory and connecting to the same server & cube are working fine. i am not facing this problem. Only for this report i am facing this type of problem.Thanks
What's the dataset behind the report? Run that data set (Sproc) inside of Query Analyzer and time it, run profile to see what its doing...how complicated is the report, did you try to recreate trhe report ?Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url] |
 |
|
|
narayanac
Starting Member
18 Posts |
Posted - 2005-12-18 : 06:59:24
|
| Hi Jon, Actually i am tring for the report to subscribe but not to generate. Will the Data in the dataset will also effect for the subscription also? If so please confirm me.Thanks |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-12-19 : 11:20:44
|
I am not understanding the question. A subscription does not pull data till the EVENT JOB Subscription is initiated.This is not done unless the Schedule of the Job has been hit. In addition, the subscription is sent.Data of course will change based on time and day of the subscription. The subscription can use a cached data set but be warned this can return old data. Otherwise the subscription will use its internal data set, make a request to the server via SELECT, render the report and send the contents.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
Taking time Whn i click the SELECT SUBSCIPTION