Save this report as AdventureWorks Products. Once this report is saved in your list, note that it is saved as a certain content type. I'd like to point out here that if you were to add that content type to any other list, you would be able to save your reports in any list in SharePoint you wished. This really gives you the maximum flexibility you need.
Back on your SharePoint site on the default page, put the page in edit mode and drop the PerformancePoint report Web Part. Then, point this Web Part to this newly created report that you've just uploaded in your SharePoint site. You should note that the report is running in full interactivity on the SharePoint site. You should see a big blue bar called All geographies. Go ahead and click on the big blue bar, and the report should update, giving you the various products available. This can be seen in Web Figure 2.
Why is it that my bike sales are so high? I'm not asking this, but I know my business users will. When you see the bright red bar, right-click it and choose decomposition. This brings up a Decomposition Tree for the underlying data source, and it would immediately tell you that you are selling a lot of road bikes (shown in Web Figure 3).
Why are you selling so many road bikes? As an analyst now, you can click on it and easily choose the dimension you wish to expand upon (see Web Figure 4).
Let’s expand on Geography, which reveals that you are selling a lot of bikes in California. Expanding further by city reveals that you are selling a lot of bikes in Carson, and especially in the months of May, November, August, and February. This is a pattern that repeats every year. This pattern can be seen in Figure 7.
This clearly tells you that the Carson market is pivotal to your company's success! And, you were able to determine this without bothering a developer.