Skip to Content
Former Member
Feb 11, 2012 at 05:58 AM

Fox formula FOREACH loop for multiprovider



I have a multiprovider with two cubes Cube A and Cube B. I have aggregation level on this multiprovider and fox formula.

Cube A is having 100 records and Cube B is having 5 records.

I want to loop on this Cube B and for that 5 records need to findout the matching records from Cube A and need to copy the missing field data from A to B. Like in the below example I need to match Cube A and B with Field 1 and need to copy field 2 and field3 data to cube B.

But my FOREACH loop is reading all the records from CUBE A and CUBE B. It is repeating 105 times ( as in cube A i have 100 recs and CUBE B have 5 recs). but I wan to use the loop only on CUBE B and it has work only for 5 times.


Cube A :

Field1 , Field 2, Field 3, Field 4


Cube B:

Field1 Field2 Field3 Field4

AA # # DD

finally cube B sould be like this: AA BB CC DD.

Can anybody through some light on this or any sample code.



Edited by: Senthilkumar Viswanathan on Feb 11, 2012 11:02 AM