OneStream Platform Forums

Re-posting. I hope this time it is in right community.------Hi All,We are a large OneStream shop with 700+ users.  The system is in use for last couple of years.Currently our system is hosted in our own Azure environment and managed by our own infra team.We are currently reviewing to see whether we should continue with the same or should we go for OneStream Cloud Managed Service?I would love to hear from fellow OneStreamers following:1) Are you currently using OneStream cloud or hosting it on your Azure / Data center?2) Ours is a very complicated system with multiple group regulatory reporting as well as some LBU planning & budgeting apps on the same environment.   While speaking with a colleague, he told me that from his past experience, the system performance wasn't as great on the Cloud compared to customer managed environment.  Is this the experience of all OneStream customers out there?3) How's the support experience with OneStream Managed support?4) Did yo

I am trying to save the XML files in the application zip file as separate XML files rather than a single zip. I get the zip file as a byte array and then pass that to XFZip.Unzip The code executes without an error and without any files being saved as well. Does anyone have any suggestions or can point out where I am going wrong with the code?  OnPrem V7.4.2 Dim xmlOptions As New XmlExtractOptions xmlOptions.ExtractAllItems = True Dim folderNameForExtract As String = "XMLs" Dim extractPath As String = $"{Environment.GetEnvironmentVariable ("Temp")}\{folderNameForExtract}\" 'Execute the Metadata Extract Using dbConnFW As DBConnInfo = BRAPi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si) Dim zippedBytes As Byte() = ApplicationZipFileHelper.Extract(dbConnFW, dbConnApp, Nothing, xmlOptions) XFZip.Unzip(zippedBytes, extractPath) End Using End Using  

Afternoon All, I'm looking to create a set of standardised confirmation rules as Finance Business Rules which I then want to reference from the confirmation rule itself to cut down on maintenance. I'm pretty sure this is possible and I've seen some other discussions but I can't quite figure out the code to use in the confirmation rule to trigger the finance rule. I've seen Dim sharedFinanceBR as New OneStream.BusinessRule.Finance.RulesName.MainClass as an option but this syntax doesn't seem to be available in the confirmation rule code. I think maybe it only works in only business rule types? Is anybody willing to share their code please? (Just the part that triggers a public function from a confirmation rule). Thanks! Richard

I need to update the properties (Constraints/Texts) of 20.000 UD members based on transformation rules.  The script runs in 10 seconds, but once I add the 'SaveMemberInfo' method it surpasses 2h ... I tried both 'MemberInfo' & 'WritableMemberNoCache' with no performance enhancement Dim ListofU1Stores As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, dimensionName, myStoreFilter, True) For Each oStore In ListofU1Stores 'MemberInfo ''Dim myStore As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimType.UD1.Id, oStore.Member.MemberId, True) ''Dim StoreUDVMInfo As UDVMProperties = myStore.GetUDProperties() 'WritableMember Dim objWritableMember As WritableMember = BRApi.Finance.Members.ReadWritableMemberNoCache(si, DimType.UD1.Id, oStore.Member.Name) Dim objVaryingMemberProperties As VaryingMemberProperties = BRApi.Finance.Members.ReadMemberPropertiesNoCache(si, DimType.UD1.Id, oStore.Member.Name) Di

Hi, Has anyone had success with viewing the GolfStream reporting formulas such as Return on Assets or Asset Turnover?  I'm trying to learn how to write some ratios and it would be so helpful to view these.  Unfortunately, the formula is greyed out.  Please see below.    

Is there any way to export a list of orphaned entity members?  We pull in hierarchy information from SAP and recently over 1000 entity members were blocked in SAP.  This resulted in them going into orphan status in our OneStream instance when we updated our metadata.  The issue is that some of these orphans had data and that is causing reconciliation issues.  If I could export a list of the orphans, I could match them against all of the SAP entities that have data to determine which orphans needed to be restored.  Thanks!

where can i find the files imported in the workflow steps, I can't find em in the File Explorer.Thanks

During the import step of a workflow profile, where does data gets stored before arriving to the staging area ? I am using an Event Handler to manipulate loaded data before it gets saved to the staging area. However, I am unable to retrieve it before it gets stored into 'SourceStageData' Table.Data appears in the database only after the operation named 'WriteTransformedData'.  Are loaded data rows stored in memory and processed, then gets saved to the table 'SourceStageData' after operation 'WriteTransformedData' ? How can I access the loaded data before it gets processed (parse and 1st transformation during 'Import' step) ? Intellisense is not working on the 'Transformer' Object, so I can't search for a property/object holding loaded data: [Dim objTransformer As Transformer = DirectCast(args.Inputs(0), Transformer)]

Although account member appears to be in Detailed dimension. The error says account member doesnt exist in dim        

Update: Found out the user ID is actually supposed to be a Guid object and not a string.    I have a data table which contains a list of UserId's. Currently, I need to convert those UserId's into usernames. I have been attempting to use the variations of the '.GetUser' api. With this test, I have been unable to actually fill my variable with user info for analysis. Is there any known workarounds for this situation? I confirmed that .GetUser works with the username, just not with the UserID.  Below is an example of my scripting, the string is of the userID I obtained by testing on a username.   

Dear Community, Whenever we use the drill down in OneStream, there is a call called "Calculation Script" at the very end, which in my case is never populated. How is it used ? Are there any way to access it / populate this cell ? Regards,

G'day ONE members, There are blanks for some rows in certain Dimensions in our source data files.1. In DS w/o using a Logical Operator, pls share how to map those blanks to new values, and/or2. In TR, please share how to map those blanks to new values. Thank you.

In my cube view, I need a column (% of net sales) to calculate each row/divided by net sales. In the selected column I am trying to only solve for actual. For example actual gross sales/actual net sales, and then actual sales rebates/actual net sales, and so on down my P&L. There must be a way but I have not found anything useful. I'd greatly appreciate any help.  

I am using BIViewer within the dashboard. This BIViewer uses a data adapter of Cube View type. Now, every time the dashboard refreshes, the Cube View runs and the task activity shows a Cube View entry. How can i avoid the task activity entry?

When adding a new member to my dimension I received the following error message when I tried to save it.  "Error saving member.  "B4632' already exists.   I did a search on that dimension and hierarchy and got the result "no items were found".   How can I determine why it will not let me save this member?  How can I find it?

Hi everyone, I'm having trouble logging a databuffer to the error log. I want to be able to do this to debug some code I've written. I got this concept from the Finance Rules and Calculation Handbook so I believe it's possible but I can't get it to work for me! In the first screenshot is the code. The red box shows the logdatabuffer script that I've written. I know there is data in the databuffer because it produces sensible results  (ie. the green box) albeit not quite right, hence why I want to visualise it. The second screenshot shows what I see in the error log. I believe I should be seeing the databuffer results in the orange box area but I just see a blank. Do I need to "switch on" this functionality somehow? What am I doing wrong?!!! Thanks in advance,Richard  

Hi there! I am trying to use Postman to run a DM job sequence. I test the DM job locally and it works fine with no parameter.I am using Azure SSO to log on the server.I can retrieve a token from microsoft for my tenant ID using : https://login.microsoftonline.com/bec456-my-t3n4nt-id-e2aba/oauth2/v2.0/token (In green in the printscreen) On my second RestApi call, I use the token I retrieved and I drop the token under Authorization > Bearer Token in Postman.Because I need to run a sequence the URL is : https://aiqos.io:50001/onestreamapi/api/DataManagement/ExecuteSequence?api-version=5.2.0 and the body is : { "BaseWebServerUrl": "https://aiqos.io:50001/onestreamweb", "ApplicationName": "GolfStreamV65", "SequenceName": "RestApi", "CustomSubstVarsAsCommaSeparatedPairs": "" } I also created an admin user in OneStream that matches the Application (client) ID found in Azure. (In red in the printscreen)The on the back end in the server config, I added the OS Werb Api Cli

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?

Hi OS Community,  Was wondering if anyone has visibility into or can point me in the direction to update the Environment Color in an application?   I know it can be done, thinking it might be the Config Utility or SNOW request, just having trouble finding documentation on the process to update.  The guide says all you need is admin access:  But I'm finding that not to be the case in multiple environments Any help would be greatly appreciated!      

Dear community, I am working on a graph that shows the daily FX rates.  I am bringing the data in through an SQL Data Adapter and have set up the following settings in regard to the data and what is shown on the x-axis: Data is shown in days, but the x-axis name are 'summed' to the months.  This works great except for the fact that it writes the month as full. I think it's based on the Time Dimension Description because the date format in the data table is: MM/DD/YYY As you can see the graph is quite small and the naming takes up a big part.  Does anyone know if it's possible to adjust the sourcing of this naming/description? Maybe to a UD8 TimeDescription member or adjust the description of Time in the graph itself, or maybe through the data table or data adapter?    Thanks in advance!      

I would like to set a transformation rule that particular account can be map to 2 accounts with condition +/- amount. Example, if positive go asset account, if negative go liability account. I had tried derivative rule is seem not working. After validate it become go to both accounts. Is there any missing caused the rule not work properly?        

Looking for function in the business rules to derive prior quarter based on the year and month value passed from parameter?

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm").  Can anyone provide the conditional formatting text that would replace the actual % variance with text?

In the D&R document it is mentioned "Using Extensible Dimensionality to extend Accounts used within the Intercompany Matching process is not a recommended practice".  is there any particular reason for this? or is there any documentation showing this as an example?

I want format the Cube view cell based on cell amountIf (CellAmount > GetDataCell(CVC(Col2)) )ThenBackgroundColor = Red, TextColor = WhiteEnd if This code is not working, Actually I am comparing actual amount with budget. how can we do this?