Skip to main content
A
Anonymous
November 19, 2020

VarianceExplanation - Number of characters

  • November 19, 2020
  • 6 replies
  • 0 views
Originally posted by Leyton de Lange

Hi All,

I am using view member "VarianceExplanation" in a cube view for comments, and I have a question around how many characters can be used in the cell and also if there is a way to wrap text. 

The plan is to use this cube view in a dashboard.

Thanks in advance

 

 

 

 

 

    6 replies

    A
    Anonymous
    November 19, 2020
    Originally posted by Lee Bown

    Hi Leyton,

    See this https://onestreamsoftware.service-now.com/sp?id=kb_article_view&sysparm_article=KB0011156 for number of allowed characters.

    For text wrapping you do not have control of this in the Cube View Data Explorer grid.  However, you can use text wrapping in a grid view Dashboard component.

     

     


    There are also text wrap options for Excel Add-In/Spreadsheet.

     

     

    Lee

    A
    Anonymous
    November 19, 2020
    Originally posted by Leyton de Lange

    Thanks for the response Lee, the data grid you have highlighted in the screenshot is what I was trying to create. Is the screenshot from the Golfstream app or something you created? 

    Looking for options to add a commentary box to a flash dashboard that needs to be dynamic, e.g commentary will be specific to the region that is selected in the dashboard.

     

     

    A
    Anonymous
    November 20, 2020
    Originally posted by Lee Bown

    Hi Leyton,

    The dashboard in the screenshot is actually from a presentation, so not built by me.

    I built a simple example pretty quickly though.

    You'll need a Cube View (left hand side Dashboard) to pass Bound Parameters into the Grid View (right hand side).  The Cube View Component should be set to Refresh the Grid View Dashboard to dynamically display the relevant commentary.

     

     

     

     

    A
    Anonymous
    November 20, 2020
    Originally posted by Lee Bown

    The dashboard in the screenshot is actually from a presentation, so not built by me.

    I built a simple example pretty quickly though.

    You need a Cube View (left hand side dashboard) to pass Bound Parameters into the Grid View (right hand side).  The Cube View Component should be set to refresh the Grid View dashboard to dynamically display the relevant commentary.

    A
    Anonymous
    November 20, 2020
    Originally posted by Lee Bown

    The dashboard in the screenshot is from a presentation, so not built by me.

    I created a simple example pretty quickly though.

    You need a Cube View (left hand side dashboard) to pass Bound Parameters into the Grid View (right hand side).  The Cube View Component should be set to refresh the Grid View dashboard to dynamically display the relevant commentary.

    A
    Anonymous
    November 23, 2020
    Originally posted by Leyton de Lange

    Thanks for the info Lee, what you put together is exactly what I am looking to do. First time I am creating a grid view for this purpose, can you share how you created the grid view?

    Thanks once again for the info, it has been helpful.

    Leyton

    Terms & ConditionsAccessibility statement