Retrieving Cube Metadata in Reports
An interesting question popped up on the discussion list the other day about how to retrieve a list of the cube measures so the report author can display them in […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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 […]
Business Intelligence is Fifth Hottest IT Skill
ComputerWorld ranks BI as the fifth hottest IT skill.
Implementing Cube Settings
I had to tackle an interesting requirement the other day. A cube had a number of KPIs defined but the threshold values that were used to define the “good”, “bad”, […]
Reporting Services 2008 Dashboard Goes Live
Thanks to the Robert Bruckner’s blog, I’ve learned that Microsoft has published the Reporting Services 2008 Information Aggregator. It is a cool dashboard page that aggregates a variety of resources […]
SQL Server 2005 Service Pack 3 is Out
Yesterday, Microsoft released SQL Server 2005 Service Pack 3. Reporting Services Report Builder added support with Teradata. Note that some manual configuration is required to turn things ‘on’ as well […]
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 […]
Troubleshooting the SharePoint Add-in for Reporting Services
A common issue when setting up Reporting Services integration with SharePoint is that the SharePoint add-in is not installed properly although the setup program doesn’t indicate any issues. More than […]
Cumulative Update 2 for SQL Server 2008
Microsoft has released the Cumulative Update 2 build (build number 1779) for SQL Server 2008. The update is not publicly available as of now. It has to be released individually […]
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 […]
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.
