OneStream Platform Forums

Hi , Can I use 'AdjInput' when loading through the Import channel in a WF? If yes, what customization is required?  

Hello,We are having this below requirement, where we trying to achieve this using Cube View extender rules.Rule should vary margin depending if it's landscape or portrait.If Landscape, thenRight and Left should be 0.25, Top should be 0.75, and Bottom 0.5Else If Portrait, then Left should be 0.75, Right should be 0.25 with Top and Bottom 0.5  Any help or suggestion will be of great help!Thanks in advance.

Is there a way to move the company logo to the right header side of reports? I have applied a business rule to move the report title on the left but now it is hidden behind the company logo.  TYIA!

hi, I  have  custom table created with records  using the finance BR. Second step is to send the data from the custom table to another applicaiton using the connector rule. Is there an option to call the above two rules in single datasource in the above order or it has to be two individual workflow steps.  Thanks

Hi all,Has anyone found a smart way of deleting unused / old cubeviews? Manually deteling one by one takes very long time.Thanks in advance.Buket Pedersen

Hi , We are trying to achieve the below format of Date ,Time and Time Zone in Cube View report footer 25/08/2023 5:00:00PM CT/IST/ET  Here, time zone should vary according to user's local timing.Any solutions on this are greatly appreciated.Thanks  

Dear community, I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'rowname'". I'm not sure what causing this issue. Is it because of the column override I'm using or some settings are driving the issue. It throws error Any solution to this would be appreciated. Please find the attached 2 images of data explorer and report output. The values in the data explorer are displaying. And the in the report it's throwing #ERROR: Rowname. 

Hi Community, Our financial auditors are asking for reports on onestream that they can use to sign of on our trial balance imported into onestream. so that would include movement reports etc. is there a standard set of reports that can be downloaded from Marketplace for this. I see there is something called standard application reports. We are on a cloud version

What are all the options to send data from OneStream to another system?  In my use case, we would be pushing People Planning data from OneStream to Workday.  Thanks for any assistance!  

Hi,We are trying to automate the File-based Import data, Validate data, and Load data to the cube process using the business rule. So, could you please let me know how I can procced as I am new to the business rules in OneStream?Thanks

I have a DM job that imports data using WF.Even though there are intersection validation errors in the WF,Task activity status of the "Validate Intersection" task shows completed. It moves on to importing next period even with errors.Is this expected behavior and is there a setting to show intersection validation failures in Task activity status? 

Hi community, For one of my clients I need to do the following:In cube 1 data is entered on an extended account dimension and extended UD1 dimension. Account dimension         RootAccountDimension                DetailedAccounts (members :10100) linked to cube 2                       GLAccounts (members : 100001, 100002, 100003) linked to cube 1 UD1 Dimensions           RootUD1Dim                   SummaryUD1 (members :None) linked to cube 2                           DetailedUD1 (members :Prop1, Prop2, Prop3, Prop4) linked to cube 1 Account Example is 100001, 100002, 100003 roll up to 10010 which is therefor a parent in cube 1 and is a base account in cube 2. Same for UD1 which has deta

Hello, I am new to OneStream and would like to know if it is possible to attach a file in the Certification step.  If yes, please provide me with the steps.

If (uiItem.uiItemType = XFReportUIItemType.PageFooterDate) ThenDim combinedText As String ' Get the current date and timeDim currentDateTimecurrentDateTime = NowcombinedText = "Date & Time: " & FormatDateTime(currentDateTime, vbLongDate) & " " & FormatDateTime(currentDateTime, vbShortTime) ' Get the local time zoneDim timeZonetimeZone = "Time Zone: " & TimeZoneInfo.Local.Id ' Combine date/time and time zonecombinedText = combinedText & " | " & timeZone ' Set the text in the report footeruiItem.Text = combinedText ' Calculate the left position for the combined text to be right-aligneduiItem.Left = args.Report.CurrentPageInfo.RightPosition - uiItem.WidthEnd If  This is my code to display date/time and time zone in the report footer but the code is not pulling the time zone. My question is, is it possible to pull the time zone?? If yes please provide a sample code  Thanks in advance!

