Reduce data unit size
Good afternoon, After one of our calculations started to behave slowly, we have been advised that we should reduce our data unit size. Consultant explanation "Real Cell Count is relatively low, at 5 million cells. But to aggregate those 5 million cells, the system will have to request every monthly value for all of those 2.6 million rows from the database, hold in memory which ones have data and keep track of the ones that don't" In this sense, reading the forum, seems the solutions are any (or all) of the following: Leverage BI Blend to aggregate large data sets for reporting Load into Cube at summarized level Always use RemoveZeros() in api.Data.Calculate and api.Data.GetDataBuffer functions Consider different Entity dimension Vertical extensibility (not horizontal) Consider storing some data outside Cube (stage) Just wanted to check if you have applied any other solutions into your projects? as first time we need to reduce data unit size. Thank you,
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..
