Application Build

I used data management jobs to extract historical data from a legacy application and they are now sitting in file explorer and are split-out by period. I need to extract these files to load to a new application. I tried holding shift and control on my keyboard to highlight multiple files but I did not have any success. I believe this will need to done via business rule but I am unsure. Please let me know if I can provide any additional information.

Hi, I have set all security settings on an entity to "Nobody" and yet when I see a dashboard using a non-admin user I still see data. The same when using a spreadsheet. This does not make sense to me. What am I missing? 

I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?

Hello All,Anyone know if it is possible to pass a parameter value into the PLP Register?  I have a method query returning a value based on scenario & year and need that to be the column header in the register.  This is more of a POC than a hard requirement at this point.Any creative suggestions are welcome. 

Hi All, Working with a dialog box with 3 parameters that are being used in a business rule later on. I want the parameters on dashboard load to always show the first value in my delimited list. Right now it always saved my previous selection. I have tried to set "Default Value" in the parameter itself, that dosen't work, guess it is only working on first load? I have tried to run a Dashboard extender BR like below to set param values on load of dashboard, but it dosen't overwrite my previous selection.: Only thing that have worked this far is to set a bound parameter with a set value on my button that opens my dialog box. However it seems to only let me add one bound parameter, I have 3.    Anyone having any advice how I can set one value from my delimited list to always appear when loading my dialog box. 

Hello All, I have a Cube View that I want to use as data source for a BI VIewer object. When I execute this CV, I can see data: When I use this (basic) CV as MD in data adapter, it is empty. I checked the set up steps in the doc and I can't see what I could have missed.   Would you have any ideas why the result table doesn't return values that I can see in my Cube View ? Thanks for your help Matthieu  

Hi everyone, I have to do some systems diagnostics but I cannot run the dashboard because there is an error in the business rule "OSD_SolutionHelper". This business rule does not compile due to an error in line 4882Dim computer As New Microsoft.VisualBasic.Devices.Computer()Error: Type 'Microsoft.VisualBasic.Devices.Computer' is not defined. Anyone else encountering this issue? We are on version 8.4.0.16413. RegardsMartin  

Hi, I am testing V 7.2.3 in our Dev environment. Production is still on 6.5. The security and user groups, data sources, and workflow profiles are identical between the two. I am able to import and validate TB's in the workflow, but several others are not able to Validate in the Dev environment. Has anyone else experienced this?  The validation message is "No Security Access", but the workflow profile and security groups are idential to prod. Thanks!

I created a new dimension member as a child of our direct_department member in UD2.  I have updated all of the transformation rules and mirrored the member properties of its siblings.  I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process.  I'm not receiving any errors either.  Has anyone experienced this or has an idea of where I can look to resolve the issue?

Dear Community,Since I can create a weekly calendar using a customized Time Dim, what is the "Fiscal Year Month Type" such as Fixed week 4-5-4, 5-4-4 in the time profile used for? If it is used for fiscal year purposes, how can I see the impact? I tried to play around time profile, and it doesn't seem to impact anything. Please provide some ideas. Thank you

I am attempting to update the "text" property (which varies by time) for my UD1 members using a business rule that pulls data from a custom table. The update process works as expected without any issues. However, when I remove a data value from the table, OneStream removes the value from the text property, but the corresponding period remains selected, showing blanks (see Screenshot 2). I am removing the data value using the "Else" condition as shown below (Screenshot 1).Can anyone provide insights on how to also remove the period from the selection when there is no value? TIAScreen Shot 1: Screen Shot 2: 

From a button-click, I want to open a different Dashboard, in a new tab (or just open it). It should be fairly straight forward, using: But if the Dashboard I want to open is not within the "Default" workspace, OR, if the Workspace that is hosting the Dashboard is not set to: the function does not work. Smart as I am, it should only be a matter of minutes to figure out the right combination, hereby prefixing the dashboard name with the Workspace name: XFPage=Dashboard:Current.MyDashboardName. But nope. Hopefully someone out there have the right combination to unlock level 2 to the Dashboarding Tour de Master. Cheers Frank

Hello, colleagues, Could you please advise am I right that when I create new user in OneStream application (and indicate his e-mail address in user profile), this user will not receive automatic e-mail notification about this?  

