cancel
Showing results for 
Search instead for 
Did you mean: 

Xcelsius dashboard based on sap netweaver BW connection

Former Member
0 Kudos

Hi,

I am facing some data formatting issue in xcelsius.

xcelsius is using bex queries. the issue is that before making any formatting change , i need to see the data in spreadsheet available in xcelsius.

but spread sheet is blank and i am not sure how to refresh it to bring the data in excel.

I tried to data connection and preview data but it gives me message " xcelsius cannot connect to BI query beacuase of IO connection fault. make sure url and connection is good"I am bit new to xcelsius and bex query.

Could you please help me.Thansk in advance.

Thanks,

Anamika

Accepted Solutions (1)

Accepted Solutions (1)

former_member182541
Active Contributor
0 Kudos

Using "SAP BW Netweaver Connection" you cannot view the data in the spreadsheet, only at the time of preview you can view the data. Check the below Note:

1509125 - Unable to view Data Preview of BEx query within Xcelsius


Symptom


An Xcelsius dashboard contains an SAP NetWeaver BW Connection which loads into the data manager without any issues.  Within the connection properties under the 'Data Preview' tab, clicking 'preview data' will return the following error:

"Xcelsius cannot connect to BI query because of the IO connection fault, please make sure your request url is valid and the connection is good."

Environment

  • Xcelsius 2008 Service Pack 3
  • SAP BW 7.01 SP6
  • SAP GUI 7.1
  • Flash Player version - 10.1.82.76

Reproducing the Issue

  1. Open an existing dashboard with an SAP Netweaver BW connection
  2. Go to the data manager
  3. Go to the Data Preview tab
  4. Click on the the preview data button


Cause


After the connection was configured in the Xcelsius dashboard, changes to the underlying servers have been performed which resulted in a different connection endpoint than before.

Resolution


In the same dashboard, delete the existing connections and add them again.  Re-mapping the connections will ensure that Xcelsius' connection to the BICS web service is current.

Former Member
0 Kudos

Hi Suman,

Thanks for the information.

I am facing input/ output blank values after selecting Bex query.

do you know is it related to Adob FlashPlayer issue or something else.

Regards,

Anamika

Former Member
0 Kudos

Hi Anamika,

There are different ways you can add BEx query within Dashboards.

1. SAP NetWeaver BW connection

2. Using Query Browser

3. LiveOffice/BIWS with WEBI etc

Now, you can expect BEx query data to appear in excelsheet for point# 2,3, not 1.

Flash would not cause data not to appear in excelsheet.

If you could write down steps you are following, we would definitely help you.

Regards,

Tejas

Answers (0)