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 […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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 […]
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 […]
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.
