on 07-21-2004 12:33 AM
I created a DB Connect to BW itself to read a table within table.
I'm trying to create the datasource but when I choose "Display Table Contents" it says "No data in this table".
Does someone have any ideas on why I'm not able to see the data but I'm able to see the fields for selection.
Thanks,
Teresa Kallab.
Hello,
Have you checked the DBConnect OSS note for your database? We are running SQL, so the note I had to use was 512739. I think your table is not meeting the SAP naming convention. Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Teresa,
I didnot understand 'read table within a table' phrase in your posting. If you want to extract some data within BW, you can create a generic extractor using RSO2 within BW instead of usning a DBConnect.
Thanks,
Gopal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gopal,
Thanks for your answer. I know I can create a generic extractor using RSO2 but my problem is that the business requirement is real time.
There's a customize table in BW that it's being update everytime a user makes a change in Manugistics Application(another source sytem - forecast application).
If I use a generic extractor to load in BW this data I need to run every 5 minutes a load to the cube. If I use DB Connect I don't need to load any data. I'm able to read the table without loading the data.
What I'm trying to create is a DB Connect to the table. I'm able to see the table and the fields of the table but I'm not able to display data with the option "Display Table Contents".
Thanks,
Teresa.
Hi Teresa,
Just refreshing my memory regarding the BW 3.5 delta features, it appears that for direct access needs you can not use DB connect, but you would need UDC (part of BW 3.5). Perhaps that may be the reason why display table contents using DB connect isn't displaying data.
If you would like to query a BW table (which gets updated from another source system realtime), perhaps you might want to use an infoset query. Just my opinion.
Cheers,
Sree
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.