OneStream Platform Forums

We are creating a Dashboard for data integration and to execute consolidations (our process is multi step) ... We are wondering the following:Is there a Dashboard template out there for download so we dont have to build from scratch?Can animated .GIF be utilized in a dashboard or just static images?

Hi All,   Can anyone help me with row Division Formula in Cube view, I have tried below one but getting error. Please suggest GetDataCell(Divide(CVC(Row7), CVC(Row2))):Name(CM%)     Thanks in Advance.

How to install the Golfstream demo application on cloud? I have downloaded the GolfStream65 references material from MarketPlace. After unzip it, it was some .mdf and .ndf files. Since I'm on the cloud version, I am not able to access to the server. What is the possible way to install the Golfstream demo on cloud version?

We are using XFString to present text on Cube Views in different languages. It is documented here: https://femsadev.onestreamcloud.com/OneStreamWeb/Help/Content/Design%20and%20Reference/Presentation/Reference%20Alias%20via%20XFString.htmI don't want to prompt the user for their language - is there a way to use the user's culture code and suppress the prompt?Thanks

SOURCE: ONESTREAM CHAMPIONS Hi Team, Greetings for the Day. We have a requirement to download the registers data into an Excel Book with all Account as different Sheets and that too from within one stream. One STream table view is the best option provided to fetch the data from one stream. The question here is we have 100+ Accounts in there, which we need to bring in the tabs, and to achieve that we need to add all tabs 1 by 1 under Spread Sheet - Table view (Refer to attached screenshot). Is there any automatic way to append the Table view with all accounts tab names using some macro or inbuild One Stream Functions?     image.png1114×546 39.1 KB    

I noticed that the application tables have an odd time format in column called timeid   is there another table that houses the times in 2023M3 format or is there a way to convert this column easily when using it in a SQL data adaptor?

Hi, We are working on Consolidation application with 'OOB and Store share' algorithm type. Came across an requirement to eliminate balances on few GLs with C#Elimination and O#Elimination member. Below calculate function worked randomly for few entities (step consol structure) and not for all. Any suggestions to improve on below logic ? Thanks   If api.Pov.Cons.Name.XFEqualsIgnoreCase("Elimination") Then api.Data.Calculate("C#Elimination:O#Elimination = (C#Share:O#BeforeElim) * -1", _ "A#OtherAssets.TreeDescendantsInclusive.Where(Text2 = Others)", _ "F#EndingBalance",,"I#None","U1#None","U2#None","U3#None", _ "U4#TopSide_Adj","U5#None","U6#None","U7#None","U8#None") End If        

Hi. I am trying to forecast OpEx accounts based on a seeding method. I am storing the method on a specific month by account and some UD dimensions and based on the selected method want to apply different math for those combinations. The issue i am facing is that when looping through my original data buffer, where the methods are stored, i need to change the Scenario, Period and View member for the looped databuffer cell and then sotore that value. E.g. if the method stored in 2023M1 is 3MthAvg, i need to grab V#Trailing3MonthAvg:2023M1:S#Actual for each data unit that is being processed (All months for 2023 Budget scenario).     Dim driverDataBuffer As DataBuffer = Nothing Dim calculatedBuffer As DataBuffer = Nothing Dim destinationExpressionInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("V#Periodic:O#Import:U5#NoChannel:U6#NoCustomer:U7#NoProject:U8#None") driverDataBuffer = api.Data.GetDataBufferUsingFormula( _ "FilterMembers(C#Local:" & fir

Finance Business rules can be referenced in Confirmation Rules to ease maintenance. 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

Hi, I want to retrieve into a Business Rule and pass it on to a CubeView row label the value stored in a UD text property. ie UD4 Text3 for example presuming that this is relative to the current Workflow Scenario/Time setting In snippets I have found this : 'Dim sValue As String = BRApi.Finance.UD.Text(si, dimTypeId, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId) I am aware that the Text1 property attached to the WorkFlowProfile has the folowing attributes to get the various values stored under each TextN property field.Attribute Index Is: Text1 = 18000, Text2 = 20000, Text3 = 22000, Text4 = 24000 So what is the appropriate syntax in a Business Rule that I could bring in the UDN TextN values. Thanks Mark    

Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.

What is the best approach to point to a different field in a Direct Connection Data Source. I am familiar with importing both local and USD currency (not using translation) by selecting the appropriate columns in a Delimited File, and this has worked fine in the past. I am now trying to do the same in Direct Connection to a Data Source. I tried using the Set and Get Global Variable as shown below, but the results are not as expected. For example I am expecting a USD value of 15482.72 and it is returning 22.61, this value is not even close in the set of data rows returned by the SQL query. Here is the complex expression I have in the Amount Field:And in the Functional Functional currency field I have the following complex expression: Any help is greatly appreciated. 

