Current Position:Home > WD application showing combined data

WD application showing combined data

Update:11-30Source: network consolidation
Advertisement
Hi All,
Is it possible to create WD application showing combined data from flat file and from external DB?
Does anyone has experience or guide how to do it?
Thanks in advance
Marek

The Best Answer

Advertisement
Hi Marek,
Apparently the scenario which you have explained is not that simple as it seems to be. There is lot behind this.
As per your requirement:
1. I get data from external DB into WD
2. I upload data from local file into WD
3. I would like to combine data from both DB and local file.
4. I would like to display combined representation data from both external DB and local file.
I would go point wise and hope that clears your issue:
1) If you want to get data from External DB it depends which external DB you are using. Is it a SAP system or a non-SAP system. If that is a SAP ABAP system then you can use the Adaptive RFC model which is provided in Webdynpro to extract data. In case that is the non-SAP system then you need some connector from XI which can extract the data from 3rd party systems and can bring on to the same platform of SAP and then you can get the data out of it. In case you have non-SAP system then proabably you need to do lot of things before you actually get the data in webdynpro.
2) Get data from Local file: This is simpler than above case, however require some coding efforts. You need to read the local files in such a way that it can be formatted in a given format. After that this can be easily accessed in the webdynpro application. This will be a small JAVA code to extract the data from a local file system (i am assuming that data is in .csv, .xls, .txt formats)
3) Combine data from both datasource: This is quite tricky task as you need to get the data from both data source in common format so that it can be used to get displayed using the Webdynpro application. Again I would say this require java coding tricks.
4) Once you get the data in common format then there is nothing in displaying the data using webdynpro application.
I hpe this will clear you doubts. Please revert back in case you need more clarifications.
Thanks and Regards,
Pravesh
  • WD application showing combined data Update:11-30

    Hi All, Is it possible to create WD application showing combined data from flat file and from external DB? Does anyone has experience or guide how to do it? Thanks in advance MarekHi Marek, Apparently the scenario which you have explained is not that

  • Combining data from different applications Update:11-30

    Dear all,   I am using BPC 5.1   I have a "Sales" application with dimensions "account", "entity", "time", "rptcurrency", "category", "product". And another "HR" application w

  • How to do calculations on the combinational data. Update:10-11

    Hi,    I am not able to do calculations on the combinational data. I have four combinations the formula what I am expecting comb4 = comb1*comb2/comb3. For this I have written formula like below by using REC syntax. Let me know how could I do this. Pl

  • PROBLEM Creating a Sample Application from Uploaded Data - ENDECA 3.1 Update:10-11

    Good morning. I'm installing OEID 3.1 and y have many problems. One is when i want to créate a Sample Application from Uploaded Data following "InfoDiscGettingStarted.pdf" I have the next error message: "Task execution failed for workflow I

  • How to combine data from different input forms outside a nested iView Update:10-11

    Hi, i try to combine data from different input forms in a single one. Because of space reasons in Flex compiling i already use nested iViews. Within these nested iViews its possible to use the 'combine' function to do this. But in the main iView I ca

  • Can CLOUD data source be joined to a combined data source? Update:10-11

    Hi, experts,        I have created a cloud data source and I am trying to join the cloud data source with a combined data source.        I am having a problem.            This is how I joined the two data sources. I checked the Joined Data Source. It

  • OBIEE 11g - Combine data from two Oracle tables Update:10-11

    Good day! I tried to combine data from two Oracle tables as fact data, but it doesn't work. My steps: I created SCOTT.EMP2 table from SCOTT.EMP table, update EMPNO and ENAME values of EMP2 table to distinguish data of my tables. Then I imported physi

  • Urgent! Application tier and Data tier on different platforms Update:10-11

    Hello! I would be very grateful if someone confirms that the deployment of the Beehive, where Application tier and Data tier are placed on different platforms, is supported. For example, Oracle Database (Data tier) on Linux, and Oracle Application Se

  • How can i improve speed of my application and reduce data transfer time ? Update:11-30

    Hello, My web application is adobe flex application which is build in flash builder 4.0 and use flex 4.0 SDK. I am using asp.net web service and cairngorm architecture in my project. Front : asp.net c# web project Middle : asp.net c# web service back

  • Is there a way to combine data from multiple responses (collected from different forms)? Update:11-30

    Since FormCentral (FC) doesn't support XFA-based dynamic forms (utilizing form logic), we have a long form that we may need to separate out into smaller PDF forms.  However, the data from each form needs to remain as a group. Wondering if there's a w