Reporting on SCDs (Slowly Changing Dimensions)



1 comment

  • Avatar
    Sam Ovenshine

    Hi Dan,

    For cases like this, you can use the RANKASC/RANKDESC functions in the ElastiCube Manager to first provide a rank integer per id as a custom field. Then you can create a new Custom SQL Expression table based on that table, with a self join on the id and one rank +- the other rank. This will allow you to view data from consecutive records within one row. Once you have that, you can use CASE WHEN to flag differences/changes and ultimately use the results as the basis for a widget in the dashboard. For more assistance, feel free to contact Support.


    Comment actions Permalink

Please sign in to leave a comment.