Hello, everyone, Could you please advise if we will need for Budget scenario more detailed accounts, than for Actual scenario, am I right that it will be solved by the following way:     Create second Accounts dimension     Apply this new Account dimension to Budget scenario on tab Cube Dimensions in Cube Could you please also advise how to copy existing Account dimension members into new Account dimension (as the first step before members updating for Budget scenario)?  

Dear User Community: My users have asked me what is the major difference between version 8.4 and soon to be released 8.5. Does anyone have an answer?  Has anyone been part of the beta groups (guessing they have them)? Love to hear because we need to know if we should wait for 8.5. Thanks,SP

Hi All, I am trying to schedule a task in Task Scheduler to trigger a Data Management job every 180 minutes, starting at 02:50:00 AM and ending at 9:00 PM. However, when I attempt to set this up, I receive the following message. Is this a warning, or is it something that needs to be addressed in order to resolve the issue? Thank you for your assistance.  

Hello,We've recently upgraded to OFC 8.4 and after this upgrade, underlying RCM table names have been updated.For ex - XFW_RCM_ReconItems is now updated as ReconItem.Earlier on OFC 8.2 , we were able to query this table using a data adapter as well as in Business rule (DBConnInfoApp) . But now it's not working anymore. Same issue is occurring for all other RCM related tables. It does work for other tables not related to OFC/RCM (for ex - Member).Are there any restrictions in OneStream to query certain application tables? Is there any workaround for this?Regards,GauravTable showing in Application Database: Giving error while querying from data adapter:  

how can i change the Is IC account parameter to true from 2025?  for historical data it should be false

Hi Everyone, I'm designing a form where I display accounts in rows and columns header like Beg Bal, End Bal, Variance, etc. In the rows, I've configured a member filter as follows, which pulls all accounts under the PREPAY hierarchy, but excludes A#150123: A#PREPAY.Base.Remove(150123):Name(|MFAccount| - |MFAccountDesc|) This works perfectly, as it displays all the accounts under the PREPAY hierarchy except A#150123. However, when I try to display the total, I encounter an issue. I'm using the following member filter to display the total, but it doesn't work: A#PREPAY.Remove(150123):Name(Total: Prepaid RF, net)orA#PREPAY.Remove(A#150123):Name(Total: Prepaid RF, net) As a workaround, I have displayed the accounts under PREPAY individually and used the following formula to display the total: Is there a simpler or more efficient way to achieve this without the workaround? TIA

Hi All, I need to access parameter A which is present outside default workspace in my cube view. |!A!| this doesnot work as it only pulls the parameters within default workspace.  

I would like to apply a member filter on a scenario, which will return a list of a scenarios based on it's properties like Name, Description, WorkflowTime, WorkflowStartTime, and WorkflowEndTime...i.e.  WorkflowTime = |someYear| or WorkflowStartTime = |someYear| or WorkflowEndTime = |someYear|I can do this S#Scenario.where(Name contains paramScenario) I can do this S#Scenario.where(Description contains paramDescription)I cannot do this S#Scenario.where(WorkflowTime = 2025)I cannot do this S#Scenario.where(WorkflowStartTime = 2025)I cannot do this S#Scenario.where(WorkflowEndTime = 2025)What am I missing?

Hi everyone, I am very much new to OneStream but i am not able to see any resources for learning about OneStream. Can someone guide my about finding the right sources for getting started and learn the basics of onestream

G'day, Pls share if there is an Excel template for Cubes like the Metadata Builder for Dims and Workflows.That will help us update OS Dimensions in many Data Cubes with various Scenario Types. TY.

Hello All,I want to use application reports Market place solution to get the journals for all workflow profiles. How to achieve this. Currently I get journals for only one workflow profile as per your select WF POV. Is there a way to get the journals for all workflow profiles as a report in one go.Thanks

Hi All I am upgrading the MarketPlace app Reporting Compliance (TCR) so that it has its own separate Workspace (V8.1). I have added the Business Rules as assembly files and they all work. The current environment (V6.8) has a Data Management job to run calculations so I am now adding a Data Management job to the WorkSpace Data Management Groups. The only problem is that when I add a step (type Execute Business Rule) to the Workspace Data Management Step, the drop down list only shows Business Rules in the general Business Rules area and not the file assembly area. How do I get the Workspace specific Business Rules in the Workspace specific Data Management Groups? Thanks