Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
3 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 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,

annotations
Cube View
dashboards
Reports

4 Replies

  • TonyToniTone's avatar
    TonyToniTone
    Icon for OneStream Employee rankOneStream Employee
    3 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]

  • Koemets's avatar
    Koemets
    Contributor
    3 years ago

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

    • Davy's avatar
      Davy
      Contributor
      3 years ago

      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?

  • Anonymous's avatar
    Anonymous
    13 days ago

    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?