January 21, 2015 at 3:27 am
Hi,
im having real issued at the moment. I am using my cube to create reports from in reporting Services. And publishing the report to the reports server but the data is slightly different on the reports server and in Reporting Services.
Now I had a workaround for this before which was to delete the data file in the background which usually resets things. So usually the reports server is showing the right information and I have to give Reporting Services a bit of a shove occasionally by deleteing this file.
This time it hasnt happened and its still showing different values. Its getting to the point where Im beginning to worry I cant assure people the data they are seeing is correct. has anyone else had any problems with this?
Debbie
January 21, 2015 at 4:33 am
When you deploy the report are you also building and deploying your shared datasets? Are you caching temporary copies of the report? Is the report set to always run with most recent data? Which version of your report is displaying the correct data (run the query in management studio to verify)?
January 21, 2015 at 4:42 am
PB_BI (1/21/2015)
When you deploy the report are you also building and deploying your shared datasets? Are you caching temporary copies of the report? Is the report set to always run with most recent data? Which version of your report is displaying the correct data (run the query in management studio to verify)?
I dont think Im using shared Data sets. the data sets are embedded in my reports. The DBA team set me up with the data source on the report server and I have never seen issues before.
the report is set to run with the most recent data. I would have to check which one is correct. I was assuming it was the one on the reports server.
January 21, 2015 at 4:47 am
Debbie Edwards (1/21/2015)
PB_BI (1/21/2015)
When you deploy the report are you also building and deploying your shared datasets? Are you caching temporary copies of the report? Is the report set to always run with most recent data? Which version of your report is displaying the correct data (run the query in management studio to verify)?I dont think Im using shared Data sets. the data sets are embedded in my reports. The DBA team set me up with the data source on the report server and I have never seen issues before.
the report is set to run with the most recent data. I would have to check which one is correct. I was assuming it was the one on the reports server.
If you are previewing your reports with a different data source that what is being used on your report server then that may explain the difference - this could be caused by a lot of things, role-based security being one of them. If when you deploy your report you are not deploying the data source then it might not match exactly (they could have set up a specific user account for the report server data source).
January 21, 2015 at 4:50 am
Im faily sure its the same data source. We did a lot of work making sure that all the reports work the same and reference the correct data source in Reporting Services.
ill check with the DBA team again I guess on this one. i think Ive run out of options on my end unfortunately. thanks for the help.
Debbie
January 23, 2015 at 6:28 am
Open SQL profiler,
start a new trace on the servers your query may be running against.
You can now run the reports and see which server they are hitting and what query they are executing.
Do the Live server last as a developer the less times you go near a production server the better. I have learnt the hard way that regardless of what you do the less time on live the better.
E
:w00t:
January 23, 2015 at 7:40 am
thank you. Ill get looking at that. i may have to get a bit of help from the DBA team but its defnitely a plan 🙂
Debbie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply