For this example, we will configure a dashboard configuring containing one page with one scorecard view (OLAP data source) and one SSRS Relational report and a second page containing the same OLAP scorecard and a second SSRS OLAP report. Note, the SSRS reports are both configures in SSRS to have an SSRS parameter based on Geography - the parameters must be set up in SSRS prior to connecting the parameter to a Filter in the PerformancePoint dashboard.
Create report views for your SSRS reports
1. Right click the Reports folder in the dashboard designer and select New Report.
2. Select SQL Server Report and click OK.
3. Enter a name for your report and click Finish.
4. Enter the Server URL to the SSRS report server.
5. Click the Browse button and select the SSRS report you wish to include. Click OK.
6. Ensure that the parameters came through and are listed in the Report Parameters section.
7. Select each parameter, click Edit and set a default value.
8. Publish the report to your PerformancePoint Server by selecting the Home tab and clicking Publish All.
9. Repeat steps 1 through 8 for all your report views you wish to include. Note that the process does not differ for Relational vs OLAP SSRS Reports.
Configure your dashboard
1. Right click on Dashboards in the Dashboard Designer and select New Dashboard.
2. Select your template (in this example, we will choose 3 Rows) and click OK.
3. Assign a name to your dashboard and click Finish.
4. Drag your scorecard, in this example I choose an OLAP scorecard, and pull it into the Center Row.
5. Drag your SSRS report, in this example I pull an SSRS Relational Report, into the Bottom Row.
6. Create a Filter in the Dashboard. In this example, I build a filter off of my OLAP data source that sources my scorecard and is the same cube as my SSRS OLAP report is built from.
7. Drag your Filter into the Top Row.
8. Click on the Filter in the top row you will see a list of options listed under your parameter name.
9. Select Display and drag it to your SSRS Relational Report input area in the Bottom Row. Note, in order for this to work, your names in your SSRS Relational Report parameter, must match the captions of your members in the cube. Display specifies that we will provide the cube member name caption as the input to the report.
10. In the Edit Filter Link dialog, select the SSRS Report parameter from the Dashboard item endpoint drop down to create the link between the PerformancePoint filter and SSRS report parameter.
11. Click on the parameter again and select MemberUniqueName and drag it into the input area for the scorecard. We do this because our scorecard is built off of a cube data source and needs the MDX member unique names passed as inputs.
12. In the Edit Filter Link dialog, select Filters form the Dashboard item endpoint to pass the parameter as a filter to the scorecard.
13. Create a second page in your dashboard, also configured with 3 rows.
14. Place your same OLAP scorecard in the Center Row, your SSRS OLAP report in the Bottom Row and the same filter in the Top Row.
15. Click on the filter and drag the MemberUniqueName property to the input of the SSRS OLAP Report. In this case, we need the member unique name because the SSRS report is an MDX query which requires the MDX unique name as the parameter value.
16. In the Edit Filter Link dialog, select the SSRS Report parameter from the Dashboard item endpoint drop down to create the link between the PerformancePoint filter and SSRS report parameter.
17. Click on the parameter again and select MemberUniqueName and drag it into the input area for the scorecard.
18. In the Edit Filter Link dialog, select Filters form the Dashboard item endpoint to pass the parameter as a filter to the scorecard.
19. Publish your dashboard by selecting the Home tab and then selecting Publish All.
Export and view the dashboard
1. Click the Export tab and then select Sharepoint Site from the ribbon bar.
2. Choose the dashboard we just created and click Next.
3. Enter the Sharepoint URL and select the Document Library you wish to publish to, click Next.
4. Select the master page you wish to publish with and click Finish.
What is so SPECIAL on ASPHostDirectory.com Reporting Service Hosting?
We know that finding a cheap, reliable web host is not a simple task so we’ve put all the information you need in one place to help you make your decision. At ASPHostDirectory, we pride ourselves in our commitment to our customers and want to make sure they have all the details they need before making that big decision.
We will work tirelessly to provide a refreshing and friendly level of customer service. We believe in creativity, innovation, and a competitive spirit in all that we do. We are sound, honest company who feels that business is more than just the bottom line. We consider every business opportunity a chance to engage and interact with our customers and our community. Neither our clients nor our employees are a commodity. They are part of our family.
The followings are the top 10 reasons you should trust your online business and hosting needs to us:
- FREE domain for Life - ASPHostDirectory gives you your own free domain name for life with our Professional Hosting Plan and 3 free domains with any of Reseller Hosting Plan! There’s no need to panic about renewing your domain as ASPHostDirectory will automatically do this for you to ensure you never lose the all important identity of your site
- 99,9% Uptime Guarantee - ASPHostDirectory promises it’s customers 99.9% network uptime! We are so concerned about uptime that we set up our own company to monitor people’s uptime for them called ASPHostDirectory Uptime
- 24/7-based Support - We never fall asleep and we run a service that is opening 24/7 a year. Even everyone is on holiday during Easter or Christmast/New Year, we are always behind our desk serving our customers
- Customer Tailored Support - if you compare our hosting plans to others you will see that we are offering a much better deal in every aspect; performance, disk quotas, bandwidth allocation, databases, security, control panel features, e-mail services, real-time stats, and service
- Money Back Guarantee - ASPHostDirectory offers a ‘no questions asked’ money back guarantee with all our plans for any cancellations made within the first 30 days of ordering. Our cancellation policy is very simple - if you cancel your account within 30 days of first signing up we will provide you with a full refund
- Experts in Reporting Service Hosting - Given the scale of our environment, we have recruited and developed some of the best talent in the hosting technology that you are using. Our team is strong because of the experience and talents of the individuals who make up ASPHostDirectory
- Daily Backup Service - We realise that your website is very important to your business and hence, we never ever forget to create a daily backup. Your database and website are backup every night into a permanent remote tape drive to ensure that they are always safe and secure. The backup is always ready and available anytime you need it
- Easy Site Administration - With our powerful control panel, you can always administer most of your site features easily without even needing to contact for our Support Team. Additionally, you can also install more than 100 FREE applications directly via our Control Panel in 1 minute!
Happy Hosting!