How does fragmentation on the OneStream Datarecord tables impact performance? I have an application with a lot of tables having fragmentation > 90%, but how big of an impact does this have on performance? Or do the Datarecord tables/logic/databuffer work in a different way? Any knowledge/experience on this?   Cheers Frank

Hi all, I have a dashboard with an SQL table editor component. Through the component in the dashboard, I can save text to the table, including special characters. For example, there is no problem in saving a string containing α (alpha).   Now I am trying to load a CSV file to that same table. The file contains some special characters too. To load the file, I have built a business rule which contains the following command: loadResults = BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, SourceDataOriginTypes.FromFileUpload, filePath, fileinfo.XFFile.ContentFileBytes, "|", "App", "LOAD_TABLE", "Merge", lfieldtokens, True)   The special characters are not recognised, and this is the result when loading TestNameαβπ.   Is there a way to load the CSV file and preserve the special characters?

Hello All,  I am new to OneStream trying to write a Value Override business rule for some investment accounts, The rule works without account filter. How ever I want to restrict this to Accounts with Text2 tag as "CADOverride". Somehow the value becomes zero if I have the Text 2 filter and not sure where am I doing wrong, (I am currently just checking if text 2 is not null and it seems to be retuning empty)   Dim foreignCurrency As String = api.Pov.Cons.Name If ((Not api.Entity.HasChildren()) And (api.Cons.IsForeignCurrencyForEntity())) Then Dim overrideAcc As String = api.Account.Text(api.Pov.Account.MemberId, 2) If String.IsNullOrEmpty(overrideAcc) Then Select Case foreignCurrency Case "CAD" api.data.calculate("F#EndBal= RemoveNoData(F#CADOverrideInput:C#Local)") End Select End If End If   How should I proceed to troubleshoot this? Any ideas are appreciated, Thanks, Manoj

Hello Everyone, I need to rename a few entities as user provided incorrect names. They loaded data already and I am wondering what are exact implications of renaming them now. I tested renaming and I can see that drill down to the source data is not possible I found another topic on this forum and I cannot find any other implication other than with drill down >>> Entity Name Changes - OneStream Community (onestreamsoftware.com) I did not find anything in documentation Can anyone confirm that this is the only implication of renaming dimension member? That drill down to the source is no longer working? Of course I know that if those entity names were used in cube views, business rules, formulas, etc., then I need to adjust them (but thankfully this is not the case here).   Kind regardsJarek

An api is passed in, but typed as Object, what is object type of the correct/most efficient API to use in an Extensibility Rule to call Members.GetBaseMembers()?

I want to have an account that has a calculated value (rounding it to thousands), and then allow a Forms input adjustment to it for footing reasons.  The calculated value would have a UD4 of "Calc", and the input would have a UD4 of "Footing".  As soon as I make the account calculated it doesn't seem to let me input to it with the other UD4.  It shows in white background indicating you can input, but I can't put anything in the cell.  Anyone know if what I'm trying to do is possible?

Does anyone know if it is possible to rename a cube? I am happy to execute SQL queries if that's what it takes. Failing that are there any shortcuts for copying a cube (with all the workflows)? We have copied an application but one of the cubes (top level for workflow) must be renamed as it is out of place in the new application. Any comments or ideas will be welcome. Thanks

Hello,I was wondering if it's possible to change the workflow year to show FY20XX instead of just 20XX. In our legacy system we used FY20XX as our current year and we would like to continue with that style. I cannot seem to find a spot where to change it but I've seen images of other workflows with the year showing FY20XX. Thanks, Will

We're trying to export a Form into Excel and we are receiving the following error.  Has anyone had this error when trying to export a form into Excel?   Thanks

Hello Everyone,    Is there a way to force the composite expression to run before the One To One Rules ?  i am trying to run a complex expression to override values coming from the Source Data. but the One To One Mapping is triggering the mapping, what i want to Select all BS accounts from source based on the Target mapping , and import UD2 as a None Value . Instead what is happening is that all the BS accounts with UD2 value are being Mapped based on the One To One mapping i did for the PL Accounts. and i only want the PL accounts to have a UD2 Value.      

Hello,Well, the title is quite explicit 🙂I am trying to avoid the standard workflow panel as often as possible. Right now, I would like for the user to select the workflow profile just by clicking a dashboard button component and access this menu : Is it possible ? Regards,

Hi,   ParamA will be a multiselect combo box and the same should be passed to business rule as well. May I know how it can be done? I'm passing the parameter in calculate button, then DM step and then to BR. Calc button : {seq_name}{ParamCC = |!ParamA!|} DM step: {|!ParamCC!|} BR: Get value of ParamCC Need suggestion on how should it be passed if parameter is multiselect. thanks

OS Version 7.3.3My files are stored in a Named Workspace, "Finance WS"I want to open a file stored in Finance WS.  How do I get the workspace guid to accces the file? Dim guidWs as Guid = ???BRApi.Dashboards.FileResources.GetFileResource(si, False, guidWs, strFilename)