[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

PerformancePoint? BI Solution --- Pass Store Procedure Dynamically Graph

I need a way to filter and graph dynamically upon filtered data.  It would be a stored procedure. I know PerformancePoint is available for free for Enterprise license holders but it will be more complex than what is currently needed.  Would PerformancePoint allow a simple stored procedure to be passed to dynamically be graphed?  If so, or if not, what other recommendations would you have to show stored procedure results by using filters to show in a graph?  It would eventually be rolled out to 3,000 users where they can see there overall performance so Excel services may not be a route. Thanks

p.s sql analysis  service is not installed or configured. dba doesn't want to either.
0
miketech99
Asked:
miketech99
  • 3
  • 2
1 Solution
 
GreatGermCommented:
You should definitely implement PerformancePoint.  It will easily handle what you are requesting with the built in webparts.  It may seem more advanced than what you need now, but you will quickly find that it will handle more than just reporting and will make your life easier.
0
 
miketech99Author Commented:
Ok. Is SSAS required to use PerformancePoint?  How could I supply a store procedure--for it then to provide filters to then output to a dynamic chart/graph?  Thanks
0
 
GreatGermCommented:
It looks like SSAS is required for what you want from PerformancePoint: http://www.microsoft.com/business/performancepoint/productinfo/systemrequirements.aspx

I know your dba doesn't want to, but it's one of those things that shouldn't be an option.

You would use the Planning Business Modeler to create the stored procedure.
0
 
GreatGermCommented:
Did you have any more questions on this topic miketech99?
0
 
miketech99Author Commented:
thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now