gkaindia.com

Home > > How to export data from ODS through Open hub destination ?

How to export data from ODS through Open hub destination ?

Advertisement
Hello Expert,
I ahve some data in ODS.I want to export that data to some thirdt party application through Open Hub destination .How will I do that ??
Eary reply is appreciated .
Advertisement
HD IS :
         1.DATASOURCE
         2.INFOSOURCE
         3.DATASTORE OBJECT
         4.INFOCUBE
         5.INFOOBJECT
1.Assume that info cube existing  with data
2.Create openhuB services
    GO FOR OHD---->select Any  info area ->CONTEXTMENU>Create OHD
     Give the 'OBJECT NAME'----Continue
In OHD Destination type Depends upon 3 types
   1.DB-TABLE
   2.FILE
   3.THIRD PARTY TOOL
  3.Go for the Defination Tab give the File name
4.Create Transfermations
5.Create DTP
OPEN HUB SERVICES WITH -
INFOSOURCE:OHD---DB TABLE SPECIFY:/BIC/OH
1.Assume that info cube existing  with data
2.Create openhuB services
    GO FOR OHD---->select Any  info area ->CONTEXTMENU>Create OHD
    Give the 'OBJECT NAME'----Continue
3.Select Dbfile----->Continue
   Select file location where you want to store file .
    O.Semantic key
4.Create Transfermations
5.Create DTP
Regards ,
Praveenyagnamurthy.
Read the other 17 answers
In BW 3.5, we can use T code RSBO to create Infospoke, In the selection tab, we can use any infoobject in the source infocube as the data filterfor the infoSpoke, e.g I can set company code as 1002 etc, while in the new  BI 7.0, Open Hub Destination,
Hello gurus, I have following screanrio where I need your help / evaluation. Query based on Multicube. Result of this query should be exported automatic to ftp server. I thought about create an APD which export data to ODS. And then via programm read
Hi Gurus, Im loading data from ods to ods thru full update and after that I have to activate that ODS, Kindly let me know the steps for activating the ODS, right click on the ods and press activate data n  ods or before i have to do Update ods in dat
Hi, i have ods it is getting upload from 2 data sources(02_SCL and Generic DataSource), SCL through Deltas, Generic Datasource using Full Load, i want to delete previous day request or changelog. but i dont want to miss the deltas of SCL. this ODS do
Hi All, I am loading masterdata from ODS to infoobject as data target, I am getting an error message as Error message from the source system Diagnosis An error occurred in the source system. System response Caller 09 contains an error message. Furthe
Hi Experts,              I am trying to load data from ODS to IC using Initial load. I failed first time. Then when I am trying to schedule it again I am getting a error message. I deleted the intial request. Even after that, I am getting the followi
trying to activate ods but getting this message that the creation of the export data source failed. and it also gives message that RFC Connection to source system is damaged===> no metadata upload Please can someone help me with this. Thanks in advan
Hi               I need to load data from ODS to Info Cube. I created the Export Data source for the ODS. I can see the Export Data Source but in the Data Marts node of Info Source i cannot find the Info Source for the Export Data source i created. I
Hello I am loading data from an ODS into another ods and cube through its 'export data source'. Now, I want to customize it by writing some routines in the mapping. I am able to write my routines in the upd rules but not in the trf rules. Why is this
Hi, Why Generated  Data Source is available for ODS with out  doing the Generate Export Data Source on ODS. But it is not available for Infocube. Is it neccessory to do Generate Export Data Source for ODS. But with out doing this we can also able to
hi sdn, I'm generating export datasurce at ods but I'm unable to find it out ,i also checked from settings menu show generated objects but when i search <b>8ods</b> i'm unable to find it out. can you guide me how to load data from ods to cube
Can anybody tell me how to export data to a remote server and import data in that remote server without using ftp utility. Actually I want to export the data from a materialized view to the remote server and import the same in the remote server. If e
Hi there,      I have set up a lovely form for collecting data. It all comes into the Adobe Tracker and the Responses file fine.      What i wish to do is export data from the responses file into another format. I should be able to do it from the Exp
Hey Folks, I load data into an ODS, weekly. The data contains status information of a product. The source system delivers only data where the status has changed. If the status for on product is constant over two or more weeks, I get no record of this
Hi I have got one ODS, for which my infopackage is desigen as do not update data if no master data exists for a characteristic. But one of my request which is having only the entries in master data, is not getting activated in ODS.Its failing with th
Hi Friends,            I don’t see any data in my ODS, My loading went fine, then I went to my ODS , Right click > Activate data in ODS , what must be the problem?? thanks in advance,ODS >Context Menu>Manage Go to content tab, check the tables (a
HI Kudos! Please let me know the methods of deleting the data in ODS of all the tables before and after activation. Let me know if any blogs are there. thanks in advance. kalyan Pidugu.Hi Kalyan, As Malli mentioned those are the ways you can delete t
Hello, I am trying to load data from r/3 into the ODS. When i check in the monitor its saying that 07:37:12 ( 549741 from 549741 Records ) But its not turning green.Its still yellow. I checked the new data in the ODS. The number of entries in it is 0
Hai Experts, Can any body tell me data is present in active data table, new data table, change log table and as wel as with this there is a content button it is asking for the table name what is that button consists of can any body help me out Regard