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. Since then, many BI practitioners have favored this approach because of its simplicity, reusability (transactional reports can join to the security table), and performance. Now that organizational tabular projects support data security, I wanted to…
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" Height="100%" Width="100%" SizeToReportContent="True"> </rsweb:ReportViewer> Here is a link to Microsoft's official stand on the browser support for Reporting Services. A couple of notes: Currently Microsoft doesn't support report rendering in Chrome but are re-visiting the…
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 ReportViewer, you'll find that when you export the report it will default the name to a system generated name, such as Report(N).pdf. That's because LoadReportDefinition creates a transient report on the server that doesn't have…
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 on the virtual machine: • SQL Server "Denali" CTP3 • SharePoint 2010 • Office 2010
