When I was working on maintenance project, I got a requirement to restore production back-up in my local box to do more investigation on production issue. I was able to take back of site collection and restored in to my local SharePoint portal. But in this back up, custom features that are installed on production and activated for this site collection were not moved. So I thought of taking back-up for all WSP that are installed on the production environment. I did little R&D and found below commands. These are pretty simple and useful. It resolved all my burdens.
$farm = Get-SPFarm
$file = $farm.Solutions.Item(“extendeddiagnosticproviders.wsp”).SolutionFile
Create ps1 file with above commands and run in power shell on production environment (where SharePoint configured). It saves a copy with the file name in the given folder. That file can be moved to your local system and can deploy into your box, just like another WSP.
Performance Point Service Creation
- Go to “Central Administration”
- Click on “Manage Service Applications” under “Application Management”
- Click on “New” button and select “Secure Store Service”
- Give a Secure Store Name and other details click “OK”
- Go to “Manage Service Application” page
- Click on “New” button and select “Performance Point Service Application”
- Give PPS name and application pool and click OK.
- Now click on “Secure Store Service” that you created
- Click on “Generate New Key” and give pass code. This code will be the secure pass to access the data base.
- Now you will see “There are no Secure Store Target Applications in this Secure Store Service Application. You can create a new Target Application from the Manage Target Applications group in the Edit ribbon group” message on the Secure Store Service page.
- Go back to “Manage Service Applications” page and click on PPS that you created
- Click on “Performance Point Service Application Settings”
- Give User Name. Secure Store Service Application will be filled with Secure Store Service name that you created. It is not editable.
- Click Ok
- Go back to “Mange Service Applications” page and click on Secure Store Service that you created.
- Now you will see one row in that sheet with performance point service name.
Configuring Performance Point Feature:
- Go to Site Collection link
- Click on “Site Actions” -> “Site Settings”
- Under “Site Collection Administration” click on “Click on Site Collection Features”
- Enable below features
- SharePoint Server Standard Site Collection Features
- SharePoint Server Publishing Infrastructure
- SharePoint Server Enterprise Site Collection Features and
- Performance Point Service Site Collection Feature
- Now go to “Manage Service Applications” page under “Central Administration”
- Click on performance point service that you created
- Click on “Trusted Data Sources”
- If you are looking for all libraries to include in the service, don’t make any change. If you want to have service enabled for specific libraries then choose “Only Specific Location” option and click “Apply”
- Click on “Add Trusted Data Source Locations” and add lists or libraries addresses.
Using Performance Point Service:
- Go to site collection page
- Add new Site and choose “Business Intelligence Center Site Template”. If you didn’t find this in first glance, go to “Data” type sites and you can identify easily.
- Create an Unattended Service Account; make sure that you are using same account as you created for Secure Store Service.
- Click on “Create Data Board” link and then start using “Performance Point Service”
- From the Performance Point Service package click on the button and say “Run Dash board Designer”
- It takes couple of minutes and creates an empty dash board with all elements that are required.
- Create a Data Source for “Share Point Service”
- From the Select a Data Source Template menu, choose the Analysis Services template to create a data source that connects to Microsoft SQL Server Analysis Services, and click OK. Next Configure the Connection Settings.
- Watch for Cache Lifetime setting. The value of this textbox (in minutes) indicates the interval of refreshing the dashboard information from the backend data source.
- Click Test Data Source to make sure that your connection settings are correct.
- Switch to the Properties tab and change the Name of your data source.
- Save the new data source by right – clicking it in the Workspace Browser, and then selecting Save.