Partition Generator for Multidimensional Cubes
Today happens to be my birthday. To reverse the tradition, how about I give you a gift? If you find yourself spending hours creating partitions in BIDS, you might find […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Book Review: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
MDX is the query language for multidimensional cubes. Many BI practitioners perceive MDX to have a high learning curve probably not that much for the language itself but for the […]
Disabling Foreign Key Constraints
Disabling check constraints, such as foreign key constraints, is often required when populating a data warehouse. For example, you might want to disable a check constraint to speed up loading […]
Power View Automatic Metadata Filtering
Similar to Report Builder models (now obsolete), Power View (formerly known as Crescent) filters metadata automatically. The reasoning behind this feature is that the tool should guide the user to […]
BISM Tabular Dynamic Data Security Over Bridge Table
About four years ago, in my article Protect UDM with Dimension Data Security, I introduced an approach to secure dimension data in multidimensional cubes by using a factless bridge table. […]
Rendering Reports in Chrome and Safari
A client complained that Reporting Services ReportViewer doesn’t render reports in Google Chrome or Apple Safari browsers. The magic property to apparently fix this issue was SizeToReportContent=”True” <rsweb:ReportViewer ID=”reportViewer” runat=”server” […]
Specifying a Default Report Name on Export with ReportViewer
Normally, when you export a report, the Save As dialog box will default to the report name. However, if you the SSRS LoadReportDefinition API and view the report in the […]
SQL Server DENALI CTP3 Demo VHD Available
Microsoft just released a Hyper-V image of SQL Server Denali CTP3 in action, including fully configured services and integration with SharePoint 2010 and Office 2010. The following software is configured […]
CTP3 Issues with PowerPivot Management Dashboard
I ran into a couple of snags with the PowerPivot Management Dashboard and CTP3 of Denali. In this case, I’ve installed PowerPivot for SharePoint on a standalone domain controller. The […]
Reporting Services "Denali" Brings Export to Excel 2007
One welcome improvement in the forthcoming “Denali” release of Reporting Services is exporting to Excel 2007 (*.xlsx) file formats. I bet many companies will upgrade just to get this feature. […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
