Browse by Tags
All Tags »
Reporting Services (RSS)
Once you've installed SQL Server 2008's SP1 ( download here ), I'm sure you'll want to have Report Builder 2.0's click once feature activitated. By default, SSRS will still call Report Builder 1.0 application. Here are steps needed to enable click once
Read More...
There are three fundamental methods for implementing reports against SharePoint Server (MOSS) 2007 list data: direct MOSS table query, web service query, and finally third party tools which implement the web service interfaces. Although the direct table
Read More...
While working on a proof this past week, I installed PerformancePoint 2007 SP2...wishing to use it with SQL Server 2008's Reporting Services. However, when creating a report which was of Reporting Services type, I recieved the following error - "Could
Read More...
Ok...so you are thinking about running a stress test against your Reporting Services 2008 environment, and you've setup your test harness (I'm biased to VS.NET Team Test 2008 with Load Agents) to use a single domain account. When you run your stress tests...you
Read More...
For those that attended my session (Designing Effective Dashboards with Msft BI Platform) at the 2nd annual Msft BI Conference in Seattle, and had asked for the demo files/projects, you can download my demo files here . The zip file contains the SQL Server
Read More...
For those that were looking for the latest Report Builder tool (for use with SQL Server 2008 RTM), look no further...its been published as a web released "released candidate" for a short while already. Get the download here . Want to know what's in this
Read More...
Well...I came across this Dundas Gauge XML Template while researching an installation issue on a recent proof of concept. In a nutshell, if you are creating "Bullet Charts" for a dashboard type report within Reporting Services, and you're using Dundas
Read More...
I often get asked by organizations how they can leverage their SAP "data" investment against the Microsoft Business Intelligence suite of tools. The set of questions usually falls into one of these four categories: Ability to extract data directly from
Read More...
Through conversations with many customers, I’ve been asked either directly or indirectly what makes a dashboard good in terms of design. Put it another way…what are some design best practices to make a dashboard more effective at conveying the “data”
Read More...
With Integration Services, Reporting Services, and Analysis Services, their respective business intelligence objects (packages, reports, and cubes) are designed through the Business Intelligence Design Studio (BIDS), which is really the Visual Studio
Read More...
I've seen this question come up on many a proof...and that is how do you generate Report Models off an Analysis Services UDM (OLAP cube) once you've put SQL Server 2005 Reporting Services into Microsoft Office SharePoint Server (MOSS) Integration Mode.
Read More...
Ok...everyone should know by now that SQL Server 2005's Report Builder doesn't support parent child relationships within a report model (think about the classic employee to supervisor hierarchy...or for another example, how a company may roll up into
Read More...
As with any dashboard implementation, an intuitive user interface design is desired, thus leveraging the latest concepts in dashboard user interfaces. One of those concepts is to display Sparkline type charts. A “Sparkline” is a word coined by Edward
Read More...
