Skip to Content
Former Member
May 13, 2011 at 02:59 AM

Script logic question



Here is the scenario, I have a dimension(lets call it ASSIGNMENT) with 4 properties - lets just call them property A,B,C, and D. Property A,B, and C are basically dimension IDs from other dimensions. Lets call them Dimensions X, Y, and Z. So why have dimension X,Y, and Z's dimension IDs as properties and another dimension? because some combinations(Decided by business) of X,Y, and Z's IDs result in all the future data loads to reassign the value of dimension Z. These rules of which combinations will result in reassignment from data loads are stored in the dimension ASSIGNMENT. Now my issue is how to write a script logic(that will be included in default script logic) that basically goes through each record thats coming in, then looks at each rule(row) of dimension ASSIGNMENT and if any data records the property A, B, and C combination - then reassign dimension Z ID to property D value for that rule(Row). Please tell me if this is possible. thanks.