Skip to Content
0
Former Member
Dec 26, 2007 at 03:47 PM

2 conditional foreach

28 Views

Hi Experts,

I am new to SDN.

My friends recommended me that this is a forum where I can ask many experts for some advise.

So, here it goes.

(1) I have a realtime cube where I need to look for records where a characteristic value of a pattern A.

And once this is found, I need to also look for a similar record where the same characteristic value contains pattern B.

When both of these conditions are met, I need to copy the keyfigure value of the record whose characteristic value contains patternB to that with pattern A. I am using FOX.

How can this be done ? Can a single Foreach loop accomplish this? That is, how should i program the fox language to check for 2 types of records?

(2) Assuming the record of pattern B is generated by a program, using record of pattern_A to derive this, and such a record does not exist in the cube, and I put this characteristic value in the copy command:

{pattern_A, kf} = {pattern_B, kf}

i.e

{pattern_A, kf} = <in existent record>

what happens?

will {pattern_A, kf} be assigned a 0?

best regards

Cranberry