Discuss the features and functionality of OneStream.
Recently active
Hi, I'm trying to copy data from Actuals into Forecast, but it seems to only work for Input and Forms Origin members, and not for Adj. Here is my formula, which I put on the Forecast Scenario: 'Copy data from Source Scenario for months 1-5 Dim currMonthNum As Integer = api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId) Dim sScenario As String Dim ScenarioSource As String = api.Scenario.Text(api.Pov.Scenario.MemberId, 1) If ScenarioSource = "" Then sScenario = api.Pov.Scenario.Name Else sScenario = ScenarioSource End If If currMonthNum = 1 Or currMonthNum = 2 Or currMonthNum = 3 Or currMonthNum = 4 Or currMonthNum = 5 Then If api.Cons.IsLocalCurrencyforEntity() And Not api.Entity.HasChildren() Then api.Data.Calculate("S#Forecast2:A#All = S#" & sScenario & ":A#All") api.Data.Calculate("S#Forecast2:A#All:O#AdjInput = S#" & sScenario & ":A#All:O#AdjInput") End If End If Not sure what I'm doing wrong. Any ideas? Thanks!
Does anyone know if it's possible to access XFStrings through Business Rules? We are adding other languages to our application and we are using XFStrings for Cube Views and Dashboards. We want to present our custom BR error messages in the user's chosen language so we thought XFStrings would be a good place to keep them. However we don't know if it's possible and if it is possible, how to do it. We are currently using Transformation Rules for some other areas but we want to have a single place where the translations can be managed. Thanks
Hi,I have a data management step which runs an extensibility rule. In the rule I am using the “Throw New XFUserMsgException” command to return error messages.For example:Throw New XFUserMsgException(si,"","","Error: Copy cannot be completed. Source Scenario/Year must be different from target Scenario/Year")Gives the following result when conditions are met: When the step completes without error a box message appears, like the following one: How can I control the message shown when the step is successfully completed? I.e., how do I return a message in a box message without throwing an error?
Hi All,We have a requirement where we need to write a custom consolidation rule for Subsidiary(Method) entities.Kindly provide us with a sample business rule along with the functions to be used. so that we can modify as per the business need.Requirement:1) Subsidiary: Entity owned at = 57%.2) The Subsidiaries financial statements are consolidated and eliminated. 3) The Equity associated with the subs financial statements are eliminated against the Holding companies Investment in the sub. 4) The owned portion of Equity is eliminated and the unowned portion is reclassed to Minority Interestregards,BCG
Requesting OneStream to add a DateTime component for easy use by developers, at present textbox has been used everywhere to capture date from users in custom applications.
I am able to display it in data explorer but unable to display in PDF report.
Got a task to copy certain file from FileShare to Documents\Public because users security settings. Wanted to go with the standard System.IO.File.Copy(strSourceFile,strTargetFile) where source and targets are sting. Can get full source file path using the FileShareFolderHelper. However can't get full path to the target, that is under FileSystemLocation.ApplicationDatabase. Any suggestions how can I get the target path or otherwise copy the file in question?
Within the Extender business rule used to integrate with our ERP system I would like to loop through all the "Import" steps within a specific node of workflow hierarchy and to read the values of the "TextX" properties. I've heard that this is possible but have no idea where to start. Any guidance would be greatly appreciated. Yan
Dear Community Users, We have Blank rows and Blank Columns for the space convention. I'm getting 0s for both blank rows and columns while generating the report. I used below condition: and even tried hard coding 'ReportNoDataNumberFormat = #' in all blank rows and columns. Couldn't be able to resolve it. Any solutions to this are really appreciated. Thanks. If (RowName Contains 'Blank') And (ColName Contains 'Blank') ThenReportNoDataNumberFormat = #ElseReportNoDataNumberFormat = [$#,###,0.00;($#,###,0.00);0.00]End If
Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase? M1 .. M12 M1 Value to be shown for FY
In the prior version of onestream we had configured AAD authentication, and we had a service principal that would be used to process REST API requests (aka the onestream "web api"). This service principal was simply to make all the requests for gettting data (cubeviews, adapters). However since we upgraded to 7.1, the REST API has stopped working. Whenever we present the onestream-web-api with the access token from AAD, it simply generates a bogus error: No Supported Authorization Provider Configured. The reason the error seems bogus is because the AAD authentication provider is working for all interactive users. It is only this particular AAD service principal that fails (the one associated with this REST api). We noticed that the release notes for 7.1.0 says: Microsoft is ending support for Azure Active Directory Authentication Library (ADAL) in December 2022. As a result, we have migrated to the Microsoft Authentication Library (MSAL) for authentication
Dear Community Users, As you can see in the above image, last character of the data [i.e., ')'] is getting printed in the next row of the report. I have tried increasing the width of the row. But it's not working. Any solutions to this are really appreciated. Thanks.
Hi I have a dashboard that executes an Import > Validate > Process using a business rule.In my workflow I am currently using Workspace, Import, Validate, Process, Confirm:I would like to just use Workspace, Confirm, but it gives me the following error: "Cannot execute step because the specified step classification doesn't exist for the workflow profile." Is there anyway around this? Thanks,Mark
We have a requirement to make all the negative value to encode in parenthesis () and to display percentage % for the column "Variance vs Prior year %" in the Cube View. Anyhow, we have written formatting condition as"If (ColName Contains '%') ThenReportNoDataNumberFormat = [#,###,0.00;(#,###,0.00);0.00], ShowPercentSign = TrueEnd If" and it works perfectly fine in the data explorer tab. But while running it in the report it displays only parenthesis () and the percentage sign is missing. The above is the screenshot from data explorer tab. The above is the screenshot from while running it in the report.
Originally posted by Erin Nielsen Hello, Is there a way to easily copy over our Budget Scenario and all of the data in it, into a Budget V2 Scenario, so that i can add data to the Budget v2 Scenario? Essentially allowing the app to have two versions of the budget? Thanks, Erin
Hi, Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below: If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the Profit Centre column. If I select Entity B in the Entity column, I would like PC3, PC4 to be options within the Profit Centre column. I have tried using 'Selection Changed Server Task' to update a Literal Parameter that I can use as a basis for a Bound List parameter that I am attaching to the Profit Centre column , however this only appears to work after the row has been saved: I think it may be possible if the user was to save the row after choosing the Entity and then selecting a Profit Centre, but this wouldn't be an ideal user journey. Thanks, Mark
A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.Help me out in reframing the above formula.Thank you.
Hi guys,I coudn't find the proper hint in OneStream.In my dashboards, I'm using several XFBR string rules or Dashboard extender rules. I would like to move some of them to Workspace assemblies, available starting version 7.4. If I do so, does anybody know how to call a function in there?Stupid example, I'm defining the position of a temporary file to download with an XFBR rule called MyXFBR, function CleanUsername.UrlOrFullFileName=[Internal/Users/XFBR(MyXFBR, CleanUsername)/Temp/FileToDownload.csv] Now I've created the same function CleanUsername in a Workspace assembly named MyAssembly, in a file named FolderManagement.vb. How this should be amended?XFBR(MyXFBR, CleanUsername)?? XFBR(MyAssembly, FolderManagement, CleanUsername) ?? it doesn't look very good.... That's pretty new, but I hope a few guys in this community have used it already.
I am having an issue where the the logo assigned in application properties is not appearing on exported PDF reports. I have sized the image to 50 pixels in height and have set the "ReportIncludePageHeader = True" on the cube view header format. The logo is still not appearing. Are there any other settings that need to be changed for it to appear on the reports?
Hello, did anyone find the OneStream Foundation Handbook useful for learning the software? the copy I see on amazon is from 2021. Are there different editions available? thank you.
An allocation business rule is not allocating the rates properly . Hence we would like to debug the business rule and also figure out which intersections are passed and what is the value and allocation rate used in allocation calculation . This allocation process involves a formula in UD7 member . Please advise how to see the messages used in api.logmessage . Should we need to create a dashboard to capture the messages that are logged while running the allocations. Again, we are looking for which members used and the value / rate used to allocate.
Every dimension needs to be defined in each Transformation Rule Profile created. Question Credit: Chul Smith 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
When we open a Spreadsheet Table View from a Dashboard we would like the Content Pane to be hidden.
I am trying to write a parser business rule to pull out the middle portion of a date string from a data source. The file has the date as "1-Jan-23" and I want to pull out the Jan. On the data source, I have the time dimension assigned to the proper column in the file. The month is always 3 characters, and the year is always 2 characters. I am getting an error that I am unable to execute the BR. Can I not use args.value for the starting point of my parser rule ? Dim filetime As String = args.Value Dim filetimelen As Integer = filetime.LengthDim startpos As Integer = filetimelen - 6Dim month As String = filetime.Substring(startpos, 3) Return month
OneStream V7.0.1We have a Data Source that takes data file that has 12 data columns Oct ... Sep.The year for the data in the 12 data columns is a field "Fiscal Year", the first column of the data file.We have a Parser BR that is called on each of the 12 data columns that looks at the first field in each record to get the year and concatenates that with the M<number> month for each month column to give the correct Time dimension member in which to store the data. e.g. 2023M1The problem is we're getting the row header "Fiscal Year" instead of the year value in the record, so the string being returned looks like Fiscal YearM1How do we get the year data from the first column instead of the column header? Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As ParserDimension, ByVal args As ParserArgs) As Object Dim fiscalYear As String() = {"Oct","Nov","Dec""Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"}
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.