Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

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 int , MaturityAmount3 int , RepricingAmount1 int , RepricingAmount2 int , RepricingAmount3 int ); GO...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 12-15-2008
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence
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 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...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 11-09-2008
Filed under: Filed under: Reporting Services, Analysis Services
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 : You have followed the steps in the Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-01-2008
Filed under: Filed under: Reporting Services, Analysis Services
Microsoft SQL Server 2008 Feature Pack RC0, June 2008

Today, Microsoft released an updated feature pack for SQL Server 2008 RC0. Among other things, it includes: A web downloadable installer for Report Builder 2.0 which is not included anymore with the SQL Server 2008 setup An updated version of the RS add-in for SharePoint Analysis Services 10.0 OLE DB...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 06-10-2008
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence, SQL Server 2008
Intelligencia Query

Chris Webb, a fellow MVP and MDX guru, who's blog is a must-read for all SSAS junkies, was kind enough to let me take a look at the Intelligencia Query product he's been working on for a while with Andrew Wiles. Chris announced the product back in April which is now selling as a commercial offering...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 05-14-2008
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence
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 which gives them maximum flexibility at the expense of convenience (the query has to be hand-generated, parameters...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 08-14-2007
Filed under: Filed under: Reporting Services, Analysis Services
TechEd 2007 US Memoirs

I am back from an one-week vacation to Clearwater, Florida followed by TechEd 2007 US in Orlando. Overall, nothing earth – shattering on the BI arena from TechEd 2007. Product groups are between releases so most of the content was SQL Server 2005-based with a few sneak previews of some of the good stuff...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 06-09-2007
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence
Report Builder and Text-based Calculated Members

Although not a common practice, UDM supports defining text-based calculated members. For example, here is an useless but valid text-based calculated member: Create Member CurrentCube.[Measures].[Hello] As "Hello"; Much to my surprise, a text-based member won't show up in Report Builder. That's because...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 03-09-2007
Filed under: Filed under: Reporting Services, Analysis Services
SQL Server 2005 Service Pack 2 is Born

As an update to my previous post , SQL Server 2005 SP2 is now officially available . The SP2 build is 9.00.3042. A SP2 landing page is available too that includes links to the SP2 release, KB articles, marketing information about the benefits of SP2. As a personal contributor to Service Pack 2 (mainly...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 02-19-2007
Filed under: Filed under: General, Reporting Services, Analysis Services, Business Intelligence, SharePoint
Kudos to Report Builder as UDM Client

Its UDM support limitations withstanding (a partial list here ), the Report Builder should definitely be on your list if your requirements call for ad-hoc reporting from an SSAS 2005 cube. Here are some Report Builder features that I particularly like: Ability to pre-filter the data on the report before...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 01-11-2007
Filed under: Filed under: Reporting Services, Analysis Services
Ampersands Gone Wild

Thanks for the Geoff’s feedback on the discussion list, today I was able to demystify one of the SSRS-SSAS integration “gotchas” that has been pestering me for quite some time. Sometimes a report may need the Jump to URL navigational feature to open a parameterized OLAP report. Since...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 09-10-2006
Filed under: Filed under: Reporting Services, Analysis Services
Cumulative hotfix package (build 2153) for SQL Server 2005 is available

Microsoft has released a post-SP1 hotfix which addresses various bugs and issues in SQL Server 2005 and its add-on services.

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 05-22-2006
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence
Join me in the "hub"

I’ve just learned that I’ve been selected to present at TechEd 2006 US in Boston! I've been honored to present Reporting Services for three consecutive years at TechEd. This time, I will change things a bit and instead of focusing on the development area, I will talk about integrating Reporting Services...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 02-22-2006
Filed under: Filed under: Reporting Services, Analysis Services, Business Intelligence
When (null) is not NULL

Here is an interesting SSRS-SSAS integration gotcha that got me recently. Suppose that you have the following MDX query. Needless to say, this query is most likely wrong to start with. It brings the members of three dimensions even if they don’t exist with each other. The correct version should probably...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 02-08-2006
Filed under: Filed under: Reporting Services, Analysis Services
Implementing Smart Reports Article Available

Microsoft has just published an excerpt from my book "Applied Microsoft Analysis Services 2005" on TechNet. Learn how to integrate SSRS and SSAS to build smart reports using data mining and CLR stored procedures.

Posted to Prologika (Teo Lachev's Weblog) by tlachev on 01-17-2006
Filed under: Filed under: Writing, Reporting Services, Analysis Services

Page 1 of 2 (16 items) 1 2 Next >