Cognitive Information

Custom Chart Palettes in SSRS

This article is a follow up to the Cognos article on creating a custom color palette.  Custom palettes are pretty common when companies start to standardize their corporate image across all company communications. Make a copy of your report template. Name it ‘MyCorp Chart Report’ In the report area, add a chart Right-Click the chart […]

Customized SSRS reporting template.

Large reporting projects can be simplified with a good template as a starting point. Design templates can store the company header with logo, company color palette, font preference and layout.

Sharing SQL 2012 data in SharePoint 2013

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

How to configure Reporting Services 2012 for SharePoint 2013 integrated mode

A tutorial for configuring SQL Server Reporting Services 2012 on a SharePoint 2013 server in Integrated Mode on a single server.

Getting SQL data into SharePoint

Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL data in Sharepoint.

Bulk Update SSRS Subscription Information

Some tips for bulk updating subscriptions in SQL Server Reporting Services 2008 R2.

SQL Rally 2012 BI Track Highlights

PASS SQL Rally in Dallas, TX had some great speakers. Here is my list of some great sessions on the business intelligence track of the conference.

SSRS Data Driven Subscription Troubleshooting

Microsoft SQL Server Reporting Services (SSRS) 2008 R2 will only allow data driven subscriptions under certain conditions, including data source security and server configuration options. SSRS Subscriptions always work great and easy in the demos and training classes. The following is the list of requirements to actually get them to work with in a data driven environment.

SSRS Adding “Image Not Available” as Alternate Image

I just had a requirement to build a report which had images stored in the database and show a ‘not available’ image when data was not available. This method uses stacked image objects and the visibility properties.

Using SQL to Build MDX parameters

I had a client report which needed a parameter list to default to the previous closed financial period date. The SSAS cube includes reporting periods into the future which have data entries even if the month has not been ‘closed’ by accounting department. Without a ‘Month Closed’ flag in the cube, the only way to […]

Business Intelligence & Data Warehouse Consulting

%d bloggers like this: