OneStream Platform Forums

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

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"}

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