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,10Views0likes0CommentsInvalid 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..Solved41Views0likes3CommentsCube Views Copying into Default Workspace
When we take an XML extract of an application with Cube Views built within Workspaces and load into a fresh application there are Cube View groups for each of the Workspace groups on the main Cube View screen/in the Default Cube Views. It is essentially making a second copy of all the Workspace Cube Views in Default. Some Data Adapters are then linking to the new Cube Views copies in Default that did not exist in the original application the XML was taken from. Has anyone else seen this behavior? Is this a known bug - doesn't seem like expected behavior?32Views0likes2CommentsSIC Online or Offline?
Hello, i've installed the SIC and it's Online in the "smart integration connector part" as you can see: in the error log i have this error: Summary: Smart Integration Connector Gateway Server Heartbeat has timed out for 'mantu_database_connector'. Current timeout: '5'. Last Reported Error Time: '9/25/2024 7:16:56 AM' UTC. and in the "system configuration part" i have created the a custom database which in i can see that the Mantu_database_connector is offline: if anyone knows what's the error and how to solve your help will be much appreciated. Thanks468Views0likes13Comments