OneStream Platform Forums

 I'm trying to figure out where I can access the Key related to this error. I created a series of new accounts and member formulas by extracting an existing set of accounts from our application.I opened the extracted file in Notepad and performed a find/replace on account names and formula members, saved my changes and uploaded the modified file.When I try to consolidate, I get the same error as above for every account I added this way. is there are way to fix this, short of deleting the new accounts and adding manually within the application? 

First time poster here!  I created a data source called Vista that has 4 different entities using it.  Each of those 4 entities has their own Workflow Profile and each entity is “assigned” to their respective Workflow Profile.   In the Data Source, how do I address this in the Entity field?  Is there a formula I can use to pull the Entity name from the Workflow Profile that is selected by the user?  So if the user is importing the “Chicago” entity (which is assigned to the “Chicago” Workflow Profile), can the Data Source somehow read that?

Hi all: Looking for advice on how to implement multiple parameters in a report book.  The standard loop functionality does not meet current needs.  Our reporting requires a user to specify 3 UD's to report out their area of responsibility.  Each user will have multiple sets of 3 UD's to generate all of their reports.  In theory, they need to 'loop over' this set of parameters generating reports for each set.  However, the standard loop functionality is only 1 parameter and nested loops will generate unnecessary combinations as it would be the cartesian product of all parameters. Example:   Anyone have suggestions on how to implement this?  Is there a way to call a BR from the report book to substitute multiple variables at a time? I envision the ideal state as: User populates a simple CSV file with their report sets consisting of a name, UD2, UD3, UD4, and owner User opens the report book User selects their report set CSV file The report book loops

Hi there, thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersection that got changed by user input to allow admin to revert any changes done by users. I tried using the below:   Dim criteria As New Text.StringBuilder criteria.Append("U1T = '" & ud1_seeded & "' ") criteria.Append("And U2T = '" & ud2_seeded & "' ") criteria.Append("And U3T = '" & ud3_seeded & "' ") criteria.Append("And U4T = '" & ud4_seeded & "' ") criteria.Append("And U5T = '" & ud5_seeded & "' ") Dim dValue As Decimal = api.Functions.GetStageBlendNumber("TestCube", "TestEntity", _ "TestScenario", "2024M1", "TestAccount", BlendCacheLevelTypes.Custom, "Test", _ "TestWorkflowProfileName", "U1T,U2T,U3T,U4T,U5T", criteria.ToString, "Amount", _ BlendNumericOperationTypes.FirstValue) &nb

I want to read a list of members from a excel file which is store in OS file system and store that list of member ID in a list to perform further calculation

Is there a list of keyboard shortcuts available for OneStream using Excel.  Having a hard time trying to find any documentation on shortcut keys that work for OneStream excel addin.

I have SQL Table Editor with about 70 columns. I have the bound column tied to a parameter. But I need to access the value of another column of the selected row based on a button click. I want to process that row in the BR function. PLease help.

Hi All,Setting up the context for the question:I am trying to load the data via 3 different import channels (chan1, chan2, chan3) in a same WF.2 of the import channels (chan2, chan3) are for the sales data load and 1 (chan1) is used to load the historical data for those entities in the similar data unit.  Basically, data from chan1 has data units that is shared between chan2 and chan3. I enabled the overlapped sibling settings to merge the data from (chan1 and chan2) and also for (chan1 and chan3).  The issue I am facing is as soon I load chan1 after loading chan2 & 3, the import channel status for 2 and 3 goes to LOAD CUBE from PROCESS CUBE. If I reprocess the chan2, the status for both chan1 and chan3 gets changes to LOAD CUBE despite of the fact that chan2 and chan 3 have different data units (Both of these channels are hitting different sets of accounts)?Has anyone faced this issue in the application? If yes, please guide me to freeze the status of

We have users that frequently desire to mass updates to their transformation tables.  We use the TRX download/upload process to export current mappings and upload changes.  This works great except the TRX buttons are only available to administrators.  I believe that these should be available to admins along with anyone within the assigned maintenance group.  Is there a way to provision this? 

We leverage many cube view for monthly expense reporting and one particular report will not return values for certain columns that are pointed to a single User Defined dimension, but returns data for other columns.  There are no security restrictions on this or any dimension and the users security is no different that others who have no issue running the cube view and rendering complete data.  Has anyone else run into this or a similar issue?  YTD 6/30/2023     UD4#AlphaUD4#BetaUD4#OmegaUD4#TotalOperating Expenses$100,000BLANK/NA$150,000$250,000

