PowerPivot for Excel SQL Server 2012 RC0 is Here
Microsoft just published the RC0 (release candidate) bits of PowerPivot for Excel SQL Server 2012. Kudos for Microsoft for making the RC bits public this time. Stay tuned for an […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
Report Server Settings in SQL Server 2012 SharePoint Integration Mode
Well, rules have changed. As Jaime Tarquino from the SSRS team explained in his blog, “SQL Server 2012 Reporting Services SharePoint Integrated Mode”, there is no rsreportserver.config file anymore moving […]
MDXParameter Sample
MDXParameter is a nice little utility that captures MDX queries sent from SSRS reports and replaces parameter placeholders with the actual values. I’ve been using the excellent Darren Gosbell’s Query […]
Stopping SSRS Parameter Refresh
[View:https://prologika.com/CS/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/blog/5736.Product-Sales.rdl:550:0] Problem: How do we stop the maddening parameter refresh for reports that use SSAS cubes? As you’ve probably found, nothing seems to stop it and the Never Refresh option […]
Business Intelligence Edition in SQL 2012
To expand on my announcement about SQL Server 2012 editions, I welcome the new BI edition for the following reasons: The BI edition will include all BI features, including features […]
SQL Server 2012 Licensing and Editions
Microsoft has spoken about SQL Server 2012 editions and licensing. We now have a brand new BI edition. http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-editions.aspx
Handling Dates in BISM Tabular
[View:https://prologika.com/CS/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/blog/2308.AdventureWorks.zip:550:0]If you have experience with multidimensional cubes, you know that most cubes have a Date dimension grained at a day level. If the fact table has multiple date keys, you […]
Reporting Services Data Alerts
SQL Server 2012 introduces a Reporting Services feature called Data Alerts. Data alerts notify a selected list of recipients about data changes on the report. Behind the scenes, data alerts […]
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 […]
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 […]
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.
