Dear all,
We have BI 7.0, but I used 3.x to create a customer hierachy (the data is from a CSV file). The levels are Division - Area - Region - Territory - Customers
I followed a blog and completed all the steps, but only got 1 record loaded to the PSA. There are few things that I did not get it.
Blog - /people/prakash.bagali/blog/2006/02/07/hierarchy-upload-from-flat-files
Inside of this blog
1. 2.2 Creating Info Source: Why does Step e's structure different than step f?
2. Our flat CSV file structure matchs step f. I created an InfoPackage, and only 1 record got loaded to the PSA. The structure same as Step e but not f. I was really confused.
3. 2.4 Uploading the Hierarchy Data into BW, step d. This step displayed the hierarchy results. I guess I must missed something. After data gets loaded to PSA, is that everything? How to load the data from PSA to the hierachy table?
4. Our data will be coming from JDE, does anyone have the program that can generate the CSV file?
Thank you!