hi,Cell data for the below intersection has been saved into the cube.  Error logs  shows the percentage value getting saved into the intersection. But its not showing up while reteieivng with the Quickview with the same intersection. Any property needs to be updated. UD8 member LRP_Percentage  has been used to store the percentage value.  Thanks 

Hi OS experts,  I want to exclude a base entity - as it must not be affected by the derivative - from its parent for the purpose of this derivative. All entity under a specific parent (ie TDM)  must be part of the derivative expression but excluding one base entity. Anyone knows how I can achieve this? This is my derivative expression ->  

Has anyone used or familiar with OneStream SAP Connector. Need confirmation on couple of questionsIs it SAP certified?Can it connect to SAP On-Premise (with OneStream On Cloud) ? If so what config are needed? Do we need VPN connection? Thanks,Sachin

Mocking up a Prototype using the new Assembly feature in 7.4, I would like to be able to reference an Extender Business Rule within a Dashboard Assembly file. The scenario is, that I have a custom class (POCRunner) in an Extender file, and want to be able to call functions on that class object, when hitting a button in a Dashboard. I can't seem to find the right combination of assembly name and/or dependencies. The argument to have the custom class in an Extender, is also to be able to utilize a Data Management Sequence to trigger a job, calling the POCRunner class.Otherwise open for any other suggestion / approach.Thanks

We have built a custom model in a dev environment and now want to migrate this to a user test environment.  The build includes a number of database tables that we want to copy between the environments as they contain a large amount of data that needs to be used by the user test and will also be required to be migrated to the production environment.  Is there a way to copy database tables between environments, there doesn't seem to be anything obvious in the Load/Extract object list?

Hi all, Is there a way to have the pivot grid in a BI viewer automatically expanded? I've built a custom JE report as a grid but the user has to expand every single column in order to see the JE description for example before exporting in order to get that data on the export. It's manual work where I should be able to set up the pivot to default as expanded or there should be an "expand all" button. Appreciate any direction you can provide! Thanks! -Nicole

Is it possible to show the task progress dialog (see picture below) of a DM task started in a BR. Dim task As TaskActivityItem = BRApi.Utilities.ExecuteDataMgmtSequence(...) ' Do something with task to show dialog? Or is there another way to consolidate from a BR, where it automatically shows the progress dialog?Context: Button -> Dashboard Extender BR to change params -> DM sequence -> Consolidate. I need the Dashboard Extender API on same button press to change params, so can't call the DM/consol directly from button press.

Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. Is this or something similar available? 

Originally posted by Laura Garcia5/29/2018 Excel Add-In Timeout: Client would like to reduce the amount of times they have to log into the Excel Add-In. Where does this setting get adjusted? Anyone know the max you can set it to?

Where is there documentation on the Studio Reporting tool?  I can't find it with any of the Reference Materials.

As we cannot filter the Tree member expansion, is it possible to create a custom Tree?If not as a custom expansion, perhaps a code that returns a tree i.e. XFTreeItem?Dimension:AccountParent1    + Member1    + Member2        +Member2.1            +Member2.1.1            +Member2.1.2        +Member2.2            +Member2.2.1 In the above account dimension, I dont want Member 2.2. I just want the ultimate Parent1, the next level (Member1, Member2), and all base members. The result would be something like: Parent1    + Member1    + Member2            +Member2.1.1            +Member2.1.2            +Member2.2.1 Thx 

hi , Suddenly the custom calculate BR is not getting called from the DM step. The error log statements which added inside the custom calculate BR are not logged in as well. Below is the rule and the DM step.   

Hi there, For a client i want to do a detailed analysis of the data (numbers) in the database. We want to investigate the percentage of numbers < 0.01.However, when i use the Data records i see the following:But in this view i cannot filter on values in the Value1, Value2 etc. columns. In the binary table itself i see as contents of the CellAmounts the following:When i convert this to a string i see a binary code that i cannot read.Does anybody know how to write the select statement in SQL to see the Value fields in the CellAmounts column so i can filter on them? Thanks in advance.

I need to get a list of accounts based on what the cube view I created spits out. The cube view only has one row grabbing all the base children but has suppression on a column that will only show if there is a variance between 2 other columns. Each day the number of accounts with variances can differ and there is another column with a combo box for approve or deny. I need the list of accounts so I can provide the user with a mass approve or deny button

I have tried with the suppressions to make the cells that have 0 disappear but it has not been effective. In the first cell I would show how the data is arranged, and in the second image how I would like it to be