Refresh data in SWF based on excel file saved from SAP BW workbook

[Former Member]

Hi, is there a way to get data refresh in SWF dashboard from excel file as a data source. SAP BW workbook report will be saved as an excel file daily and placed in somewhere. I would like to create a dashboard which can connect to the excel data source and refresh on load.

Appreciate your advice and help. Thank you.

I am using Xcelsius 2008 and SAP BI 7.0

[former_member186358]

Teow,

If you are looking for refreshing your dashboard from excel file...then try using XML maps

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/805a03d5-7b64-2b10-48ab-c5009ac2...

-Anil

[Former Member]

Hi Anil,

If the excel file (which is an output file from SAP BI) is replaced daily on the server, how can we retain the XML mappings in the excel file?

If I use this XML map method, I need someone to write the XML source file for me?

Thanks for your advice.

[Former Member]

Hi,

you want to connect to bex report(which is saved as an excel sheet) as an source to dash board and you want to refresh on load am i right. It only possible using live office or QAAWS and sap integration kit.

As per my knowledge its not possible directly to get the dynamic data on refresh from static spread sheet(the bex report saved as excel sheet will be static).

Thanks,

SK.

[Former Member]

You should be able to use LiveOffice in this instance. Alternatively, FlyNet Web Services Generator may be possible leveraging an ODBC connector to the workbook.

Hope that helps!

[Former Member]

The client does not purchase live office license. I am using Xcelsius Enterprise 2008 and wish to build a Financial Income statement. I tried to use the QAAWS to do this, but the data return from QAAWS is in tabular format. Besides, the dashboard requires many QAAWS connections to pull the data from different financial categories, eg. Cost of Good sold, Operating Cost, Profit before tax, etc..

Question : most of the Xcelsius functions require data in row, how to return data from QAAWS in row format?

Is the Flynet Web Services Generator an alternative way to choose for data connection if i don't use the QAAWS?

[Former Member]

Ah, so you can connect, you're just worried about formatting... Welcome to Xcelsius.

What I would suggest doing is having a hidden tab in your workbook that pre-formats the data using cell references, and use that as the source for your QaaWS.

[Former Member]

Thank you.

If I understand correctly from your advice, that is I should create QaaWs to pull data from SAP BI, which will return data in tabular format. Map the data in the cell range of a hidden tab, re-arrange and format the data into the row?

Another concern: I need to display data for 4 quarters (Q1, Q2, Q3,Q4) in the dashboard, but QAAWS will only pulls data when the data is available in the database.

Eg. Only data for 3 quarters are found in the database, QAAWS will return data for Q1, Q2,Q4.

This will mess up the position fixed in the xcelsius. Do you have any suggestion on this?

Sorry to bother u for the simple questions.

Thank you.

[Former Member]

QaaWS will not pull in blanks, but you can trick it. Pull in the results as you like, and have all of the 'blank' values set to something like 'NULL'. See if that works. If that does the trick, then just create a formatted set of cells that references the first set and tell it =IF([cell] = 'NULL', "", [cell value]).

[Former Member]

Thanks, Brian. Your suggestion is really helpful, gives me some clue to figure out how to do work on it.