Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1. What is handy about using named sets is that [...]
Archive for January, 2010
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)
Posted in PowerPivot, tagged DAX, Excel on January 31, 2010 | 6 Comments »
Reading your #PowerPivot Profiler trace
Posted in PowerPivot, tagged Troubleshooting on January 30, 2010 | 2 Comments »
To help troubleshoot your PowerPivot for Excel workbook, you can click on Settings within the PowerPivot selection in the Office Ribbon which will bring up the Support & Diagnostics tab within the PowerPivot Options & Diagnostics dialog. Click on the checkbox next to “Client tracing is enabled” and after opening the PowerPivot window, you will [...]
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)
Posted in PowerPivot, tagged DAX, Excel on January 28, 2010 | 6 Comments »
Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1. What is handy about using named sets is that [...]
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Posted in PowerPivot, tagged DAX, Excel on January 27, 2010 | 12 Comments »
Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set and create reports based on that. One approach is to create a rank function within PowerPivot as noted in a Rank function thread on the [...]
#PowerPivot Data Refresh SSRS Report
Posted in PowerPivot, tagged Data Refresh, SSRS on January 19, 2010 | 3 Comments »
As many of you already know, in order to figure out which workbooks had succeeded or failed execute in their data refresh, you need only to go the PowerPivot Management Dashboard (Central Administration > General Application Settings > PowerPivot Management Dashboard) in order to see the status of your data refresh as noted in the [...]
How do I get the menu options for individual reports within the #PowerPivot Gallery?
Posted in PowerPivot, tagged FAQ, SharePoint on January 15, 2010 | 1 Comment »
When you start playing with the PowerPivot Gallery, some of you will be enamored by the various views of the Silverlight control included as part of the PowerPivot Gallery – I know I was! But if I want to modify or view the properties of the individual report – how do I do this? Well, [...]
Pros/Cons of deploying #SSIS with the SQL engine server
Posted in Integration Services, tagged Configuration, Performance, Tuning on January 10, 2010 | 5 Comments »
I was asked a pretty good question recently on what are the pros and cons of deploying SQL Server Integration Services packages on the same server that has your SQL Engine Server as well. While we covered a lot in Top 10 SQL Server Integration Services Best Practices, we never really addressed this issue specifically [...]
The Great #PowerPivot FAQ is now accepting applications
Posted in PowerPivot, tagged FAQ on January 9, 2010 | Leave a Comment »
Just in case you didn’t already know from the tweets, I figured I’d also give a shout out (again) to the “Great PowerPivot FAQ” and note the fact that it is now accepting applications for moderators. To become a moderator – is it a trial by fire? Does one need to know how to unlock [...]
The Great PowerPivot FAQ!
Posted in PowerPivot, tagged Troubleshooting on January 6, 2010 | Leave a Comment »
Just in case you’re not already aware of this, some of great contributors to the PowerPivot community are now adding and moderating to the Great PowerPivot FAQ. Please check it out and email us your questions as well! Enjoy!
Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI
Posted in PowerPivot, tagged Excel, SharePoint, Troubleshooting on January 6, 2010 | 7 Comments »
When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file. This is different than uploading the file by using the SharePoint UI as the SharePoint UI uses a different mechanism via http to upload the [...]
Hadoop on Azure
Professional Microsoft PowerPivot for Excel and SharePoint
-
Recent Posts
-
Top Posts
- Update SharePoint 2010 Farm Credentials Tips
- SQL BI at Hadoop Summit = Awesomesauce!
- How to Connect Report Builder 3.0 to a SQL Server 2012 PowerPivot workbook
- SSIS global variables and execute process task
- Troubleshooting #PowerPivot Excel Services connectivity
- Failed to provision the SharePoint Central Administration Web Application
- MDX: Count number of dimension members
- Installing Hadoop on OSX Lion (10.7)
- Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
- Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Categories
Tags
Archives
- May 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- March 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- July 2009
- May 2009
- April 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- July 2008
- June 2008
- April 2008
- February 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- December 2006
- November 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- November 2005
- October 2005
- September 2005
- June 2005
@dennylee
- #SQLBI at @HadoopSummit = #Awesomesauce ! wp.me/pHDEa-gH #Hadoop #BigData #SSAS 8 hours ago
- “@HuffingtonPost: Self-help lessons from a two-year-old huff.to/LtzjJi” > yes, I shall do it! 1 day ago
- wow “@mpanzarino: “@asymco: Apple sells its inventory every 5 days. Second fastest only to McDonald's. asym.co/KQnooc” That's nuts.” 2 days ago
- Thank (not evict) our soldiers! “@nytimes: The Appraisal: Afghanistan Veteran Could Lose Home Over Service Dog nyti.ms/KK7Ruc” 2 days ago
- Get it! “@tom_e_white: It's out. #Hadoop: The Definitive Guide, 3rd Edition. oreil.ly/LXTfdT What's new: bit.ly/LXTiWY” 2 days ago
Copyright
