Forum Discussion

Ashu_Aswal's avatar
Ashu_Aswal
New Contributor III
7 months ago

How to get the audit for comments

Hi ,

In one of my report the user want to show a column for audit which will show who commented for that variance explanation intersection, can you please help me to get this audit. Please let me know if any more information required. 

Cube View
Reports
  • FredLucas's avatar
    FredLucas
    7 months ago

    Hi Ashu_Aswal,

    You could achieve that by creating a dynamic calc member and having it returning that info for the required POV using the following api:

    Dim objDataAttachmentList As DataAttachmentList = api.Data.GetDataAttachments(memberScript, includeFileBytes, startRowIndex, pageSize)
objDataAttachmentList.Items.Item(0).LastEditedUserName

    Note: it is important that you use one of the text view members e.g.: V#Annotation to show that info.

  • FredLucas's avatar
    FredLucas
    Contributor III
    7 months ago

    Hi Ashu_Aswal,

    You could achieve that by creating a dynamic calc member and having it returning that info for the required POV using the following api:

    Dim objDataAttachmentList As DataAttachmentList = api.Data.GetDataAttachments(memberScript, includeFileBytes, startRowIndex, pageSize)
objDataAttachmentList.Items.Item(0).LastEditedUserName

    Note: it is important that you use one of the text view members e.g.: V#Annotation to show that info.