Viewing 15 posts - 46 through 60 (of 219 total)
Just to add, the degenerate key is generally the business key, such as an OrderId, that does not fit into a dimension and where creating a single dimension would make...
October 8, 2009 at 5:41 am
You're welcome. Not sure if you'll be going to PASS this year in Seattle but if you are, it's worth it to check out any seminars Brian Knight is...
September 30, 2009 at 1:42 pm
Yes, as long as you're not running your packages in 64-bit mode, but that's an issue with 2003 as well. My preference is to convert the Excel files to...
September 30, 2009 at 5:36 am
SSRS 2008 does not use the 2007 Excel rendering engine. You are still under the limit of 2003. You can export to CSV and then open in Excel....
September 29, 2009 at 3:38 pm
I don't think it's the size of the cache that's your issue but the amount of time it takes to load the cache for the lookup. For example, if...
September 23, 2009 at 10:05 am
It sounds like a lookup cache issue to me as well. Be aware, the lookup will load all rows from the table or SQL statement priot to the package....
September 23, 2009 at 9:04 am
If you're looking for the porject/solution files on the report server, you won't find them there unless the developer built them there. Only the RDL files (and data sources)...
September 22, 2009 at 11:02 am
I agree with Cris, do all your filtering and aggregations at the database. The only time I do it on the reportserver is if we need to show details...
August 21, 2009 at 6:19 am
Are you sure you're putting them in the details row? Group sections add aggregates and would cause the behavior in row counts you're experiencing. Can you post a...
August 20, 2009 at 6:16 am
Can you remove their access from the server and set the package up to run as a job?
August 18, 2009 at 7:06 am
To check if the packages are on the server, log into SSMS and open a connection choosing a Server Type of Integration services. Expand Stored Packages and both MSDB...
August 18, 2009 at 6:03 am
How big is the result set you're returning? In my experience, whenever the RsExecutionNotFound appears, the report server errored out and reset. Check the RS server logs and...
July 16, 2009 at 6:46 am
=SUM(iif((Fields!PersonID.Value, "Sales") = (Fields!PersonID.Value, "matrix1"), (Fields!SalesCount.Value, "Sales"), 0))
July 9, 2009 at 5:43 am
When you run it on the server and then export to PDF, does it look as it does when run from BIDS?
July 8, 2009 at 6:05 am
Viewing 15 posts - 46 through 60 (of 219 total)