Identify New Member in Dimension

[Krishna]

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

[NicolasArgente]

 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]

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.