BPC - Copy data from one app set to another

[Former Member]

Hi -

I'm looking for a relatively quick and easy way to copy data from one application set to another.

I have forecast/budget data in a category in app set 2, that I need to copy into app set 1. Is there any way to do this without manually entering it all, or copying over the whole app set 2? I only want the input data for one category from app set 2. I don't want to copy any load data, security profiles, or anything else.

Alternatively... is there any way to copy security profiles from one app set to another, or do those need to be newly created for each app set?

Any help is appreciated!

Thanks!

Sydnie McConnell

Edited by: Sydnie McConnell on Jan 7, 2009 8:06 PM

[Former Member]

If it is from an Application set to another, the best alternative is to export the data in a flat file and import the data in the other appset. If the data is between applications in 1 appset, a quick script logic process may be utilized to copy the data. I would perform a full optimization with compression prior to executing the process to make the data sets smaller and faster.

There may be other alternatives, but those are the ones I utilize.

[Former Member]

Petar, thanks for the quick reply!

One more question for you... would this be able to pick up comments as well? Or just data?

Thanks!

Sydnie

[Former Member]

My focus was only on data. If you need comments, you may need additional tasks from the server, and script logic will not move comments. They are in tables in SQL, and should be easier to move between appsets, but I don't know how they will react, perform when moved, since they are tagged to intesections, users, etc.

[Former Member]

OK. Thanks again for the quick responses and the help!

[Former Member]

I think you can move the comment tables present in the current appset to the comment tables in new appset and if all the users who had submitted comments are found in new appset i think it should work.

Each appset is seperate Database in the MSSQL Server

[Former Member]

Hi Brian

I hope you did backup and restore using the Server Manager

If you are not able to see the data in your id make your user id member of the same admin team where BPC admin is or assign all admin rights to your user id and then check the data.

Else you can just remove your user id and add it back again and assign it.

The reason is: your id is Brian

in the production server it would be: Production/Brian

in the development server: Development/Brian

both are different hence you would have got problem.

[Former Member]

Hi Petar,

In response to your reply -

when we write a script logic, how do we define or include another application?

I have a rqmnt where I want to copy data from one application into another in the same AppSet.

I am not sure how do we include the applications.

Any sample code would be very helpful.

Let me know.

Thanks.

Anand

[Former Member]

Hi Anand

Try below code

Write code in source application and am assuming u are using microsoft version of BPC

*DESTINATION_APP = {app name}

// specify the destination application

*SKIP_DIM= {dimension name}[,{dimension name},u2026]

//skip those dimension which are not in destination app

*ADD_DIM {dimension name}=[,{dimension name}=,u2026]

//add new ones which are found in destination app

*RENAME_DIM {dimension name}=[,{dimension name}=,u2026]

//rename if similar dimensions that of source are found in destination