New applications without data

[Former Member]

Hi,

Duplicating an existing application set into a new application set merely copies all the dimension data. The new applications themselves are empty.

How do i copy data from the existing applications into the new applications?

Cheers

[sorin_radulescu · Accepted solution]

Yes it is working also in that case but you have to use other sql sintax:

select "list" into AppSetB.dbo.tblfactApplicationB from AppSetA.dbo.tblfactApplicationA

the same for other queries.

Regards

Sorin Radulescu

[Former Member · Accepted solution]

Hi Sorin,

I will try your method later but i will just work on Apshell data at the moment, because my manager needs something up quick.

Cheers

[sorin_radulescu]

It is important about what version of BPC are you speaking.

If you speak about microsoft version I think the easy way is to copy data between fact tables of the two applications.

Example:

ApplicationA to copy into ApplicationB

Into query analizer of SQL server you have to run a script like this:

select

select "list of fieldds" into tblfactwbApplicationB from tblfactwbApplicationA

select "list of fieldds" into tblfactApplicationB from tblfactApplicationA

select "list of fieldds" into tblfact2ApplicationB from tblfac2ApplicationA

Regards

Sorin Radulescu

[Former Member]

Hi,

I am using BPC 5.1

Does your method apply if i am trying to copy data from application A which falls under application set A, to application B which falls under application set B. They have exactly the same dimensions.

Cheers