Home

Resources
       Articles
       Downloads
       Search Results
       Links
       Webcasts, Podcasts & Training
          MSVirtualLabs
          BIPodcasts
       MSDN Articles

Blogs
       Javier Guillen
          About Me
       John Hall
       William Pearson
       Wayne Snyder
       Jason Thomas

About Us
       Contact Us
       Advertise

My Account
       MSBICentral Login
You are here Resources  Articles Register Login
  Minimize
25 Latest Articles Current Articles | Archives | Search

Entries for 'John L. Hall'

09

Getting Maximum Row Size Exceeds Warning, How Close Are You To Running Out Of Space In The Row?

John L. Hall posted on March 09, 2011 15:05
How to determine the room you have left in a record to store more column data.

[Read the rest of this article...]

Posted in: SQL Server 2008, SQL Server 2008 R2, Blog
Actions: E-mail | Permalink | Comments (0) RSS comment feed | Kick it! | DZone it! | del.icio.us
13

Excel Against a SSAS Cube Slow: Performance Improvement Tips

John L. Hall posted on January 13, 2011 19:21
Applies to SSAS 2008 and Excel 2007. Also see this blog entry: OLAP Reporting with Excel 2007: Use Member Properties!! at http://blog.davyknuysen.be...

[Read the rest of this article...]

Posted in: Analysis Services, SSAS, MDX, Blog
Actions: E-mail | Permalink | Comments (0) RSS comment feed | Kick it! | DZone it! | del.icio.us
28

Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube

John L. Hall posted on October 28, 2010 16:21
Using Annotation Tables in SSAS to Show Last Processed Time and Latest Data Updates as a Measure in a Cube Annotation Tables and leveraging the fact ...

[Read the rest of this article...]

Posted in: SSAS
Actions: E-mail | Permalink | Comments (0) RSS comment feed | Kick it! | DZone it! | del.icio.us
02

Is TOAD faster than BIDS Query Builder?

John L. Hall posted on October 02, 2010 16:17
Is TOAD faster than BIDS Query Builder? I had a question from the client the other day that confused me at first so I thought it would be good to p...

[Read the rest of this article...]

Posted in: Reporting Services Development
Actions: E-mail | Permalink | Comments (1) RSS comment feed | Kick it! | DZone it! | del.icio.us
17

SSRS: Unexplained Warning “This field is missing from the returned result set from the data source” And Checking a Field for Null Exception

John L. Hall posted on September 17, 2010 16:13

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 column is the column is null for all the rows. You can use the IsMissing method of the field object and a vb function in your report to work around this problem.

[Read the rest of this article...]

Posted in: Analysis Services, Reporting Services Development, SQL Server 2008, SSAS
Actions: E-mail | Permalink | Comments (0) RSS comment feed | Kick it! | DZone it! | del.icio.us

LatestArticles Minimize
Changing Granularity of Leaf Level Calculations in SSAS Tabular by Jason Thomas

Finding Nearest Stores using SSRS Map Reports by Jason Thomas

Heat Maps for SSRS using Map Control by Jason Thomas

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 ...

Advertisement Minimize

Advertisement Minimize

Copyright 2004-2012 MSBICentral.com Terms Of Use Privacy Statement