Dec 20, 2012

Webservices - Xcelsius best Connection type

After using live office, QaaWS and other connection types, we always struggle with our xcelsius projects for optimization in loading and execution time. Live office is most delayed and cumbersome approach. Though QaaWS can help much in optimizing dashboard performance but still, its no where in comparison with asp.net web services (because BO server layer is bypassed). After trying all the connection types, finally i have decided which one to use for my dashboards.

Following are main advantages of asp.net web services which forces me to use them :


  1. Fastest approach in comparison to any other connection type.
  2. No universe dependency. Hence, better for people not having direct access to universe
  3. All the query can be managed in asp code. Hence, aggregations and data formatting can be managed in better way at asp level.
  4. No struggling with excel issues as comparing with Liveoffice.
  5. Dashboards can be shared outside BO environment (infoview) as the login to datasource can be managed in asp.net webservice. So it makes very easy to share Xcelsius dashboards over intranet in form of embedded objects in webpages.
The only obstacle in using asp.net web services might be that you may not be a coder of asp.net. But that's not a big deal. You can google around to make webservices. Well I'll be posting an article for creating asp.net webservices that can be consumed in xcelsius soon.....

No comments:

Post a Comment