Planning Analytics

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

Hi Glen,

It's not possible...yet.  The 2024 Planning Analytics roadmap includes many additional enhancements to cube viewer formatting.  This includes formatting options to set the background color of the cell based on the properties of the cell (e.g rule derived, consolidation).  These sort of enhancement will appear in the new format manager interface (https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wnibr2-use-new-format-manager-format-cube-views). 

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

Stuart - are there plans to allow conditional formatting by an attribute on the row/column dimension? This alone would help so much with formatting. 

Hi Glen,

It's not possible...yet.  The 2024 Planning Analytics roadmap includes many additional enhancements to cube viewer formatting.  This includes formatting options to set the background color of the cell based on the properties of the cell (e.g rule derived, consolidation).  These sort of enhancement will appear in the new format manager interface (https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wnibr2-use-new-format-manager-format-cube-views). 

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

Hi,

I think this may help you.

IBM Planning Analytics Workspace - Advanced Conditional Formatting

YouTube		remove preview
IBM Planning Analytics Workspace - Advanced Conditional Formatting Declan Rodger (Technical Director) shows how to apply "advanced" conditional formatting to your IBM Planning Analytics Workspace (PAW) applications. Examples include highlighting which months are Actual vs Forecast and validating users' inputs! View this on YouTube >

Regards.

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

That video gave me exactly what I needed.  Thank you

Hi,

I think this may help you.

IBM Planning Analytics Workspace - Advanced Conditional Formatting

YouTube		remove preview
IBM Planning Analytics Workspace - Advanced Conditional Formatting Declan Rodger (Technical Director) shows how to apply "advanced" conditional formatting to your IBM Planning Analytics Workspace (PAW) applications. Examples include highlighting which months are Actual vs Forecast and validating users' inputs! View this on YouTube >

Regards.

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks

Hi,

I think this may help you.

IBM Planning Analytics Workspace - Advanced Conditional Formatting

YouTube		remove preview
IBM Planning Analytics Workspace - Advanced Conditional Formatting Declan Rodger (Technical Director) shows how to apply "advanced" conditional formatting to your IBM Planning Analytics Workspace (PAW) applications. Examples include highlighting which months are Actual vs Forecast and validating users' inputs! View this on YouTube >

Regards.

We want to be able to change the colors that are used for rule cells based on a global assumption, such as actual month should be Green, and budget months should be black.  Does anyone know if it is possible to change these colors?

Thanks

Glen Banks