Move data from one app to another using SQL

[#1]

Hi,

I want to split an application into two. Does anyone know where is any documentation that will help guide us on this?

I plan to make a copy of the application from the Admin front end. The remove all data using a SQL delete command that has TIMEID =< 20080100 in one application a and TIMEID > 20080100 in the other.

Any words of wisdom please?

Thanks...

[Former Member]

When running a CLEAR FROM FACT TABLE package we get "Object reference not set to an instance of an object" error. Any ideas how to oovercome this?

CLEAR works OK but is very very slow.

[Former Member]

I am getting the same error but running an import package with over 2 million records.

The import fails on the LOAD AND PROCESS step with "Object variable or With block variable not set."

I'm trying to troubleshoot it but appreciate if anyone knows if this is some sort of size limitation issue?

Cheers

A

[Former Member]

Another option is, once you have made your copy of the application, enter the application that you wish to delete the before or after data. From the DM add packages, there is a package to CLEAR DATA from FACT tables. This is the same as performing the SQL statements from the backend. The only caveat is that if you have your Audit Capabilities enabled, you need to temporarily disable them for the clear from FACT process.

Hope this helps.

[Former Member]

Thanks. We will try the CLEAR. The only concern to us is how long it will atke as we are expecting to have to clear aound 60 million records!

[Former Member]

Using the CLEAR From Fact Table is basically a truncation of the data, based on the selections provided, but via the user interface rather than the SQL interface. I agree that it would be bad to use the CLEAR package, which is why the CLEAR FROM FACT is better for this purpose.

[Former Member]

I had nott seen clear from FACT before. That is going to help a lot. I have also discovered Import from Excel and others. Thanks.

[Former Member]

Dear GFS,

You can use the default package, "Clean" to clean up all data or spesific data based on your criteria. If you directly clean data from database, I think that it can be danger because the SAP BPC provide 3 table fact table and have the rules of insert data.

For copy data from one application into another application can use the script logic:

*DESTINATION_APP = xxxx

*ADD_DIM xxx = xxxx

Thanks,

Wandi