I was just about to write a blog about the new features in the Release Candidate (RC) build of Power View and I saw that Robert had written a great blog already. It's great to see the product coming along so nicely. Can't wait to be able to use multidimensional cubes as data sources! One feature that stirred a lot of excitement and deserves more…
Read articleThe public release of Microsoft SQL Server 2012 RC0 is now available.
Read articleMicrosoft just published the RC0 (release candidate) bits of PowerPivot for Excel SQL Server 2012. Kudos for Microsoft for making the RC bits public this time. Stay tuned for an announcement for the arrival of the SQL Server 2012 RC bits soon. The RC build is a feature-complete and stable build. This will be the last pre-release build until SQL Server 2012 officially ships next…
Read article
Well, rules have changed. As Jaime Tarquino from the SSRS team explained in his blog, "SQL Server 2012 Reporting Services SharePoint Integrated Mode", there is no rsreportserver.config file anymore moving to Reporting Services 2012 in SharePoint integration mode (there are no configuration changes with native mode). Instead, the configurations sections are now saved in the SharePoint configuration database. Problem: A customer plans to upgrade to…
Read article
MDXParameter is a nice little utility that captures MDX queries sent from SSRS reports and replaces parameter placeholders with the actual values. I've been using the excellent Darren Gosbell's Query Capture sample which is one of the first utilities I install when starting a new project. MDXParameter has a few more features that you might find appealing, including saving the queries in a database and…
Read article[View:https://prologika.com/CS/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/blog/5736.Product-Sales.rdl:550:0] Problem: How do we stop the maddening parameter refresh for reports that use SSAS cubes? As you've probably found, nothing seems to stop it and the Never Refresh option on the Advanced parameter properties is useless. Solution: Use the OLE DB provider for Analysis Services for the parameter queries, as shown in the attached report.
Read articleTo expand on my announcement about SQL Server 2012 editions, I welcome the new BI edition for the following reasons: The BI edition will include all BI features, including features that would previously require an enterprise edition, such as SSAS partitioning and semi-additive functions, as well as SSRS data-driven subscriptions. Therefore, from a functionality perspective, there will be no difference between BI and Enterprise editions as…
Read articleMicrosoft has spoken about SQL Server 2012 editions and licensing. We now have a brand new BI edition. http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx
Read article
