@HspNthMbr

@XWRITE

I am using PBCS Calculation Manager.

My goal is very simple: copy from one set of accounts (A) to another set of accounts (B) in the same cube (GL)

Set B accounts were sourced from another cube (Payroll). Accounts are dense.

A1=B1

A2=B2 etc

 

The solutions could be:

1. Using @XWRITE data from Payroll cube to GL cube for the corresponding Set B accounts. (time taken to complete rule: 8 hours!)

2. Using a rule A = B for respective accounts in the GL cube (2 hours).

3. Using member formula in A for value =B but this will need the members in  A to be Dynamic Calc. This is not feasible as Actual data are loaded into the members of A.