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

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

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

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

Thanks for sharing this Jose Luis! 
I've always wanted to implement something like this but I forgot the PAW/View behavior with hiding the element instead of removing it from the subset. 

Hi,

I think this may help you.

IBM Planning Analytics Workspace - Advanced Conditional Formatting

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