Xcelsius - Using Query as Web Services in a Dashboard

How to create a Query As A Web Services 

Open the BO tool Query As A Web Services from Programs -Business Objects 


Log on Business Objects  Server 

Insert the  Web Services url:

http:/SERVERNAME:8080/dswbobje/services/Session


Give a name to the Web Service



Assign value to advanced parameters:


Select the Universe on wich you need to create a query:


Create your query selecting the available objects in the universe


After executing the query will appear a data preview


Finally you have to publish the query on CMS


Now open

Xcelsius 2008 

and Create a Connection  to a QAAWS


After this Xcelsius will retrieve data in order to create charts and all the Dashboard objects:


Comments

  1. kanmaniJuly 8, 2013 at 10:05 PM

    Wonderful blog & good post.Its really helpful for me, awaiting for more new post. Keep Blogging!





    Business IT Services

    ReplyDelete
  2. PABX services in DubaiSeptember 24, 2019 at 4:46 AM

    Great blog very informative for me keep posting!

    IP PABX Systems Dubai
    Panasonic PBX Phone System in Dubai

    ReplyDelete
  3. PrakashSeptember 25, 2019 at 5:58 AM

    Thanks for sharing the informative information through the article. And all the details are awesome and good in this post.

    Structured Cabling services in Dubai
    Structured Cabling Dubai

    ReplyDelete
  4. swifthandyqatarNovember 16, 2022 at 9:23 PM

    this blog is very helpful
    https://info-bytes.com/managed-it-service/

    ReplyDelete
  5. Master ComputersDecember 26, 2022 at 11:20 PM

    Hi,
    Really happy to say your post is very interesting to read. I never stop myself to say anything about it. We are one of the top IT solutions companies in Abu Dhabi, you can be confident with our IT services so that you can concentrate on your core activities. Check our page, "https://www.macouae.com/". Expecting more blogs.

    ReplyDelete
  6. VRS TechJuly 9, 2024 at 2:31 AM

    very informative blog IT Services Dubai

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man
Read more