Hi Team,   Hope you are doing well and I would like to know the process to provide access to a particular dimension as user is facing an issue Steps I performed: 1.Created a group under System 2.Created  a user with OKTA verification  3.Updated the group to the dimension in Access Group property. 4.Assigned the user to that Group But user is getting as below Error: Application access denied because user account is not found or has been misconfigured. Contact your system administrator.   Thanks

Hi OneStreamers,   I have a set of scenarios for forecast, rach one must have its own rate tables. Is it possible for me to use only one rate type and combine that with each scenario to input the rates ?  Thank you, Adam

I have a 3 step Data Integration process which I need to automate,1. Extract OS data and push it to DB tables - DM Sequence2. Execute list of DB Stored Procedures3. Import data from DB to OS - DM SequenceI started with an Extender BR calling them using BRAPI.Utilities, but the execution of Stored Procedures itself will take 6-8 hours and the DM Sequence time out before even SP completes.Appreciate suggestions to automate this process. 

Does anyone know if/when OneStream plans on addressing the incompatibility issues between Power Query and quick views/cube view reports? I've got a number of reports that utilize the get/transform functionality in excel but saving an offline version of any reports that contain an @getcell() formulae will wipe out any queries, connections, tables or table-named ranges. Is there a way to avoid this happening via the settings in the excel add-in?

   Hi,I would like to add up all the children of the accounts and put them in the getdatacell, to create a row of Total, both for flow1, flow2 and flow3 

Does anyone have a good solution when viewing dashboards that require scrolling? We have a P&L view set up as a dashboard, which is fed from a cube view, but are hearing a lot of noise around the scrolling and loading of additional data. When a users scrolls down on their report they get the loading circle and need to wait a moment for the rest of the data to load to continue scrolling and get the same thing. Once they reach the bottom they can scroll back up and down without issue. I understand why OS is set up this way, but if anyone has any feedback or input on the different ways they improved their performance on that I would appreciate it! TYIA

We are currently on version 6.6. We use LogonAndOpenApplication via Powershell to login and run DM jobs. But after enabling SSO, the call doesn't work and gives error "Error processing External Provider Sign Ininformation" I can see at below post that it would work in 7.2, but was wondering if anything can be used in 6.6https://community.onestreamsoftware.com/t5/Platform/Excel-Add-In-Macro-VBA-function-Add-Ability-to-Pass-SSO-Token/idi-p/5457

 I'm trying to figure out where I can access the Key related to this error. I created a series of new accounts and member formulas by extracting an existing set of accounts from our application.I opened the extracted file in Notepad and performed a find/replace on account names and formula members, saved my changes and uploaded the modified file.When I try to consolidate, I get the same error as above for every account I added this way. is there are way to fix this, short of deleting the new accounts and adding manually within the application? 

Hi there, thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersection that got changed by user input to allow admin to revert any changes done by users. I tried using the below:   Dim criteria As New Text.StringBuilder criteria.Append("U1T = '" & ud1_seeded & "' ") criteria.Append("And U2T = '" & ud2_seeded & "' ") criteria.Append("And U3T = '" & ud3_seeded & "' ") criteria.Append("And U4T = '" & ud4_seeded & "' ") criteria.Append("And U5T = '" & ud5_seeded & "' ") Dim dValue As Decimal = api.Functions.GetStageBlendNumber("TestCube", "TestEntity", _ "TestScenario", "2024M1", "TestAccount", BlendCacheLevelTypes.Custom, "Test", _ "TestWorkflowProfileName", "U1T,U2T,U3T,U4T,U5T", criteria.ToString, "Amount", _ BlendNumericOperationTypes.FirstValue) &nb

I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation

Is there a list of keyboard shortcuts available for OneStream using Excel.  Having a hard time trying to find any documentation on shortcut keys that work for OneStream excel addin.