 |
| |
|
|
|
 |
|
|
Analysis Services
Jason Thomas posted on May 02, 2012 18:22
My company is awesome!!! Everyday that I go to work, I discover something new and exciting from the people around me and come back home thinking &ndas...
[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...]
Javier Guillen posted on March 30, 2011 09:53
How to re-enable the PowerPivot add-in in case Excel removes it from the ribbon
[Read the rest of this article...]
Javier Guillen posted on February 24, 2011 22:06
One of the interesting DAX Time Intelligence functions is the TOTALYTD, which can define a measure calculation over a year in a cumulative way.
The ...
[Read the rest of this article...]
Javier Guillen posted on February 12, 2011 21:32
When building PowerPivot-based custom reports, authors can use DAX measures on Cube formulas, just as they have been able to do with traditional SSAS OLAP measures. MDX can also be applied over Vertipaq dimension attributes in order to create custom sets that can be reused over the custom report.
[Read the rest of this article...]
William E. Pearson III posted on November 11, 2010 07:27
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 creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes.
[Read the rest of this article...]
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...]
Javier Guillen posted on December 19, 2010 22:59 
How to use multiple slicer selected values in an Excel cube formula
[Read the rest of this article...]
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...]
Javier Guillen posted on September 07, 2010 14:50
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 dimension hierarchies; however very customized Excel reports that leverage cube hierarchies can still be built using MDX enabled cube functions. This approach goes beyond the limiting nature of traditional pivot tables by enabling power users to transverse dimensions using custom formulas that are a mix of MDX with traditional Excel functionality.
[Read the rest of this article...]
William E. Pearson III posted on May 07, 2010 08:18
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 practice with the steps involved.
[Read the rest of this article...]
William E. Pearson III posted on July 05, 2010 20:10
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.
[Read the rest of this article...]
William E. Pearson III posted on May 12, 2010 10:58
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 introduce dimensions, and then focus upon property settings for Database Dimensions.
[Read the rest of this article...]
William E. Pearson III posted on April 13, 2010 13:50
Join Business Intelligence Architect Bill Pearson as he leads practice in employing the Usage-Based Optimization Wizard to fine tune our aggregation design based upon cube usage statistics.
[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 February 01, 2007 05:08
Microsoft's best performance doc for Analysis Services 2005. You need to read this!
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|