VarianceExplanation - Number of characters

OSAdmin
Valued Contributor
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 6

OSAdmin
Valued Contributor
Originally posted by Lee Bown

Hi Leyton,

See this KB article 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.

 

435ee64adb60a0503d86c689139619d8.png

 

c16e664adb60a0503d86c68913961901.png


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

 

5aaee64adb60a0503d86c689139619fb.png

 

Lee

OSAdmin
Valued Contributor
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.

 

 

OSAdmin
Valued Contributor
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.

 

 

 

 

OSAdmin
Valued Contributor
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.

OSAdmin
Valued Contributor
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.

8b62f8261ba42c10d238b8c2cc4bcbee.png

OSAdmin
Valued Contributor
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