Discuss the features and functionality of OneStream.
Recently active
I am trying to figure out the best way to embed my monthly OneStream reports into PowerPoint presentations.Do I need install the add-in and have tasks created in task manager? or can this be done through the creation of an extensible documents?Thank you for any help or suggestions,Ricky
Hello- I'm trying to load Headcount into our Finance model as a statistic. The table has no not data fields, just people records and emp ID. When I try to put a "static value" override of 1.00 in the "Amount" source dimension, I get an error stating no data records were found. Any help on how I can load # of records to the "Amount" in the Data Source? This is a Rest API connection to UKGThank You!
Seeking to improve efficiency for user management and security/audit review processes. The OneStream application is accurately showing the user assignments but it's only available in the OneStream application itself and the GUI is not very flexible in viewing the out of the box forms. We have already installed the marketplace solution "Security Audit Reports" which improved our capabilities through a user dashboard and different reports with user details, but it is also only in the OneStream application GUI. As a workaround we have been using the Load/Extract option to pull an XML file and manipulate in Excel.
I have a requirement to display two logos in the report. The first logo indicates main parent entity and the second indicates the child. I tried exploring multiple options but, couldn't find anything positive. So, is there any way/OneStream allows more than/multiple logos that can be displayed in the report? Or Is there any logic that can be built in the Business Rule (BR)?
We upgraded to 7.3.3 and noticed that grouping that are created in excel is disappearing when we refresh the quickview report in the excel add in. If I refresh the report in spreadsheet application, the grouping disappears but at least it is hiding the columns/rows that were grouped. Has anyone noticed this? Is there a fix or work around for this?Thanks
Based on the XML, it looks like I need a reference to the OneStream.Shared.Wcf.CubeViewItem object that contains the CubeView. The CubeView object doesn't seem to have a property for it's Name.Does anyone know how to get the name of the Cube View currently calling a Cube View Extender from within the extender rule?
Hi, We are trying to setup REST API by following the OS documentation. Here we are using Azure as external authentication provider. We are able to get the token successfully, but passing back to the OS fails. Please advise on how to resolve this. Below the error message in Postman, "Error processing External Provider Sign In information. Token Validation Failed. IDX10214: Audience validation failed. Audiences: '00000002-0000-0000-c000-000000000000'. Did not match: validationParameters.ValidAudience: '3ace3d44-xxxxxxxxxxx-2651d589213e' or validationParameters.ValidAudiences: 'null'"
Hi, does anyone have a clue on how to use the Binary Array facility inside the Image component in a BI Viewer? I couldn't find anything in the documentation apart a simple mention. How do I actually load image files inside this Binary Array? Thanks 🙂
Hello Experts, I have a requirement of calculating Cash_ADJ based a sum value of 2 different buffers. If the sum value is Positive I have to post a cash_adj with value from bufSrc2. Is it possible to filter Buffer 1 and write corresponding buffer 2 value to result buffer? Or the approach has to be completely changed for this requirement? If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) Then Dim destInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("A#Cash_ADJ") Dim bufSrc1 As DataBuffer = api.Data.GetDataBufferUsingFormula("A#Cash") Dim bufSrc2 As DataBuffer = api.Data.GetDataBufferUsingFormula("A#Loan") Dim bufSrc3 As DataBuffer = bufSrc1 - bufSrc2 Dim resultBuf As New DataBuffer () For Each newCell As DataBufferCell In bufSrc3.DataBufferCells.Values If Not NewCell.CellAmount > 0 Then Dim resultCell As New DataBufferCell(newCell) resultBuf.SetCell(si, resultCell, True) End If Next
Every dimension needs to be defined in each Data Source 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
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.