Microsoft SharePoint

PowerPivot, Silverlight PivotViewer, Excel Services, Performance Point, Project Crescent from STL BI Use Group

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans... mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-... ......

Posted On Thursday, May 19, 2011 9:21 PM | Comments (0)

SharePoint 2010 and SQL Server 2008 R2 BI

Just saw a presentation on SharePoint 2010 and SQL Server 2008 R2 BI Integration. There are some cool stuff that will be out soon. The presentation focused on PowerPivot and Performance Point server. A end-business user can access her/his datasource, pull in some external data (like weather condition), and create a spreadsheet using PowerPivot. This spreadsheet, in addition to being hosted on SharePoint, can be incorporated through Performance Point by a SharePoint developer, and build a Cube in ......

Posted On Wednesday, January 13, 2010 12:21 PM | Comments (2)

Final note on creating PDF using SSRS and SSIS

Business Scenario: The client gets some kind of feeds that writes into a process table of their client processing system. The data is stored directly as the raw XML file inside a SQL data column. The XML could store multiple enrollment information for the same member. We need to use this info to determine whether a member is eligible, then insert into a staging table. The staging table is then used as a feed to drive a report that generates an image for each claim and sent off to the different provider. ......

Posted On Tuesday, December 8, 2009 2:19 PM | Comments (0)

Performance issue with SharePoint Services 3.0 and SQL Reporting Services 2008 in integration mode

I'm having an issue here at a client site. The report we designed runs fairly quickly in DEV, it takes 8 seconds for the report to render. We now have the report deployed to the production SharePoint site and it's taking 1 minutes 8 seconds to load. Both reports point to the same database, so there is no difference on the data side. It's past 5 PM here so there is nobody on the SharePoint site, either. There is a slight difference in the hardware: the prod has 0.5 GB less available memory than DEV, ......

Posted On Thursday, October 29, 2009 2:34 AM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski