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 articlesRecently I got an interesting question about querying UDM many-to-many relationships. For example, in my book I demonstrated how you can implement an UDM model (Bank cube) that has a many-to-many relationship between bank customers and their accounts. That's because a customer could have more than one account and an account can belong to more than one customer (a joint account). But what if you want to find…
Read articleJust learned from the David Gainer's post, that Microsoft has made a decision to retire Office Web Components (OWC) in favor of Excel Services. This is definitely sad news for me. While I agree that Excel Services could fulfill some of the integration scenarios mentioned in the comments for that post, I can think of at least two scenarios where this won't be the case:…
Read articleDownload an updated version of the documentation and samples for Microsoft SQL Server 2005.
Read articleThese samplesThese samples will get you up and running with Microsoft Office Business Scorecard Manager 2005 utilizing the sample OLAP database provided with Microsoft SQL Server and Analysis Services 2005 called AdventureWorks DW. The purpose of the AdventureWorks DW database is to provide a sample database for exploring the possibilities of OLAP. will get you up and running with Microsoft Office Business Scorecard Manager 2005…
Read articleSometimes, you may need to swap the RS catalog database. For example, you may need to clone the catalog database from a production machine to troubleshoot an issue. One way to do so is to replicate the report items (report definitions, data sources, images, etc.). Another, and perhaps faster, way is to copy the report catalog database and redirect the Report Server temporarily to the new catalog by…
Read articleMany, many apologies if you have received tons of e-mail from me (Prologika) during the weekend. The good news is that it seems like I’ve managed to find a way to send e-mail notifications from my forum. The bad news is that I didn’t notice that I had some 500 e-mails stuck in the queue which the e-mail job sent out. Oops!
Read articleAs I mentioned in my TechEd Memoirs post, Microsoft is scaling back from the “super” cube approach in favor of more granular data “islands”. Since this took me by suprise, I approached the SSAS team for clarification. Here are the answers I managed to get: 1. What performance benefits could be realized by splitting UDM in data islands? At this point, we don't have detailed…
Read articleIf you’ve been using VS.NET 2005 for a while chances are that your debugging session could have been spectacularly crashing just when you thought you were so close finding that elusive critical bug. This situation may have manifested with the following exception: ContextSwitchDeadlock was detectedMessage: The CLR has been unable to transition from COM context <some nasty hex number> to COM context <another nasty hex…
Read articleTechEd 2006 US is over. Given the fact that VS.NET 2005, .NET 2.0, and SQL Server 2005 have matured, there weren’t many earth-shuttering announcements and cool demos. Anyway, here are some of the most interesting BI highlights written in the plane on my way home. Brian Welcker told us that RS SP2 (CTP scheduled for November, final release alongside Office 2007 launch) will bring a…
Read articleI am gradually tuning to the TechEd wave. I am leaving for Boston on Monday. I hope those of you who will attend TechEd will stop by to my session “Building Reporting Solutions with Reporting Services and Analysis Services”. I’ve already uploaded the slides and code to my website. The presentation is currently scheduled for 8 am on Thursday, June 15th in room 210. As the…
Read article
