Named Set Subtotals in Excel
So many SSAS browsers, so little resemblance… And each browser has an independent view of which SSAS features it cares about and how it will go about implementing them. For […]
New Search
If you are not happy with the results below please do another search
329 search results for: query
Dimensionalizing Pivoted Measures
Issue You have a table with pivoted measures, such as: Use the following statement to create and populate the table: CREATE TABLE pvt (VendorID int, DateID int, MaturityAmount1 int, MaturityAmount2 […]
Referencing Parameters in SSRS Calculated Members
Issue: You author an SSRS report that connects to a cube. You want to create a calculated member that uses a report parameter. For example, the Selector calculated member in […]
SSAS WHERE vs. Subselect Puzzle
I’ve been involved recently in a quest to optimize an SSAS 2008 long-running query that would return the 12-month history of a KPI. Since the KPI was displayed on a […]
Nasty SSAS 2008 Bug
There is a nasty known bug with SSAS 2008, where if a query that requests two measures with Sum and LastNonEmpty aggregate functions side by side and the query uses […]
Yet Another Post About Analysis Services HTTP Connectivity
With risk to iterate the obvious, here is a lesson learned from the trenches: Scenario: You want to let external users browse an Analysis Services cube over the Internet. Setup: […]
SQL Server 2008 Release Candidate 0 (RC0)
Microsoft declared build #1442.32 to be the official SQL 2008 RC0 build and made it publicly available. Key SSRS improvements in this build: Rich text formatting. You can now format […]
SQL Server 2008 November CTP Is Out
The November CTP (CTP5) of SQL Server 2008 is out. Here are the most significant BI-related highlights that caught my attention. Reporting Services The standalone Report Designer has undergone a […]
How to Get Extended Properties with SSAS OLE DB Provider
Many report developers find the SSAS data provider too restrictive for authoring reports from UDM. Instead, they replace it with the native Microsoft OLE DB Provider for Analysis Services 9.0 […]
Empty Affairs
If you have a cube with large dimensions you may have come across the following error: The expression contains a function that cannot operate on a set with more than […]
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.
