Forum Discussion

Ashu_Aswal's avatar
Ashu_Aswal
New Contributor III
11 months ago
Solved

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 k...
Cube View
Reports
FredLucas's avatar
FredLucas
Contributor III
11 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.

  • Ashu_Aswal's avatar
    Ashu_Aswal
    New Contributor III
    11 months ago

    Thank you very much FredLucas for this solution. This worked perfectly.