OneStream Platform Forums

Happy end of masking!! We are trying to pass multiple months to: wfClusterPkChild We tried to pass Qtr1.base but we get error message. Any suggestions on how to pass M1, M2 , M3 - which are base level children of Qtr1 ? Here's our code: wfClusterPk = BRAPi.Workflow.General.GetWorkflowUnitClusterPk(si, profileName, scenarioName, timeName) where timename is 2022M1 Dim wfClusterPkChild As New WorkflowUnitClusterPk(profileInfo.ProfileKey, wfClusterPk.ScenarioKey, wfClusterPk.TimeKey) --- where timename is 2022M1 - it works great. However, when we tried to make timename = Qtr1.base, we get error message.   When we try to display using wfClusterPkChild.ToString, we see this "ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000"   wfClusterPkChild= ProfileKey (ffb8c7f5-2cc0-48bb-b483-a2c81cb84875), ScenarioKey (0), TimeKey (2022003000), wfClusterPk.TimeKey = 2022003000 

Statement: A parser business rule is commonly used with a data source Question Credit: Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! Come participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

What is the best way to design and implement constant fx rate analysis?  We want to apply a budget rate to all months for actual/fc/budget.  Entities are loaded in local currency and I thought it would be simple to use an entity hierarchy in which I'd put the custom rates at the parent level so during consolidation it would use the set fx rates.  Unfortunately this is not working as I had hoped, I'm not seeing a difference at the parent level between the "real" hierarchy and the constant rate hierarchy. Thank you.

OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !!Does anyone have a sample business rule BR for a column (e.g. K) to Accumulate what is in another column (in Cubeview)?I probably have a written something similar long time ago, but would like to see if someone else wrote a better BR.

Happy "end of forced masking" everyone!    Why can't we log in as user administrator recently? We get message "invalid user or password" Maybe Our user administrator is locked out due to too many attempts to login with invalid password. How do I unlock ? (ps. I read OS Design and Reference guide about enabling users - I see that user Administrator is enabled. 

Hi All - I am trying to copy Base accounts from Actual to Plan Scenario but it is not working when I try to consolidate but it is working when I perform force consolidate. Below is the code and any help would be appreciated.   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyforEntity())) ThenIf api.Pov.Scenario.Name = "Plan" Thenapi.Data.Calculate("S#Plan = Eval(S#Actual:O#Top:I#Top:U1#Total_CostCenter:U2#Total_ProfitCenter)","A#[Corp_US_Sales].Base",,,,,,,,,,,,AddressOf OnEvalDataBufferScrFilter)Brapi.ErrorLog.LogMessage(si,"APIDATA") End IfEnd If Private Sub OnEvalDataBufferScrFilter(ByVal api As FinanceRulesApi, ByVal evalName As String, ByVal eventArgs As EvalDataBufferEventArgs)TryeventArgs.DataBufferResult.DataBufferCells.Clear()For Each sourceCell As DataBufferCell In eventArgs.DataBuffer1.DataBufferCells.Values'Only process cells that have dataIf (Not sourceCell.CellStatus.IsNoData) Then'Apply filtered source cells with data as the new Data Buffer CellsDim

