 |
| |
|
|
|
 |
|
|
Entries for 'Wayne Snyder'
Wayne Snyder posted on May 26, 2011 10:25
You just upgraded to SSRS 2008 R2 and some reports are hanging up, while others seem to work fine. How do you debug for this, and what is the fix?
[Read the rest of this article...]
Wayne Snyder posted on May 26, 2011 08:55
You install or upgrade to SSRS 2008R2 Gold, and get the following error "SSRS SystemOverflowexception: Value was either too large or too small for an Int32". Here is what is going on....
[Read the rest of this article...]
Wayne Snyder posted on July 15, 2009 11:15
Data can be filtered in the database query, or at the client, or both. When you write SQL or MDX, you know what is filtered in the database, because you directly control the query. When your report uses a Report Model, you do NOT create the query, the report model does. You may not know where filtering occurs. Where filtering occurs does matter, as it can affect performance and the user experience.
[Read the rest of this article...]
Wayne Snyder posted on July 01, 2009 10:13 
Reporting Services Models garnered a lot of attention, and offer much promise, but the actual implementation falls short of being useful in many situations. The shortcomings I list below cause Reporting Services Models to be practically un-usable for me. Before you use Reporting Services Models, ensure the following problems do not cause you pain
[Read the rest of this article...]
Wayne Snyder posted on April 15, 2009 06:48
Ralph Kimball proposed a navigation bridge table circa 1998 to assist in the tra veral of hierarchies. The intention is to make it easy to traverse hierarchies and do sums and grouping using easy SQL. This article contains a small script which allows you to easily implement and test such a bridge table.
Updated to fix a bug in original version
[Read the rest of this article...]
Wayne Snyder posted on March 11, 2008 03:30
The purpose of this document is to provide some “best practices” guidance for designers and architects ODSs and Data Warehouses . This document will grow over time as we add your ideas and comments. A basic requirement for this ODS/Data Warehouse is that we expect to include data from other sources/applications and companies. We do not know currently who they are or what their requirements will be. We do know that their data types may not match our source systems, and that we should be able to tag each row with the source system which contributed the data.
[Read the rest of this article...]
Wayne Snyder posted on January 24, 2008 04:26
Setting the format of a text box can be very time consuming... Reporting Services does not have an easy place to go to look up all of the formatting expressions that can be used in the format property. This is simply a list of all of the formatting codes you can use - a useful tool.
[Read the rest of this article...]
Wayne Snyder posted on February 26, 2008 11:27
You should make a plan around how you are going to organize Data Sources, and what connection types you recommend at the very beginning of your adoption of SSRS. Otherwise, you may find you'll have some rework to do, which might be a pain if you have many reports and report writers to deal with.
[Read the rest of this article...]
Wayne Snyder posted on July 01, 2008 05:08
Many people get all tangled up in naming conventions. I have been tripped up by it also. But let me cut to the chase on naming. In the past many databases could only support object short object names. In SQL Server the length was 16 characters. IT came up with many rules, codes and abbreviations to keep the name short. This often led to cryptic names that made no sense to business. Prefixes, suffixes, class words – all part of this new language to allow short names. This is no longer required, since SQL Server allows 128 character names. The purpose of this standard is to eliminate the cryptic names. We are not encouraging the use of short or long names – the requirement is that business names be used.
[Read the rest of this article...]
Wayne Snyder posted on January 25, 2008 13:32
Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3.
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|
| |
|
|
LatestArticles
|
|
| Parameters for Analysis Services Reporting: Introduction, Pt. 3 by William Pearson | BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 3 of the article, we continue to get hands-on practice cr...
| | Parameters for Analysis Services Reporting: Introduction, Pt. 2 by William Pearson | BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 2 of the article, we continue to get hands-on practice cr...
| | Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube by John Hall |
| | Using Color in SSRS Charts by Melissa Coates | Effective data presentation techniques help users interpret information quickly and reliably. Layout, formatting, sizing, labeling, and other report elements may all be used to facilitate ...
| | Is TOAD faster than BIDS Query Builder? by John Hall |
| | SSRS: Unexplained Warning “This field is missing from the returned result set from the data source” And Checking a Field for Null Exception by John Hall | If you ever see the warning message “This field is missing from the returned result set form the data source” and get unexplained #Errors in columns on your report it may be from SSAS not returning a ...
| | Beyond Excel pivot tables: Leveraging cube formulas with MDX by Javier Guillen | PowerPivot and DAX are a powerful technologies, but there is still a good amount of work that can be done with traditional cube functions. In its current version, PowerPivot lacks the concept of ...
| | Learning MSSQL Server Analysis Services: Support Report Conditional Formatting in Analysis Services by William Pearson | Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution. BI Architect Bill Pearson leads hands-on practic...
| | Learning SQL Server Analysis Services: Attribute Discretization in Analysis Services 2008 R2: Introduction by William Pearson | Join BI Architect Bill Pearson as he introduces Attribute Discretization into his extended examination of the dimensional model within the integrated Microsoft Business Intelligence solution.
| | Learning SQL Server Analysis Services: Analysis Services 2008 R2 Dimensional Model: Dimensions, Part I by William Pearson | Business Intelligence Architect Bill Pearson launches a new subseries surrounding components of the SQL Server Analysis Services 2008 / 2008 R2 dimensional model. In this two-part article, we int...
|
|
|
|
|
|
|
| |
|