I managed to load the data with no errors. Now I can see the data in worksheets. However, I had to use the existing (seeded) item and location levels in the data model.
To investigate what I was doing wrong, I again tried to load the data by creating new item and location levels in data model.
These are the steps I followed to add new levels --
1 - Add new columns in T_SRC_LOC_TMPL, item and sales from external tool
2 - Inserted the relevant data into newly added columns
2 - Right click on the existing level and select "Create Relation" and selecting the appropriate table and col names in Select Source Data.
3 - Now when I try to rebuild the model by selecting "Upgrade existing model". Its throwing error
Error: ORA 20001: ORA 20001: ORA 20002 -24344 ORA-ORA-24344: Success with compilation error in PACKAGE BODY DATA_MODEL.BUILD_CHECK_DATA line 3095
Am i missing any important step of adding a new level? Can someone please advise if what I did is making sense and help me resolve this.
Thanks for your response.
- Try changing the existing level to point to a new column
A - This was throwing the same error I mentioned.
- Populate the required data in the seeded columns and use the existing columns instead of new columns , you can realign the levels accoridngly
A - Using existing cols are working fine. Problem aries when I want to add new levels.