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
OneStream Employee
OneStream EmployeeDashboard 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 in dashboard, for instance to be shown as footnote of a dashboard ? Or could these be used as footnotes in pixel-perfect pdf documents generated from a cube view ?
Many thanks,
4 Replies
TonyToniToneYou 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]I had no problem using annotations and assumptions in cube views.
Can you please give us a clue how to display or copy annotations in a cubeview's cell to another cell - using XFBR business rules?
