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 articlesQ: How to make the darn parameter drop-down list wider in HTMLViewer? HTMLViewer is the Report Manager control that displays the report when you view the report. A: HTMLViewer supports limited customization via a CSS stylesheet. Copy HTMLViewer.css to MyHTMLViewer.css in the same folder (Reporting Services\ReportServer\Styles). Note that the actual folder path varies between SQL Server versions. Add the following CSS style to MyHTMLViewer.css SELECT…
Read articleI happy to announce my book "Applied Microsoft Analysis Services 2005" is now available as an Adobe PDF e-book. The first retailer that Google Alerts reported to sell it is Diesel Ebooks. It should soon pop up on all popular ebook retailer sites, such as ebooks.com. The suggested retail price for the ebook version is set to $39.95, which is ten bucks cheaper than the…
Read article
I have to admit that my preoccupation with Reporting Services and Analysis Services don't leave me much bandwidth nowadays to tackle other Microsoft BI (far less third-party) offerings. One of the products I know I need to catch up is the planning component of PerformanceServer, formerly known as Biz#. Fortunately, Nick and Adrian followed up on their The Rational Guide To Planning with Microsoft Office…
Read articleFebruary CTP is out. It brings the much anticipated integration with Visual Studio 2008 and the new BIDS Report Designer. Download the February CTP here: http://www.microsoft.com/sql/2008/prodinfo/download.mspx Updated Books Online for February CTP are available here: http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en What's new in Reporting Services February CTP (compared to the previous November 2007 CTP): Support for Microsoft Word Rendering This allows users to render reports as Word documents that…
Read article
Enterprise Edition of Analysis Services 2005 and 2008 supports semi-additive functions, such as LastNonEmpty, LastChild, and so on, to facilitate working with semi-additive measures, such as account balances and inventory snapshots. For example, the screenshot below shows LastNonEmtpy in action. To demonstrate this, I added a Last Sales measure to the Internet Sales measure group in the Adventure Works cube and set its AggregationFunction property…
Read articleFrancois Ajenstat, Director of Product Management for Microsoft SQL Server, tells us that SQL Server 2008 will be released in Q3 2008 while Release Candidate (RC) is expected in Q2. The February 27th marketing launch date remains unchanged.
Read article
SharePoint always has a trick up its sleeve to surprise the innocent. I have to admit that I continue to be baffled by this technology. Not that I know too much about it, of course. But this thing is like the Pacific Ocean – web applications, site collections, sites, oh my. The further you go, the deeper it gets. Things that still escape my mind…
Read articleVisual Studio 2008 embraces the exciting new world of Windows Communication Foundation (WCF) for communicating with services. However, pitfalls await the unwary. I've recently tackled invoking the Reporting Services Web service with WCF and I want to share my findings. The Visual Studio Add Web Reference menu has been renamed to Add Service Reference to denote that WCF can communicate with much more than Web…
Read articleThe Microsoft CAT team has released a new whitepaper Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques. "Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services to resolve many-to-many queries. This…
Read articleAs he posted here, Brian Welcker (Group Program Manager of Reporting Services) is leaving the Reporting Services team and moving to the Microsoft Healthcare Solutions Group. Brian did so much to build and promote Reporting Services. SSRS wouldn't have been the same if it wasn't for Brian. The technical community (myself included) will surely miss him. Let's wish Brian good luck with his new career!
Read article
