Cube data not recalculating after value from source changes

Hello community,

I have been working on an issue that a group of users have brought up. Where an attribute was not properly populated in one of our sources. After digging into what the root cause of this being wrong was we updated the information in the HR source. When looking at the Account for the HR source it is showing the correct value of the attribute. After reviewing the Identity Profile Mappings for this source I saw that a transform was being called on the data. Any ideas why these values are not updating?

DATA listed on the CUBE:


Account Data:


Identity Profile Mappings:


Transforms:

{
    "id": "50c9a7a0-5b78-42ef-abea-0b7f808f0bd8",
    "name": "Transform - SecZetta - Location Id",
    "type": "substring",
    "attributes": {
        "input": {
            "attributes": {
                "attributeName": "assignment_location_id_ne_attribute",
                "sourceName": "SecZetta Assignments"
            },
            "type": "accountAttribute"
        },
        "begin": 0,
        "end": 4
    },
    "internal": false
}
{
    "id": "39cc30f7-b140-498d-9ee2-950cff623a05",
    "name": "Transform - SecZetta - Ministry Code",
    "type": "substring",
    "attributes": {
        "input": {
            "attributes": {
                "attributeName": "assignment_facility_id_ne_attribute",
                "sourceName": "SecZetta Assignments"
            },
            "type": "accountAttribute"
        },
        "begin": 0,
        "end": 4
    },
    "internal": false
}

Hi Mark,

You are using Substring Transform for both attributes.

Account data:
Assignment_location_ID: 0922AAFF - xyz
Assignment_facility_ID: 0922A - xyz

Your substring Transform has begin 0 and end 4, which reads first 4 characters.

So 0922 is returned for both identity attributes.

I don’t know what your requirement is here, Incase if you need to get 0922AAFF and 0922A then you need to use split transform which splits using - character.

In this use case I would be looking for just the 0922A for both attributes. Based on the substring transform I would of expected it to pull out the 0922A assuming that the values start with 0 and work up to 4.

In substring, end works as index-1.

So pass 5, it will work.

Ok that makes since. I will give it a try and update you with the results.

This is now updating as expected. And it did not change the values where they only have 0922 vs the 0922A. Thank you for your help on this.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.