Logo
CAR REVIEW
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
PREGNANCY
 
 
Windows Server

SharePoint 2010 PerformancePoint Services : SQL Server Table Data Source

3/25/2011 10:14:05 PM
This data source allows you to create a connection to SQL Server tables. You can also create a connection to SQL Server views. You need to have at least read access to the source before you can create a successful connection.

In this example, connect to the RequestUsage table located in the WSS_Logging database.

1.
After you create a new data source based on the SQL Server table data template, the SQL Connection Settings screen appears.

2.
Next, specify the server, database, and table or view name.

3.
You can also choose to configure the connection string manually to get access to all connection string properties, as you did with Analysis Services. As with all other tabular data sources, the authentication options available are Unattended Service Account and Per-user Identity. Figure 1 shows how the settings should look after you specify all the properties.

Figure 1. This is an example of complete settings for a SQL Server table data source.

4.
As with all tabular data sources, verify that all columns have been properly configured as a dimension or fact. In addition, verify that all facts are using the proper aggregation column (see Figure 2).



Figure 2. Verify that the columns are tagged properly as dimension or fact.

As shown in Figure 2, all the columns except for the RowID are configured correctly. The RowID is interpreted as a dimension since it contains GUID’s, so it has been set to be a dimension.

After you change the RowID column to be of type Key, the data source is ready to be used in a scorecard.

Other -----------------
- BizTalk 2010 Recipes : Document Schemas - Promoting Properties
- BizTalk 2010 Recipes : Creating Schema Namespaces
- BizTalk 2010 Recipes : Creating a Schema Based on an Existing XML Document
- BizTalk 2010 Recipes : Creating Simple Document Schemas
- Restoring Windows Server 2008 (part 2) - Restoring Individual Components
- Restoring Windows Server 2008 (part 1) - Full Server Recovery
- Installing and Configuring Office Web Apps for SharePoint 2010 (part 2)
- Installing and Configuring Office Web Apps for SharePoint 2010 (part 1)
- Office Web Apps Integration with SharePoint 2010 : Planning for Office Web Apps Use
- Windows Server 2008 R2 : Planning Domain Group Policy Objects (part 2)
- Windows Server 2008 R2 : Planning Domain Group Policy Objects (part 1) - Policies and Preferences
- Windows Server 2008 R2 : Planning Workgroup and Standalone Local Group Policy Configuration
- Exchange Server 2010 : Components of a Secure Messaging Environment (part 3) - Using Email Disclaimers
- Exchange Server 2010 : Components of a Secure Messaging Environment (part 2)
- Exchange Server 2010 : Components of a Secure Messaging Environment (part 1) - Hardening Windows Server 2008
- Considering the Importance of Security in an Exchange Server 2010 Environment
- Installing BizTalk Server RFID 2010
- BizTalk Server 2010 : Configuring EDI Trading Partners
- BizTalk Server 2010 : Accessing the EDI Version 5010 HIPAA Schemas
- Exchange Server 2010 : Managing Recipients and Distribution Groups (part 2) - Distribution Groups
 
 
Most view of day
- Microsoft Visio 2010 : Finding and Managing Shapes (part 3)
- Microsoft Excel 2010 : Protecting and Securing a Workbook - Adding Security Encryption to a Workbook
- System Center Configuration Manager 2007 : Network Design - Troubleshooting Configuration Manager Network Issues (part 2) - Identifying Network Issues Affecting Configuration Manager
- Microsoft Lync Server 2013 : Director Troubleshooting (part 2) - DNS Records, Logs
- Maintaining Dynamics GP : Speeding security setup with User Copy
- System Center Configuration Manager 2007 : Network Design - Use of BITS
- Integrating SharePoint 2013 with the Office Applications (part 7) - Microsoft Access - Access Services
- SQL Server 2012 : Understanding Latches and Spinlocks (part 1) - Latching Example
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 1) - Performing Advanced Find Queries
- Monitoring Windows Small Business Server 2011 : Using Event Viewer
Top 10
- Microsoft Lync Server 2013 : Director Troubleshooting (part 3) - Synthetic Transactions,Telnet
- Microsoft Lync Server 2013 : Director Troubleshooting (part 2) - DNS Records, Logs
- Microsoft Lync Server 2013 : Director Troubleshooting (part 1) - Redirects, Certificates
- Microsoft Lync Server 2013 : Administration of the Director Role (part 4) - Services Management, Client Version Filter
- Microsoft Lync Server 2013 : Administration of the Director Role (part 3) - Topology Status
- Microsoft Lync Server 2013 : Administration of the Director Role (part 2) - Ports,Firewall Rules
- Microsoft Lync Server 2013 : Administration of the Director Role (part 1) - Services
- Microsoft Lync Server 2013 : Configuring the Director (part 2) - Web Services Ports,Reverse Proxy
- Microsoft Lync Server 2013 : Configuring the Director (part 1) - SRV Records, Web Services FQDN Overrides
- Sharepoint 2013 : SharePoint Designer 2013 (part 2) - Locking Down SharePoint Designer
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro