Skip to main content
S
OneStream Employee
SergeyOneStream Employee
OneStream Employee
May 10, 2022

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

  • May 10, 2022
  • 3 replies
  • 0 views

Dear Community,

 

It is very easy for a user to add comments on a given cell, using data attachments :

Sergey_0-1652186848443.png

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,

3 replies

T
OneStream Employee
TonyToniToneOneStream Employee
OneStream Employee
May 10, 2022

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]

    K
    Koemets
    Newcomer
    May 10, 2022

    I had no problem using annotations and assumptions in cube views.

      D
      Davy
      Contributor
      August 31, 2022

      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?

      A
      Anonymous
      March 12, 2026

      Sorry for reviving an older thread but was there ever a definitive answer on the difference between Annotation and AnnotationDetail, besides Annotation being stored in V#Annotation?

      Terms & ConditionsAccessibility statement