Viewing 15 posts - 166 through 180 (of 341 total)
But how many rows are being returned and it sounds like the aggregation is being performed in the table with grouping, so that will add some overhead. Look at...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 17, 2009 at 11:56 am
The big difference would be that everything is running on the single server and you are going through IIS with the Report Server. I would monitor the resources on...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 17, 2009 at 5:14 am
If everything is on the same server then most likely not a network related issue. How large is the dataset? Does the report generate quickly in BIDS, but...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 17, 2009 at 4:40 am
Probably need some more information in regards to this to offer more advice. Are you using all SQL Server 2005 components? What version (build) are all of the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 16, 2009 at 3:22 pm
You can look at minimizing the downtime or trying to eliminate it all together. When processing the cube you can look at only processing the changed data and using...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 16, 2009 at 5:30 am
Removing Report Models from Report Manager is no different from other objects like Reports and Data Sources. You can click on the Report Model and then Delete it or...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 14, 2009 at 5:23 am
Instead of using ISNULL I would recommend using COALESCE instead. This is an ANSI standard. You might need to verify that the values are actually NULL and not...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 10:12 am
Ok, you are entitled to your opinion and I looked at the product and I don't expect everyone to agree with everyone else. This is a potentially quick startup...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 6:07 am
From what I have heard it is a quick startup solution to implement analysis for business that do not have OLAP (like with Business Objects), but it is not a...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 5:37 am
Would need more information as to how your parameter is configured and what it is returning. If it is returning the customer key (unique identifier) then this is not...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 13, 2009 at 5:30 am
What is the data source accessing and where is it located in regards to the SSRS server? If you are using Windows Integrated security and the information you are...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 1, 2009 at 11:06 am
You will simply need to make sure you have the 64bit Oracle drivers installed on the server and on your workstation where you are doing your development the 32bit Oracle...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 1, 2009 at 4:11 am
If you simply want to reload the existing cube run a full process on the database to reload the entire thing or you can do a full process on the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 30, 2009 at 3:43 pm
You definitely need to use Format=Tabular in the connection string with the OLE DB source going against an SSAS source. I would highly recommend installing the latest service pack,...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 30, 2009 at 3:38 pm
Can you provide some more information in regards to the error that you are seeing? At what point in the package are you getting the error? If you...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 28, 2009 at 6:27 am
Viewing 15 posts - 166 through 180 (of 341 total)