Skip to main content
Newcomer
May 26, 2026
Solved

Empty cube view for pasting data

  • May 26, 2026
  • 1 reply
  • 0 views

Hi,

Is there a way to paste values from Excel into an empty cube view? I get read only cells with pink background. I tried already to use A#None

Any help is appreciated.

Best answer by giutor73

Normally when you are looking at Invalid Cells it is a Point of View Issue.  I would check your POV on the cell and make sure that it's truly where you are looking to load the data.  If you need additional assistance, you can always open a support ticket so the team can take a look at your cube view report to get a better idea on why the cell is showing as invalid.

Hope this helps.

 


It was an unassigned constraint in the dimension I was using. Thanks again for your time.

1 reply

OneStream Employee
May 27, 2026

You should be able to paste values form an excel spread sheet into a cube view in data explorer, however the cells would have to be base level cells and allow for input (white Background).  

Example:

These cells were copied form an excel worksheet into the Cube View and then can be saved

 

 

Is this what you are asking, or am I misunderstanding the question?

Thank You

 

giutor73Author
Newcomer
May 28, 2026

Thank you so much for replying, yes it's exactly what I'm trying to achieve! I get this and the cells are not writable:


No invalid intersections but I can't paste any data. General Settings->Common->Can modify data is set to true.
Is there any other settings?