Skip to main content
S
SimpleLove
July 17, 2024
Solved

The Consolidate button is always greyed out in my excel quick view

  • July 17, 2024
  • 2 replies
  • 8 views

Hello OneStream experts:

Thank all of you for the dedicate helps. I build onestream quick view using excel. It seems all the functions in my quick view is working except the consolidate button is always greyed out not matter how I change my POV. I would like to use my quick view to consolidate data to the parent entities. But I can only do calculate and Translate, not Consolidate with quick view in Excel. 

I would really appreciate that someone may tell me how to do consolidate with my excel quick view. Thank you in

advance.


Consolidate_Button.jpg

Best answer by T_Kress

The only way you can consolidate out-of-the-box in Excel is to pull a valid cube view into Excel where the cube view allows a consolidation.  You cannot simply consolidate from a Quick View or XFGETCELL, this functionality does not exist.  So if you have a "Consolidation Cube View" set up, you can bring that into Excel and assuming that cube view has "Can Consolidate = True", then the button will no longer be greyed out.  It is set up this way so the consolidation process is controlled and cannot simply be launched from any Quick View.

Here is a post in Idea Stream that you can like so this is upvoted: JIRA Ticket: PF-19835 (onestreamsoftware.com)

But also, if you search "Consolidate in Excel" in One Community you will find some other work arounds people have posted, like tying in a custom Excel button to a DM sequence to run a consolidation, but again those are customizations.

2 replies

T
T_KressAnswer
July 18, 2024

The only way you can consolidate out-of-the-box in Excel is to pull a valid cube view into Excel where the cube view allows a consolidation.  You cannot simply consolidate from a Quick View or XFGETCELL, this functionality does not exist.  So if you have a "Consolidation Cube View" set up, you can bring that into Excel and assuming that cube view has "Can Consolidate = True", then the button will no longer be greyed out.  It is set up this way so the consolidation process is controlled and cannot simply be launched from any Quick View.

Here is a post in Idea Stream that you can like so this is upvoted: JIRA Ticket: PF-19835 (onestreamsoftware.com)

But also, if you search "Consolidate in Excel" in One Community you will find some other work arounds people have posted, like tying in a custom Excel button to a DM sequence to run a consolidation, but again those are customizations.

A
Anonymous
March 19, 2026

Hi,

This would make sense if calculate and translate were also greyed out. So, the consolidation process is controlled but not calculations or translations? Consolidation is just a calculation on a parent entity, should not be treated differently.

Chris

S
SimpleLoveAuthor
July 19, 2024

T_Kress Thank you so much for the information. It answered my question.

Terms & ConditionsAccessibility statement