OneStream Platform Forums

We recently migrated from the legacy “client API” to the “REST API”. They are fairly similar and the migration was straightforward. We use these interfaces to retrieve data via custom “cubeviews”. The cubeviews act as a vehicle for exporting business data from onestream cubes. However it would be more convenient if we did NOT have to build and deploy cubeviews each time we needed a new piece of data. I have not found any mechanism for this yet, either in the old “client API” or in the “REST API”. In other words, it would be nice if there was an “ad-hoc” mechanism for retrieving data programmatically from dimensions and cubes. I haven’t found this yet, in the OneStream “DataProvider” interface. I see that there is an option for running SQL queries but I was told to avoid it since it is low-level and is used to interact with raw/internal SQL tables whose schemas would not be meaningful from a business perspective. In short, I’m wondering if there is a way to extract data progra

I have some experience retrieving structured cube data from the REST API named "GetAdoDataSetForCubeViewCommand". However, I'd like to get ad-hoc information. Ideally there would be another method that is analogous to retrieving data from an Excel "quickview". Did I overlook a "quickview" mechanism in the REST API? I am using the documentation named "REST API Implementation Guide", but it doesn't mention anything that looks promising. Perhaps there may be some undocumented approach? The cubeview already does much of what I need. However it requires preparation (the cubeviews must be prepared ahead of time and deployed to the server). It would be better if the API allowed "quickviews", since they don't require any previous preparation or infrastructure. Currently we are using Onestream v.6.3.0.  

I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard? Currently the dates on the X-Axis are disorganized and are being sorted based on M1x, M2x which causes October (M10) to precede after January (M1). 

Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule? The code: Error log when this spreadsheet rule is used: But if I comment out line number 24, the error log becomes:     

Hi All,  in OneStream 6.x some functions in Business Rules became Obsolete. One of them is the BRApi.Database.GetCustomDataTable where the initial script required a string as CriteriaExpression but now it requires a list of dbWheres. That part I fixed. There are also functions that are not available anymore like: 1) Warning at line 418: 'Public Shared Overloads Function CreateSubstVarSourceInfo(dbConnFW As DbConnInfo, dbConnAppOrFW As DbConnInfo) As SubstVarSourceInfo' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. The SubstitutionVariablesHelper is not available anymore.   Has anyone an alternative to this function (often used in MarketPlace solutions)?         'Create DBConn Infos (Only Used for EngineIfStatement Expression Processing) Using dbConnFW As DbConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbCon

Hi All,Has anyone integrated OneStream with OKTA in their organization to enable SSO login into the OneStream applications? Any leads/suggestions would be appreciated.Thanks 

hi,i have a long running DM job which was triggered from ControlM using the REST API. The problem is controlM couldnt wait for the DM job completion to mark it as completed since the DMjob takes more than 2 hours to complete. Can we write a seperate function which sends back the DM job status from OneStream so that controlM can polls and check for the DM job completion. Is there an API method available which gives out the status of the DM job. ThanksVijay 

Hi, this might sounds like a stupid question to the more experienced people in the community, but how do I refer to the workflow variables from within an extensibility business rule? These 2 lines of code are of course not working: Dim sScenario As String = |WFScenario|Dim sTime As String = |WFTime|   Any hint? Thank you  

Hello, has anyone seen an error like this before? I'm loading information from our PreProd to Prod environment and am getting the following error: "Summary: Error processing XML file type 'DataSources'. There is an unclosed literal string. Line 11771, position 4968693." From what I can tell there isn't anything particularly special about this line of code. It also appears that the remainder of the datasource file was loaded even though this error was received. Any help in this matter would be appreciated.

Hello!We're implementing Transaction Matching and we have a use case to load transactions on a daily basis and run matching each day.  Our TXM scenario has 12 periods, but we're finding that once the data in the Import step loads to the data set and the transactions match, additional files cannot be loaded using the same import step since there are now transactions from the first data set that have been matched. Example: Import transactions on May 1 into 2022M5, run matching - transactions are matched.Import transactions on May 2 into 2022M5 - error - all transactions in stage have to be unmatched first before reloading. Wondering how others handle this - create a separate import step for each day of the month to load each individual daily file and combine them all to load into one data set?  Are there other options?Thanks!Kathryn

Statement: You should not parse data by anything but Entity. Question Credit: Peter Fugere   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   Want more Fact or Fiction? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!

