Skip to main content
Employee - Guide
SergeyEmployee - Guide
Employee - Guide
May 10, 2022 12:49 PM UTC

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 :

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,

    6 replies

    TonyToniTone
    May 10, 2022 4:06 PM UTC

    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
      Member
      May 10, 2022 7:00 PM UTC

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

        Davy
        Aug 31, 2022 2:58 AM UTC

        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?

        MikeG
        MikeG
        Contributor
        Aug 25, 2026 3:16 PM UTC

        Hi ​@Davy ,

        You can grab the Annotation data cell in a temp variable using :

        Dim myText as String = api.Data.GetDataCellEx(“V#Annotation:<your POV>”).DataCellAnnotation.

        Then you can save that in to a new data cell POV using

        api.Data.SetDataAttachmentText(“V#Annotation:<fully resolved POV>”, myText,False).

         

        Bummer your question was never answered, hoping this helps someone who does a similar search that at least there’s an answer to your question in this ticket.

        Regards,

        Mike G

        Anonymous
        Mar 12, 2026 6:37 PM UTC

        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?

        MikeG
        MikeG
        Contributor
        Aug 25, 2026 3:25 PM UTC

        Hello Anonymous person,

        Annotations are stored in the Application Database table ‘DataAttachment’.  Check the AttachmentType column/field, each type of Annotation has a distinct code type.

        Annotation = 200,
        Assumptions = 220,
        AuditComment = 221,
        Footnote = 222,
        VarianceExplanation = 223,
        AnnotationDetail = 300,
        AssumptionsDetail = 320,
        AuditCommentDetail = 321,
        FootnoteDetail = 322,
        VarianceExplanationDetail = 323

         

        Also if you check the Application Security Roles, you can assign a Security Group  to lock and securitize Audit Attachments and Footnote Attachments which can be used in a functional sense to dis-allow activity on a Form, where applicable for users you don’t want to change stuff.

         

        Kind regards,

        Mike G

        Terms & ConditionsAccessibility statement