Hi experts, The business users had posted some retained earnings adjustments to both base and parent entities at OwnerPostAdj consolidation level. I have a very simple opening balance rule that works across all entities and consolidation levels: api.Data.Calculate("F#100= RemoveZeros(F#EndBal:T#PovPriorYearM12)","A#<balance sheet accounts>.Base") We are seeing that the opening balance (F#100) member is correctly pulling the OwnerPostAdj numbers for the base entities from prior years, but is not bringing in the opening balance from the parent entities at OwnerPostAdj level. I did a 'Force calculate with logging' and see that the 'ReadDataRecordsinDataUnit' step is showing zero records in the database. However, I can confirm that the journal was posted in M12 at the parent entity and C#OwnerPostAdj level. Any suggestions as to what else I might need to check? Regards, S    

Hi All,   Thanks in advance for the help on this. I am looking for configure the Report Title in a cube to to be aligned left rather than center. In the screenshot below I would like "Consolidated Balance Sheet" to be aligned with Subtitle 1: Left - "Test".    Here is the current syntax I have to move this but it looks like it moving the title left on center rather than aligning it left.   'Move page header left If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelTitle uiItem.Visible = True uiItem.Left = args.Report.CurrentPageInfo.LeftPosition End If   This formula is within the Custom Report Task rules. Cheers, Amar

I may have found a bug in OneStream. I build a small CV - 10 by 3 columns with a row that has column override calling a small Dynamic Calc formula. I'm getting this error message, in System> Error log,  when I run a cubeview. Has anyone seen this error message before.. If you can give me a clue to narrow down, that's fine as well.  Unable to initialize XF App Server Metrics Thread on application server APP01. Access to the registry key 'Global' is denied. ---------------------------------------- Description: Unable to initialize XF App Server Metrics Thread on application server APP01. Error Time: 4/12/2022 4:57:02 PM Error Level: Error Tier: AppServer App Server: APP01 App Server XF Version: 6.1.1.11424 App Server OS Version: Microsoft Windows Server 2012 R2 Standard (6.3.9600.0) Session ID: 00000000-0000-0000-0000-000000000000 Error Log ID: 7053dc3d-9ea3-4da1-b144-d91a4bc70328 Total Memory: 34,359,201,792 (32.00 GB) Memory In Use: 2,713,128,960 (2.53 GB) Private Memory I

We are trying to calculate the variance between two Scenarios using an UD8 member. In Essbase, the calculation below works just fine, but in OneS it returns an error. Any improvement to the formula is appreciated.  

Hi  We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easiest way to do this would be if we could introduce a new layer between the current parent and children. My questions are a) is it possible to do this and if so how? and b) how would this impact reports that are already in circulation? I have tried to illustrate what I'd like to do in the picture below. Thanks

Hi all,   We've recently implemented RCM and I have one issue I'm trying to figure out. Certain accounting teams want to do reconciliations (for SOX controls) on certain accounts that have always had 0$ balances in the account month ends. I'm currently lost on how to get these into discovery - since it seems there has to be a balance at least one time for it to be populated there.   Is the a manual way to add a couple of all-time 0$ balance accounts that way there will be a reconciliation option for it?

Hi I'm struggling to add lines to show Gross Margin % ((Total income less product related costs)/Total income)*100), overhead as a percentage of total income etc. I've tried using Getdatacell referencing the rows but clearly am doing something incorrectly since I get red cells. The formula I have used is GetDataCell(((CVR(Rev_Total)-CVR(RevRelCosts_Total))/CVR(Rev_Total))*100):Name(Gross Margin) where Rev_Total is A#[Total Income] and RevRelCosts_Total is A#[Total Revenue Related Costs]. I'd be grateful for any advice. Thanks

Hi, sorry for such a small issue but hoping to get a quick second look. I input the following to calculate BW percent but the following screenshot with the error keeps coming up, despite the comma I put in. Would anyone know what could be wrong with the syntax?  GetDataCell("BWPercent(S#Working:V#QTD:T#QuarterNext1(|CVTime|),S#Budget:V#QTD:T#QuarterNext1(|CVTime|))"):Name(Var %) Thank you  

Hi all What is the globals object good for we are seeing in all the business rules?    

Hi All,   Does anyone know of a formatting string that will allow us to edit the textcolor of writeable cells in a cube view? I could split out the columns so that we have locked and writeable cells seperately and then we edit the textcolor of all the rows, but what I am looking for is almost a "WriteableBackGroundColor = White", but for TextColor.   I tried using "WriteableTextColor" (a string I tried to derive), but it unfortunately doesn't do anything

Hi all,    We have a simple copy calculation on a forecast scenario that copies in the actuals data for certain periods, defined in a text field. We've had it for years and it generally works fine with no issues. This quarter though, I'm having an odd issue. There are a handful of intersections that are copying only USD values, but not local values and I cannot for the life of me figure out why. ANY suggestions or thoughts on what to review would be helpful!    Here's the calc on the scenario for reference:  Text2 field is 3 (technically "Firstforecastmonth=3") on the scenario and I'm looking at M1. There are about five accounts (out of hundreds) that are off, but inconsistently so there's not one specific piece of master data that seems to be driving the issue. Exchange rates are loaded and the entity with the issues is a CAD local entity that's translated into USD. The part that's truly baffling is that it's only copying in the USD value - here's an example