Hi, I have built a Finance business rule that users a data buffer to identify base level UD1 members with data at a specific intersection and sort the results. The user is prompted to select a parent level Entity and that is passed to the BR and used in the buffer.  Note:  The BR is called from a Cube View. What I need to do next is take the parent level Entity that the user chooses, pull in a list of base level Entities under that parent, and then loop through my data buffer for each of those base Entities, and then add the base UD1's to my list if they meet the Text# conditions I check for.  How do I go about calling the base level Entities member list and pass them in one at a time into my Data Buffer so it loops through them? Thank You

Hi I am trying to extract a dashboards  from an application and load into another application, would any one be able to share the XML template that is used for Project Extract & Load? or would appreciate any other helpful suggestions and guidance.    thanks - Kumar 

Hi all,  is there a way a flip sign can be applied to a mask account mapping that contains a complex expression? See screenshot below (partly), the customer created nearly 4000 lines of code in here.     

Hi All,   I'm looking for documentation on best practice to write and NCI calculation? If anyone could point me in the right direction that would be greatly appreciated.   Cheers!

Scenario: I have a Sql Editor component, with a couple of date-columns. If the value in the belonging custom-table is value NULL, then the value in the editor will always be the minimum value of the sql datetime type. I just want to show a blank value instead of "1/1/1900". Anybody solved this?   Cheers Frank

I am trying to utilize the UD2 and UD3 Default Member fields on UD1 members.  For example, I have UD1 members that always go to a specific State.  Nothing is showing up in UD2 for the State after transformation.  Also, I'm not sure how to set up the Data Source for UD2 when utilizing this field since UD2 does not relate to the imported file.   From the Reference Guide UD2-UD8 DefaultThis is the standard default Member that can be mapped for a setting and saves having to map toeach Member. If the setting says Default, the mapping will always go to that default.   Any help on utilizing these fields is appreciated.  thanks

Hello,Is there any way to load a PDF file to OneStream from the Data Sources? What are the steps required to convert the file to Txt (readable format) and can these steps be automated?Thanks,Priya

Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals at each of this level (i.e at parents as well as base entities). When we drill down by origin from a top member and want to further analyze the balances under 'AdjConsolidated' member, we understand that drilling to entities won't give the desired results as the jnls were posted against Adjinput members.    Hence, they have to start the drill down by entities from Origin 'Adjustments' Member and keep checking for each sub-structure below it to see if the jnl comes from an Adjinput / Adjconsolidated member. Is there a better way to directly drill down to the actual jnls that were posted. Regards, SC      

Hello,   I have a question about multiple applications.  I know typically people think of OneStream as having everything within one application seperated by cubes.  Thinking of an application where Planning activities are quite different than existing consolidation activities and I am a bit weary of trying to jam it all into the existing Consolidation application.  I am wondering if it would be easier to organize in a seperate application altogether so there would be a planning application and a consolidation application and the planning data would eventually be loaded into the Consolidation Application after it's approved.  There are a number of reasons that lead me to entertain this idea one of which is performance and that we may only ever want to 'Aggregate/C#Aggregated' the data in Planning and 'Consolidate/C#Local' the data in the Consolidation application and we don't want it to get confusing with what data to use for the users.  Other reasons relat

I am creating a dashboard that compares two different scenarios (one of which is the prompted scenario). I want the header of the chart to display the description of the member instead of the name (i.e., "Forecast 3+9" instead of "FORECAST_3_9." If I input the prompt name into the description field ("|!Prompt_Scenario!|") it will return the name. Is there any way to update this to populate the description instead?

Scenario Today I have a process where I can generate a Spreadsheet with an included Tableview object, and view the spreadsheet output in a dashboard. What I want to achieve is automate the process, so I from a BR function can fully automate the process of generating the spreadsheet, and then save the spreadsheet as Excel to a specific folder, with a given naming convention. Anybody have done something like this? Thanks and Cheers  /Frank 

Has anyone used Git or another version control / source control system with OneStream?  Currently, we keep a lot of commented out code in our OneStream system.   It would be a lot nicer to be able to only have to keep the latest in production, and have a version control system track the changes.    By default ( not that I know how to change it) the OneStream app does  only 1 XML document per type, so the changes aren't tracked at the individual object level, and you'll get a lot of changes to search through.  Has anyone made it work, or are you aware of a best practices document or other doc for this?

Hello, Within a Cube View, I would like to store some "Comments" in a dedicated Row. For display purpose, I would like to adjust the height and the width of this specific row, so it does like a kind of "text box".  I can't find anyway to adjust the height in the "Data Explorer" mode. Any tips, Cheers, Nicolas

I am trying to build a dashboard with a button that opens a scenario dimension page so that super users can easily set up and use a gaming hybrid scenarios.  Is there an XFPage option to open a dimension page?