Matrix data load with entities in columns
Is there a way to set up a single matrix data source for a file with accounts in rows and entities in columns where the entities could change, as well as the number of entities? Can you set up matrix for max number of entities and read entity from specific row?17Views0likes1CommentIdentifying API Parameters for OneStream Audit Log Export via Postman
Hello all, I joined a company where they have implemented OneStream solution. I have access to the platform, and still exploring the way it was implemented. I am currently working on integrating OneStream with an external platform and need to export audit logs using the product's API. While setting up the request in Postman, i've encountered difficulty identifying the correct values for the following parameters: ApplicationName AdapterName Despite reviewing the available documentation, these tags remain unclear. Has anyone successfully queried audit logs via the OneStream API and can share insights on where these parameters are defined or how to retrieve them? Any guidance or examples would be greatly appreciated. Thank you in advance!47Views0likes3CommentsPass parameters through Rest API
Hi All, This is probably an easy one, but I am stuck. I have a Dashboard dataset rule that used FDX to run a query. It takes two input values. I have a data adapter that calls that BR and I can hardcode parameters in there to pass to the BR. Now I am trying to call that Data Adapter using the REST API. I am trying to pass parameters using CustomSubstVarsAsCommaSeparatedPairs. How should I have the Data Adapter set up to accept these parameters. For reference the hardcoded query looks like this: {_GetData}{GetDataSet}{ScenarioName=Actual, TimeName = 2024M3} What do I need to change "Actual" and "2024M3" to in order for it to use the values from the REST API call? Thanks, ScottSolvedFTP File Load Best Practice
When I pull a flat file from an SFTP server, I have been parsing that file in VB .net into a Data Table and loading it that way. Is this the best way to do this, or is there a way to make the Import read the file from the filesystem once it has been downloaded? I feel like parsing a csv file using Split() is risky. Thanks, ScottSolved26Views0likes2Comments- 38Views0likes1Comment
Integration from MS SQL DB to OneStream
Hi Dears, Could anyone please provide me the practical steps to Integrate the MS SQL DB to OneStream. we are at presently testing with the data integration to learn the integration. Kindly provide the real time steps which can work Onestream - On-prem envi SQL DB - Local host regards, BCG38Views0likes1Comment