Happy end of Ukraine war (hopefully)?? We have 9 Windows on-premise servers. 1) How do I know Which one is our OneStream app server, Data Management server etc? 2) I am running Parcel services which writes to OneStream's C:\OneStreamShare\Fileshare\Applications\Will that write to OneStream's application server or DM server?  Parcel services kicks off a Data management job that exports files/reports to that C:\OneStreamShare\Fileshare\Applications\ folder. Thanks for your help.

I have created an extender BR to load from a  xlsx file with xft named range into a custom table. The file is in the OS cloud fileshare in a specific folder. I am 100% sure the file is set up correctly and the path is not an issue, however I still keep getting an error when running the BR from data management that file is invalid or missing. Can someone please help.  Below is the BR . What am i missing   Dim fileName As String = "XFD_Plan1.xlsx" '<-- Enter name of Excel fileDim filePath As String = "Applications\OneStreamDevelopment\Batch\Harvest\" '<-- Enter path to Excel file'Note: dbLocation, TableName, LoadMethod & Field names defined in header of each excel "xft" range.BRApi.Utilities.LoadCustomTableUsingExcel(si, SourceDataOriginTypes.FromFileShare, filePath & fileName, Nothing)

Hello,   I have a use case where I need to get data from siblings (or parents) for a dynamic calc. Entities A,B are part of the same parent EntityC. Cost1 / Entity A : 1000 Cost1 / Entity B : 500 Cost2 / Entity A : 2000 Cost2 / Entity B : 1000 The calculation of the KPI should be as follow for each entity : (0.5*Cost1 + Cost2) / ( 0.5*Cost1:EntityC + Cost1:EntityC). or : (0.5*Cost1 + Cost2) / ( 0.5*Cost1:EntityA+EntityB + Cost1:EntityA+EntityB). (it's the same really) Just to give more fun to it, this formula should be dynamic, as I have multiple entities and multiple parent...   I'm looking for a formula that would help me achieve this ?   Regards,

Where can I find attachments to posts (in community)? Happy Spring everyone!! How can I direct message to community Admin? Our community Admin gave an excellent hint on how to send email notification in link below: https://community.onestreamsoftware.com/t5/Office-Hours/With-respect-to-e-mail-notifications-in-Task-Manager-are-the-pre/ta-p/1453 He claimed to have attached  UTM_EmailLateTasksHelper Business Rule to his answer, but I don't see it.I would like to direct message him and request that he posts his business rule.Thanks.

Happy Spring!!Silverlight no longer downloadable nor supported by Microsoft. However, when it is needed to run OS in IE 11 web browser.  How do I run OS in IE 11 web browser without silverlight? I'm on OS 6.1.1.  I am using OS windows app, but like to run OS in IE 11 web browser simultaneously

We are exporting batches of reports using "Parcel service" - each report is exported to a folder with "2022_March" in its name. At the beginning of April (and every month) I had to go into each report's path and manually change the path to "2022_April" of each output filename-report to reflect the new month.  I think the solution is to extract (export ) the Parcel reports parameters to XML file, change the paths manually, then re-import the new XML file. However, I exported all Dashboards and application - I was not able to find Parcel report parameters.Any idea where to extract them?We Clicked on System> Environment under the Tools menu. - Click on an App Server within the Application Server Sets menu. -On the Configuration tab, there is an entry for FileShareRootFolder; but that's not where the path is defined. 

Hi,Is it possible to extract one dimension member instead of total dimension members from one environment and load the same into another environment? Regards,Madesh K

How can I import data for multiple time period all in one go? I was told that its possible. But wondering what settings do I need to change in order to do that.I tried using "Replace All Time" but the Time is set to "Current".  I'm uploading a excel base file. Any guidance on this will be appreciated.