Palo Community Forum

Hello
How can I compare the values ​​in the two cubes in two different dimensions.
The algorithm is as follows: in the first dimension, I am taking the first element and compare the value with the values ​​at the intersection of all elements in the second dimension, and then take the second value from the first measure and compare again with all the values ​​from the second dimension

Not a very clear description, but in short, to get the result, I use 10 of these rules (because of the number of elements in the measurement of "1-10"), and I would like to make one, because in reality, the number of elements will be much greater.


The rules is next:
['JobValueF'] = IF(PALO.DATA("_122_", "OperXJobs_Cube", !'1-10', "JobName") == PALO.DATA("_122_", "jobsDets", "1", "JobName"), PALO.DATA("_122_", "jobsDets", "1", "JobValue"), CONTINUE())
['JobValueF'] = IF(PALO.DATA("_122_", "OperXJobs_Cube", !'1-10', "JobName") == PALO.DATA("_122_", "jobsDets", "2", "JobName"), PALO.DATA("_122_", "jobsDets", "2", "JobValue"), CONTINUE())
['JobValueF'] = IF(PALO.DATA("_122_", "OperXJobs_Cube", !'1-10', "JobName") == PALO.DATA("_122_", "jobsDets", "3", "JobName"), PALO.DATA("_122_", "jobsDets", "3", "JobValue"), CONTINUE())
.
.
.


I think it's something like a cycle that must be placed in the specified location

['JobValueF'] = IF(PALO.DATA("_122_", "OperXJobs_Cube", !'1-10', "JobName") == PALO.DATA("_122_", "jobsDets", CYCLE, "JobName"), PALO.DATA("_122_", "jobsDets", CYCLE, "JobValue"), CONTINUE())