PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articlesThere is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses NON EMPTY (which all OLAP clients use by default), the server forces the measure with the SUM function to display empty. Steps to repro: Use the Analysis Services Tutorial cube (Lesson 10) which is included…
Read articleWith the official release of SQL Server 2008, Microsoft retired the RC0 Feature Pack and added the SQL Server 2008 Feature Pack, August 2008 page. Unfortunately, the Report Builder 2.0 link got dropped along the way. Microsoft is aware of this issue and is planning to add a release candidate page for Report Builder 2.0 feature pack available for download toward the end of August.…
Read articleA new week comes with new issues... I ran into an interesting issue today with Windows integrated security and SharePoint. I was troubleshooting an issue on a behalf of a Windows user that connects to an SSAS server. To repro the issue, I used the SharePoint "Sign in as a different user" feature. To facilitate testing, I decided to save the password in the standard…
Read articleMicrosoft released a Microsoft SQL Server 2008 Feature Pack, August 2008 page which includes a collection of stand-alone install packages that provide additional value for SQL Server 2008. Strangely, Report Builder 2.0 is excluded and nowhere to be found since the RC0 page has been taken offline. Update 8/7/2008: A RC for Report Builder 2.0 feature pack will be available for download toward the end…
Read articleToday, Microsoft announced that official release of SQL Server 2008. Build #10.0.1600.22 has been declared as a SQL Server RTM. SQL Server 2008 includes major enhancements to the Microsoft Business Intelligence Stack, some of which I have mentioned in my previous posts. Note that if you have Visual Studio 2008 on your machine, you must wait for a few more days to get the official release…
Read articleAn interesting question has pop up on the Katmai RS 2008 discussion list today about how to implement a "green bar" group-level report that alternates background color for all rows in a group instance instead of doing this for each row. I attach the report sample I posted. What makes it interesting is that it demonstrates report variables – a new feature in RS 2008.…
Read article
With risk to iterate the obvious, here is a lesson learned from the trenches: Scenario: You want to let external users browse an Analysis Services cube over the Internet. Setup: You have followed the steps in the Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003 article by Edward Melomed to set up Analysis Services for HTTP connectivity. Issue: Windows…
Read articleRobert Bruckner on the Reporting Services team has started a blog. Robert oversees several key areas of Reporting Services, including Report Definition Language (RDL), data processing, report processing, data visualization, and performance/scalability. Many of you have gotten help from Robert on the Reporting Services discussion lists to which he frequently contributes. So, this sure it's going to be a must-read blog as his first posts…
Read articleA quick update on my book Applied Microsoft SQL Server 2008 Reporting Services. I am happy to announce that the work on the manuscript is over and the manuscript RTM'd (released to manufacturing). The paper copy should be available on the reseller sites and brick and mortar stores around the publication date (August 15th). Expect the ebook version around that time as well. Of course,…
Read articleHere is an awesome tip courtesy to the Craig Guyer's I Command Thee blog. You probably know that Visual Studio supports project configurations. In BIDS 2008, you can automate report deployment with configurations. For example, the following command deploys the solution using the settings of the QA configuration. C:\>devenv "C:\Books\RS2008\Code\ch03\Reports\Reports.sln" /deploy QA This is especially useful when automating deployment to SharePoint because you need to…
Read article
