Application Build

Hi all,Can we schedule a task to run on a business day each month, for example, between the 1st and 7th? I know we can set it for specific days and weeks, but is there a way to make it more dynamic?Any suggestion would be appreciated. Thank you.Best,Jacky 

How I can clear data in Orphans members before Deleting them permanently

Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD8 on columns): TEST is my dynamic calc (also crossed with V#Annotation so it can display text). As you can see, I can write on U8#None and yet the dynamic calc returns READ. Here's my code: Dim sEntName As String = api.Pov.Entity.Name Dim sScnName As String = api.Pov.Scenario.Name Dim sStatus As String = Api.Data.GetDataCell("Cb#CORP:E#" & sEntName & ":C#Local:S#" & sScnName & ":T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellStatus.ToString brapi.ErrorLog.LogMessage(si,"sStatus = " & sEntName & " - " & sScnName & " - " & sStatus) If sStatus.XFContainsIgnoreCase("WriteAccess: False") Then Return "READ" Else Return "WRITE" End If Here's the POV of the first cell (on E#3002:S#Actual): Cb#CO

Is there a way to determine the number of data cells by account-type dimension member? In our example, we are reviewing an implemented application with millions of ZeroData cells and are trying to identify which account formulas are producing the most zero data cells.System Diagnostics has a "Data Volume Stats" tab that lists data cell status counts (i.e., RealCellCount, ZeroCellCount, etc) by data unit. However, there does not appear to be any reports that display this information by account. Has anyone had success retrieving this information via a different application report or custom SQL query (against the application database)? This is probably unrealistic to retrieve (given the data volumes required), but maybe there is a way I haven't yet considered.

I am having to build a lot of alternate hierarchy for external reporting, so I am going and building relationships with our main hierarchy. The problem I am getting into is every time I search for an account (example), OS collapses the hierarchy path where I need to "paste relationship", so I have to reopen it every time, and with a few levels to open, it is getting incredibly tedious. Anyone knows how to stop OS from automatically collapsing hierarchies?

What is the best way to query the Security Roles and their assigned Security Groups in the Application. It would also be helpful to query security roles assigned to Workflows. Any ideas?? 😕 Thanks.        

Hello,The client would like to view forecasted, budgeted and PY data based on a ratio that takes into account current day of the month for Periodic and YTD data.Below, is a functioning calc. Use Case: it is October 22nd, and the client is using daily uploads for Sales. To get a more accurate view of the Sales compared to the scenarios listed above, they want to multiply the monthly total by the factor relative to the day of the month. E.g. if Sales is 100,000 for the October budget (periodic), but it is October 22nd, we would multiply (100,000 by (22/31)), the cube view would show 70,967.74. The calculation in a UD8 member above represents this logic.The tragic flaw is that if view the data in YTD view, it takes the entirety of the YTD amount by that ratio, when I only want the current month to apply the ratio. What would be the best way to approach this? Ideas:Use a ratio that uses total days of year up to end of current periodE.g. In October 22nd, 295 total days have p

I have  a Summary & Detailed Account dimension. The Detailed Account dimension extends from Summary dimension.Ex   Account DimensionCash  Summary A Detailed B Detailed C DetailedI have a Cube where I have set the Cube dimension Properties of a Scenario to use the Summary Account dimension. I was able to load the data at Cash account level as shown above.However when I retrieve the data with BalSheet.Base , OS still treats A,B,C as base member instead of Cash and show up no balances. When I specifically identify A#Cash I get the balances I loaded.Is this expected behavior that OS doesn't treat "Cash" as Base member from Summary Account Dimension? If so is there a solution to retrieve the Cash account as Base.ThanksManoj   

Hello,       We have a View Selection screen with users selecting the columns and the order they want to see as we have a  total of 136 columns to choose from.  This should happen on the 1st tab of the Dashboard. On the 2md tab the sql table editor has to show those columns and the order in which it has been chosen. Any insights on this would be appreciated.    Thank You, Indu

Hi We are evaluating the SIC tool for integration and noticed that API keys and DB passwords are stored unencrypted in plain text files. This is becoming a huge security concern as this way of storing credentials is going to case sensitive data leaks. Not sure if this is already identified by any other client and if it is in the roadmap of fixes? Did any of the clients report this issue?ThanksVidya KadiyalaCN Rail

I am building parameter to pull user defined dimensions descriptions. Anyone knows where it stored in Database?  

In dashboard grid layout . What does the value in column width represents? 1. * 2. Difference between auto and * ? 3. How is the scale of the width measurement ? what is the total width of the screen? 4. What does 2* means ?  

Hi Everyone. I am running an SQL query, but I am now encountering an issue with currency conversions. The only thing my table contains is the column with the currency name, but it is not very helpful because the FX rates table only contains the ID. I would like to know where I can find the FX rate IDs and names in the query, or if there is an intermediary table to accomplish this. The tables I am currently using are: XFW_PLP_Register and XFW_PLP_Plan.

Hello Experts, Is there a way to update 500+ member names in OneStream using XML file. Manually changing each member is time consuming there seems to be no functionality available with XML load?Thank You,Manoj   

Can we adjust the Workflow POV settings in the OneStream Excel Add-in? It would be great if the "OnePlace" tab could also be displayed. Many of our users are more familiar with the Excel add-in, so implementing this change in the next build would be beneficial. This way, they wouldn't need to access the application to modify these settings during the close process.

Is there a way to disable the "Force Consolidate" option from the forms? 

Is there a way to restrict Access to Business Rules for all Users including Administrators through Security Groups? I don't want to encrypt the Business rule.

Hey Community,  So I am wondering if anyone has any smart idea how to split into multiple BiBlend tables when loading a file into workflow with workflow name Blend. My current DataSource is using Delimited files. And I have a column in table that I map towards a attribute dimension which contains of 5 different values. I would like to split the tables based on these values instead of loading file in 5 different workflow steps.  In earlier projects working with data mgmt export sequence data sources I have accomplished similar result by using connector setting "SourceFieldName" to do this. But this option is not available for Delimited File. So if anyone have any code snippet examples on how to hook any businessrule up with the data source or similar that would be extremely helpful!   

Hi Team, Is there a way to set the No Input period property for Scenario dimension using XFBR/Parameter dynamically through DM Jobs. for ex: a new scenario test2, needs to be copied with test1 scenario data across all years (Closed periods + Open periods).The requirement is to have "No Input Period" property as 0 during coping the data and later during consolidation thorough DM step set it to Current actual close period value (i.e for may close it should be 5).   Thank you in Advance.  

Hi All,   I have trying to get the Combobox type of drop down in the custom created data table . SQL Table Editor Searchable Drop-Down List (onestream.com) The above link the documentation to achieve that requirement however it does not work even tough i follow the instruction given in the document. Below are the screenshot of my datatable and parameters.    Kindly help me to achieve this requirement .   Thank You     

Hi, We have a service account setup in our EntraID IdP that is used to call the API. Now that we've enabled OIS, we're having difficulty setting up a PAT for the service account since typically nobody logs into the service account and accesses OneStream, so the account is unable to provision a PAT for themselves. Would anybody have any suggestions as to how to proceed? Thanks!

See the TWO screenshots below, the first is bad and the second is good. In dashboard design mode on some dashboards, what is causing the left panel to be blue? This is the vertical panel that shows all the artifacts in the dashboard.  This is preventing us from seeing which artifact is being selected in the right panel.  In this screenshot the "PDO To Update" label is selected in the right panel but the artifact is not highlighted in the left panel. This makes troubleshooting much more difficult. This is bad In this screenshot, the "Create New PDO" label is selected in the right panel and we can see the artifact hightlighted in the left panel because the left panel is not blue. This is good    

This is a weird question but how can I confirm what version I'm on within a OS application? I used to use the version on the top bar of the log in window in both excel or the OS windows app but I learned today that there's the possibility that our environment version is different than what shows there if the versions are not kept in sync by our IT team.  Any direction would be helpful!  Thanks! -Nicole

In our recent discussion with OneStream team during a demo session, we observed that the version you guys using are different than the version we have meaning the UI, we still use the older version with blue colored interface, but you are using with new OneStream changed version in black color interface, when do we as a user's going to get it.

Hello All, Our customer, who is migrating from BOFC, would like for organizational and technical reasons to keep using his intercompany dimension to capture sales to third parties but would also need to group these sales by sales channels.Their entity structure has a parallel Distribution channel structure (entities that are not part of the consolidation scope).  Is there a way to aggregate only certain IC (the ones belonging to a certain sales channel for example) ?Can we even do an IC reconciliation by grouped intercompany? Thank you in advance for your help/advices