Forum Discussion

JoelBeh's avatar
JoelBeh
New Contributor
12 days ago
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: 

  1. 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.
  2. 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..

 

 

Extensibility
Infrastructure
  • MG's avatar
    MG
    11 days ago

    Hi

    Two things to check:

    1. 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.
    2. Ensure the Can modify data setting in the cubeview is set to true. 
  • MG's avatar
    MG
    Community Manager
    11 days ago

    Hi

    Two things to check:

    1. 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.
    2. Ensure the Can modify data setting in the cubeview is set to true. 
  • T_Kress's avatar
    T_Kress
    Valued Contributor
    11 days ago

    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".

  • JoelBeh's avatar
    JoelBeh
    New Contributor
    10 days ago

    Thank you so much for the feedback and advice!! I got my Cube Views working :)

    Lesson learned:

    1. The design and thought process of the dimensions that you are selecting for your cubes are very important.
    2. 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!