Hierarchy from SQL table

[Former Member]

Hello Friends,

I have a requirement for creating Customer Hierarchy from SQL table. Does anyone come across this situation. Does anyone know the procedure. We use dbconnect to extract data from SQL table. Customer attribute and text I extracted by creating views. Just wondering if anyone has done it form SQL tables.

thanks

jose

[Former Member]

Hello Jose,

please check the nativ SQL Documentation of your source Database. Useually nativ SQL supports hierarcical SQL and its quite powerfull !

1. Step: Build and test a hierarchical native SQL

querry with the vendors querry tool

up to the exact needs

of your DataSource.

With Oracle its SQL*PLUS.

Make some thoughts about the extraction mode:

Delta / Full.

2. Step: Make a View out of it. Have in minde that

SAP BW accepts only 9 characters for column

names.

SAP Acceses views and tables in the same way.

With Oracle its: Create ore replace view xxx as

select .... ;

3. Step: Connect the database as a database source system

via SAP BW DB Connect. You might need some

help or setup support form the adminis.

For an Oracle database an adaption of SAP BWs

tnsamens.ora might be necessary.

4. Step: Select the view in the DB sourcesystem

and so on...

If Your sourcesystem is an Oracle database please

check the Oracle SQL Documentation at:

http://tahiti.oracle.com/

Oracle9i documentation, Release 2 (9.2)

list of books

SQL Reference -> Contents

Chapter 8 SQL Queries and Subqueries

Hierarchical Queries

Or call directly:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/queries4a.htm#2053937

You will need a free Oracle Technology Network (=SDN) account at otn.oracle.com.

Good Luck

Martin

[edwin_harpino]

hi Jose,

i think you can create sql view follow the hierarchy format for flat file

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/ab8e3cb4340b14e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/de/113037530b7774e10000009b38f839/frameset.htm

hope this helps.