Business Intelligence is Fifth Hottest IT Skill
ComputerWorld ranks BI as the fifth hottest IT skill.
Read articleSkip to articles
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", and "so-so" status ranges had to be defined as configurable values at any level of the organization dimension and KPIs. I settled on implementing a measure group that intersects the organization dimension and a new…
Read articleReporting 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 related to Reporting Services, such as training content, white papers, blogs and more. I'm proud to be featured as an MVP J The page also includes to my most recent books and training videos I've…
Read articleSQL 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 as you need to install the .Net provider from Teradata.
Read articleDimensionalizing 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 int, MaturityAmount3 int, RepricingAmount1 int, RepricingAmount2 int, RepricingAmount3 int); GO INSERT INTO pvt VALUES (1,1,4,3,5,4,4, 100); INSERT INTO pvt VALUES (2,1,4,1,5,5,5, 100); INSERT INTO pvt VALUES (1,2,4,3,5,4,4, 200); INSERT INTO pvt VALUES (2,2,4,1,5,5,5, 200); INSERT…
Read articleTroubleshooting 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 likely, the culprit is that the person who installed the add-in is not SharePoint Web farm administrator and Site Collection administrator. As a first stop for troubleshooting SharePoint integration issues, you should examine the add-in log…
Read articleCumulative 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 based on whether you are running into a bug fixed in the build and it is password-protected. Among other things, it fixes the freeze issue associated with opening SSAS projects in BIDS.
Read articleReferencing 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 the following query returns 1 if a given employee has exceeded 1 million in sales for the dates specified by the user in the report parameter. WITH MEMBER [Measures].[Selector] AS SUM ( StrToSet(@DateCalendar), iif([Measures].[Reseller Sales…
Read articleDundas Chart Controls for .NET Available
On Friday, Microsoft released chart controls for Microsoft .NET Framework 3.5. These are re-tooled Dundas .NET chart controls which are now baked in the .NET framework. This is important because you can add the same stunning Dundas chart features to your Windows Forms and ASP.NET applications without external dependencies or licensing fees. It also minimizes your learning curve, as the Dundas controls share the same…
Read articleSSAS 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 dashboard page alongside other KPIs and charts, it was important to optimize the query as much possible. Rephrased to Adventure Works, the query went something like this: WITH MEMBER increaser AS Iif([Measures].[Internet Sales Amount]>([Measures].[Internet Sales…
Read articleFollow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. We empower organizations to make sense of their data with effective and modern BI solutions.
