The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Invalid Cells in Cube Views
Hello everyone! I am very new to the industry and OneStream and I really need some help to kick start my application building journey!
Currently, I am trying to test out the capabilities of OneStream using the scenario stated below:
I have one central division that will split into two 'teams'. For example, Division_1 and Division_2, both teams have handle their own projects. For example, for D_2, under Project 50A there are mini projects like 50A001 and 50A002. For D_1, under the same project 50A, they handle other projects like M0001 and M0002.
So what I am trying to achieve is:
- Tracking their expenses, so they will roll up to the central Division. E.g. Division 1, project 50A, spent $1,000, Division 2, project 50A spent $1,500. So the rolled up amount would be $2,500 and the ability to breakdown to the specific items.
- If possible (which it is) Division 1 handle projects that are "Approved" so the expenses are actual. Division 2 handle projects that are "Awaiting Approval" so the expenses are 'Budget'.
SO the main issue i am facing right now is that I am unable to manually input data into the cube view that I created and I don't know why. I checked all the settings which allows inputs = True.
I suspect it's my design but yeah I need help please. Below are the photos regarding to my issue. Would really appreciate any help! And advice in designing an application from scratch! Thank you :)
Updated: Figured out that my POV is slightly wrong. But I still can't input data..
Hi
Two things to check:
- Ensure the cubeview is looking at a base member in each of your dimensions - In the screenshots it looks like the Flow dim member may not be a base member.
- Ensure the Can modify data setting in the cubeview is set to true.
3 Replies
MGOneStream Employee
Hi
Two things to check:
- Ensure the cubeview is looking at a base member in each of your dimensions - In the screenshots it looks like the Flow dim member may not be a base member.
- Ensure the Can modify data setting in the cubeview is set to true.
- T_Kress
Given that your cube view cells are free, this tells me that more than likely one of your dimensions is not set to a base member (one possible issue).
Looking at your cube view screen shot, I see "Top" and "TopFlow" on 3 diferent dimensions.
I would start by making sure the cube view is set to a base member for all 18 dimensions. You cannot input to parent members such as "Top".
Thank you so much for the feedback and advice!! I got my Cube Views working :)
Lesson learned:
- The design and thought process of the dimensions that you are selecting for your cubes are very important.
- Base level members and cube view settings.
Hopefully one day I can be proficient enough to contribute back to the community like everyone! Hope you guys have a wonderful week ahead! Thank you so much for your help!
