Skip to main content
K
Krishna
October 4, 2022

Identify New Member in Dimension

  • October 4, 2022
  • 1 reply
  • 0 views

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

 

1 reply

N
NicolasArgente
October 4, 2022

 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.

 


2022-10-04_16-15-18.png

 

K
KrishnaAuthor
October 4, 2022

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.

 

 

Terms & ConditionsAccessibility statement