Recent Discussions
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,Arion9 hours agoNew Contributor II10Views0likes0CommentsMigration of all File Explorer folders and content
Is there a way to migrate all folders and content in the File Explorer from one application to another within the same environment? I looked at the File Explorer Manager solution and it looks like it does the content but not the whole folder structure as well. Are there any other options? Thanks!!Greg_S4 days agoNew Contributor II30Views0likes1CommentChange over to SaaS
We are on 8.4 with OIS and SIC being used in OneStream's Azure environment. We are 99% sure changing over to SaaS is nothing but a flip of the switch in our case, but just doing due diligence to see if anyone had any issues flipping over to SaaS.johnal674 days agoContributor28Views0likes1CommentTask Manager Email Notifications Not Sending with Open Workflow Task Type
Hello, We're in the middle of implementing Task Manager and whenever a task is using the "Open Workflow" task type, it seems not to send a notification email when the task has been completed and ready to be approved. We've tested other tasks and the email notifications work fine. Is this a known issue and if it is, is there a way to get around it? I guess we could set all the tasks to "No Action" task type, but I feel like that would be redundant for them to go to TM and then have to go to the WF instead of being able to click on Execute and take them to the WF. Thanks, Will73Views0likes2CommentsManaging Application Secrets
Hi all, While getting into OS, I'm trying to figure out how to leverage on its framework... And I have a question related to secrets management. Let's say that - at application (workspace?) level - I need to access to a remote service that requires an OAuth token (or user/pass tuple, or whatever I need to keep away from user's eyes - and fingers). The above mentioned secrets should be (visually?) managed by an administrator. Does OS offer something out-of-the-box to accomplish this task ? And, in case, can we leverage on some API to retrieve secret data ? Thanks for Your answers. FabioGSolvedFabioG6 days agoNew Contributor III59Views0likes4Comments- KH17 days agoNew Contributor III42Views0likes3Comments
Cube View formatting
Have a question regarding Cube view formatting. The client has a column for comments where large commentaries are written point wise which currently are seen as one line. They want to view the same like excel where comments are seen point wise one below another. How can the same be done. Also while exporting the report in excel the wrap text option in the Column cell format under excel only wraps the entire cell but it does not show the comment point wise one below anothernupur7 days agoNew Contributor18Views0likes0CommentsOrphan Members
Hi Team, I have a question around the orphan members. I know that when we remove the relationship, the member gets moved under the Orphan section. After moving to the Orphan section, can we load data into the member through the Workflows? Thanks in advance AKSolvedAK8 days agoNew Contributor III2.7KViews0likes7CommentsDecember Journal Entry
I am trying to record an additional Depr Exp in December 2024. Db Depr Exp (P&L) Cr AD Machine &Equip. (BS) However, when I roll into January 2025, the effect of the December entry has been calculated into the BOP Retained Earnings, but my balance sheet does not balance. I can tell the AD Machine & Equip account does not reflect the additional amount recorded in the journal entry. I need to enter this JE into January of the following year, am I supposed to enter this as an unbalanced journal entry, hitting only AD Machine & Equip?Solvedjstasinos8 days agoNew Contributor II21Views0likes1Comment