 |
| |
|
|
|
 |
|
|
Blog
Javier Guillen posted on September 10, 2011 21:03
PowerPivot currently has no programmatic interface, so there is really no automated way to leverage its capabilities (other than those provided by Pow...
[Read the rest of this article...]
Javier Guillen posted on July 12, 2011 23:14
Javier Guillen posted on July 08, 2011 23:48
Javier Guillen posted on July 03, 2011 22:49
How to calculate median over a PowerPivot measure
[Read the rest of this article...]
Javier Guillen posted on July 02, 2011 00:14
A common calculation required in business is moving averages. How can we create it in DAX? Lets walk through the calculation.
Imagine we have t...
[Read the rest of this article...]
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...]
Javier Guillen posted on May 01, 2011 16:13
Presentation slides for PASS VC webinar on PowerPivot and DAX
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:42
PowerPivot can be a really powerful tool for prototyping Business Intelligence projects.
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:34
I will be speaking tomorrow for the Professional Association for SQL Server (PASS) Business Intelligence Virtual Chapter; my topic will be...
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|
| |
|
|
LatestArticles
|
|
| 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 ...
|
|
|
|
|
|
|
| |
|