Portal Edition / BI WebParts consists of a family of analysis tools enabling users to publish, analyze, and collaborate on information from a data warehouse that uses SQL Analysis Services.

Web Parts are the building blocks of Web Part Pages. The web parts can display information from OLAP cubes as Trend, Z-Chart, Table and Chart (Gauge, Column, Line, Column/Line, Stacked Column, Stacked Area and Pie). To view a page web parts you do not need any additional components installed then standard Internet Explorer installation.

The wizard is the tool for creating and configuring web parts. PTS is used to connect and collecting meta data from the data source.

The Analysis Client consists of wrappers around OWC (Microsoft Office Web Components 2000, XP and 2003), ProClarity and Executive Viewer) and you can use this tool to browse your cube data. When clicking Detail Link (header text) on the Web Part, the Analysis Client is used to give you a starting point for further analysis. These clients use PTS to connect directly to the data source.

Web Parts uses linked resources like script files, style sheets and images.

These files are stored in a subfolder to the global Web Part resource folder on the SharePoint server (/Program files/Common files/Microsoft shared/web server extensions/wpresources/decisionsupportpanel.sharepoint.webpart/+ versionnumber).

Each web part is built from html templates.

The cache minimizes the amount of queries against the data source. See Caching.

It is possible to log activities by turning on logging. See Logging.

The Web Part Server handles the querying against the data source and using PTS to connect to the data source. See Analysis Services and SharePoint on different machines for how to configure in different server scenarios.

Each web part running in the SharePoint environment must have an assembly association. Our web parts are associated with DecisionSupportPanel.SharePoint.WebPart.

  • pe/howitworks.txt
  • Last modified: 2014/03/03 10:16
  • by pcevli