The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

Dashboard to show annotations details, footnote details, assumptions, variance explanations ...

Dear Community,   It is very easy for a user to add comments on a given cell, using data attachments : However, what are the reporting possibilities for such comments ? Could we use them...
annotations
Cube View
dashboards
Reports
TonyToniTone's avatar
TonyToniTone
Icon for OneStream Employee rankOneStream Employee
4 years ago

You can create a SQL Data Adapter and assign it to a Dashboard Component to display however you see fit.  The data is stored in the DataAttachment table.  Here is an example of the SQL query from the DataAttachment table

SELECT TOP (1000) [UniqueID]
,[Cube]
,[Entity]
,[Parent]
,[Cons]
,[Scenario]
,[Time]
,[Account]
,[Flow]
,[Origin]
,[IC]
,[UD1]
,[UD2]
,[UD3]
,[UD4]
,[UD5]
,[UD6]
,[UD7]
,[UD8]
,[Title]
,[AttachmentType]
,[CreatedUserName]
,[CreatedTimestamp]
,[LastEditedUserName]
,[LastEditedTimestamp]
,[Text]
,[FileName]
,[FileBytes]
FROM [OneStream_GolfStreamDemo_2022].[dbo].[DataAttachment]