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