Application Build

Hello, I mistakenly added a sub parent along with 3 base accounts to an alternate hierarchy.  Is there any way to remove the parent child relationship in the alternate hierarchy without removing it completely from the original hierarchy? 

Dear community, Upon saving a Word document, I would like to apply some logics to my document (like data cleansing). My question is, is there an event handler business rule that we could use for that ? Regards,

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.

Hi, We have a Dashboard Maintenance Unit which requires a user to have maintenance access for the object to be able to open the dashboard. In which cases is it necessary to have maintenance access for a dashboard if you don't need to maintain it in the Application-tab?  

.

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?

Hi OS Experts: I have an existing hierarchy called "ControlMgt Hierarchy," which has several rollups underneath it. I need to recreate a new hierarchy named "ControlMgt Hierarchy_ALTERNATE," where "_ALTERNATE" will be added to all the rollups. The base elements will remain the same between the two hierarchies. I’m considering exporting the "ControlMgt Hierarchy" and updating it to include "_ALTERNATE" for all rollups in the XML file, and then importing it into the entity dimension. Is this possible? Will this create a new hierarchy, or will it overwrite the original hierarchy? Could you please suggest the best approach to accomplish this?

Hi, I need to know if I can put security to individual entities assigned to WF so that whoever has access to certain entities can only load/transform/validate for those entities and not all the assigned entities of the WF. Or,creating individual WF per entity is the way to go.

Hi, I am new to the OneStream. We have installed the Capital and People registers in our Dev environment and customized it as per our requirements. Now we are completed our development and are thinking of the ways to move the work to Prod. How do we migrate these registers along with customizations (rename the columns etc.) from Dev to Prod? What are different ways to move the registers from one environment to another?

Hi,What are the major considerations that need to be looked at before making a design decision for implementing "Tax" Scenario Type? What are the pros and cons of using this Scenario Type vis-a-vis "Actual" Scenario Type? Is there any guidance/ knowledge post on the same?Use Case: Want to integrate an erstwhile Tax application into OneStream Application where actuals are already available. The tax application has some additional tax related dimensions, rules, etc. which need to be used in OneStream. 

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 am having XFGetCell formula cells in multiple workbooks (Sheets) within a Spreadsheet.Issue/Problem:When I tried to save a copy of this spreadsheet by selecting (OS Excel Add-in) OneStream/ Save Offline Copy, only the ACTIVE sheet saves an offline copy without the XFSetCell formula (as expected) but the other workbooks (sheets) still shows the XFSetCell formulas.I expected to see all the workbooks (sheets) to save without the XFSetCell formula (offline copy).Please can OneStream release an enhancement to save all the worksheets within a workbook to be saved as an Offline Copy i.e., without the XF() formula functions?

Dear Community Members,I have a spreadsheet rule in my own workspace assembly.The workspace is set to 'shareable'.But the BR does not show up when i try to add in Table View DefinitionWhen i define a rule outside of my Workspace in the regular Business Rule section my spreadsheet rule shows up.Did I miss a setting somewhere to tell Spreadsheet to look into Workspaces?Thanks in advance    

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   

When attempting to upload a form input excel template with around 3,500 lines of data, the system throws the following error - "Unable to load file <filename>. The size necessary to buffer the XML content exceeded the buffer quota". However, when I reduce the number of lines, the file uploads successfully. Does anyone know if there is a row limit for form input Excel templates, or if there's a configuration change that can resolve this error?

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 all,Hope you are doing well. Can someone help me with hint or approach to see account hierarchies side-by-side. Thanks 

I am trying to build a rule to copy data from one year/Forecast Scenario to another e.g Long term and have req to copy data to derived cell value but dont want data to be enable for input.Is there way to copy data? I tried DM job and Custom finance rule but it did not work.    

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

Trying to use IC Member Filter on the account dimension to limit the entities that can be used at IC partners for the account.  Does anyone know the syntax needed; I don't see any documentation on it.  I tried a list of just one entity member name and that didn't work. 

The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate only up to the members directly below the top parent. Nothing else has changed, except the data source. This was working as of a couple of days ago and suddenly stopped. I can see it running calcs fine, but the numbers in regular accounts do not roll up. Any thoughts? I've checked all the properties I could think of and turned off all calculations, but nothing helps.

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

Hello, What happens to the OneStream application when a database shrink is performed? Are there any risks associated with this? Thanks  

Hello All, Is there a functionality of Change of reporting period for entity (From Jan- Dec to Apr-Mar) in OS. For Example, if currently I am working for FY Jan to Dec but in future, I want my FY to be changed to April - Mar, so how can I achieve the changes without getting any impact in the historical data?