4 Replies Latest reply on May 17, 2018 1:06 PM by Robert Angel

# row referencing from one form to another in the same cube

Scenario - there are 2 forms(A and B) in one BSO cube. Form A has 10 rows and form B has 15 rows. Row 2 of form A is same as row 8 of form B. I want to enter data only in row 2 of form A  and want it to appear in row 8 of form B. Form B's row 8 can be made ready only for its owner. Any idea how to go about it? xref and xwrite would help ?

• ###### 1. Re: row referencing from one form to another in the same cube

It would help if you could elaborate on how many dimension and the form design. But you basically want to identify the Point of View ( POV i.e. The intersection of all the members of dims) at Row 2 of Form A and load that value to POV of Row 8 in Form B. you could write a business rule to write a simple mathematical equation of Row 8 = Row 2. See below an example

 Row2 fy18 sep Account1 entity1 actual 100

 Row8 fy18 sep Account2 entity1 budget

Fix (Budget, entity1, fy18,sep)

Account2 = Account1->Actual;

endfix

• ###### 2. Re: row referencing from one form to another in the same cube

Hi,

This question has already been asked as part of another one by you. I would repeat my answer here.

Is there a need to create a different account for form B? Can you not re-use the account from form A (either share that member under form B hierarchy or just include one row with this member from form A)?

You are not allowing input in it anyway and making it read-only.

Thanks,

Pawan.

• ###### 3. Re: row referencing from one form to another in the same cube

Hello  Pawan,

How do I share the member under a form hierarchy ?
Also, how do I include one row this member from form A ?.

• ###### 4. Re: row referencing from one form to another in the same cube

I think you are missing the underlying principal here.

Data is saved to the database against a combination of all dimensions' members.

If two forms reference the same combination of data then they will both see the same data.

It is that simple.