Forum Discussion

Krishna's avatar
Krishna
Valued Contributor
3 years ago

Identify New Member in Dimension

Is there any function or SQL to identify the newly added member in OS ? Ex - If I added an new account and I want to check whether the data was loaded to that new account ?

 

Thanks

 

Finance
  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

     Hi Krishna!

    As a reminder, you can get some reports showing the changes in metatada. It is part of the marketplace solutino Application Reports RPTA.

    If you need further customization, you can use the Audit Table AuditMember.
    In there you will find teh DimTYpeID, the MemberID, then Name ...etc... and also when it was created using the TimeStamp.

    I hope it helps.

     

     

    • Krishna's avatar
      Krishna
      Valued Contributor
      3 years ago

      Thanks NicolasArgente. Appreciate your quick response. It is really helpful. I think I need to use SQL to join few tables and get the results. This would be a good starting point for me.