how export the data from MS VERSION?

[Former Member]

Hi Experts,

i need to Export the data from BPC MS version and also import the same data to BPC NW version Please guid me how to do this process. 

regards,

kumar

[Former Member]

Hi Kumar s,

Another approach is

If you have access to the back-end database then you can directly download all data from back-end.

In MS version  transaction data stored in three tables.

• tblFact<model_name>
• tblFac2<model_name>
• tblFactWB<model_name>.

Uses of tables

• tbFact<Model_name>- Long term storage after optimized.
• tblFac2<Model_name>- Long term storage.Most of the time, data will be long term stored before being optimized.
• tblFactWB<Model_name>- Real time storage. This is where data is stored when being send to the DB from an input schedule or from a logic execution.

tblFact and tdlFac2 table will show you final data.

write a simple sql query

Select *  from dbo.tblfact.<Model_name>

execute the query you will get all data and then right click on result table and select "save as" you can export all data in ".csv" format

then using upload data in NW version then using  import package you can upload data.

Thanks,

Sushant

[Former Member]

Hi Kumar s,

Please follow below steps

1.you create transformation file for download the data.

2.download data in flat file using export package (Package name:Export From FACT table) then,

3.create transformation file to load data in NW version from the same downloaded flat file.

4.use import package to load data from flat file.

Thanks,

Sushant.