OneStream Platform Forums

Hi,Is there any way to remove the empty rows which are showing up once a cube view is used in an extensible document or in narrative reporting?Thanks,Florence

Hi all, I am sure this topic has been covered before, but I am looking for what the community is doing in terms of rounding issues (as they apply to CV's). Especially in the case of when financial reports are scaled (to thousands or millions). Are most just jamming differences in via forms as needed. Is there some sort of automation that can account for rounding issues?  Any advice would be most welcome and appreciated here. Thanks!  

Hi Everyone.I want to copy the information from one scenario to another. Currently, I’m using the member formula of the target scenario to transfer the data. However, I first apply a calculate to set the values to zero, followed by a clecarcalculateddata to properly remove the existing information. The issue is that after this step, the copy process doesn’t execute, and the scenario remains with zero values. My code is as follows: api.Data.calculate("S#FORECAST_" & monthNumber & "_AT_CY_BUDGET_RATE = 0*(S#FORECAST_" & monthNumber & "_AT_CY_BUDGET_RATE)",True) api.Data.ClearCalculatedData("S#FORECAST_" & monthNumber & "_AT_CY_BUDGET_RATE",True,True,True,True) Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("S#FORECAST_" & monthNumber & "_AT_CY_BUDGET_RATE") '' Create new Databuffer for the results Dim resultDataBuffer As New DataBuffer 'Base Entity at Local If Not api.Entity.HasChildren And api.Cons.IsLoc

Hi OneStream experts,I was looking to understand if it's even possible to handle the load button from the Load/Extract section in OneStream using a specific EventHandlers of any kind.I need to be able to add validations whenever a Metadata xml file is loaded through the Load/Extract to check certain things of its content without falling (as usual) in a custom development from scratch.Hopefully someone is able to assist.Thank you!

I'm looking to add user names to the workflow status report we've already created but I can't seem to find where in the database tables that info is tracked. We've manipulated the WorkflowStatus method query to pull in the WF steps and the status of each. For example:  I reached out to OS support and they pointed me to these two posts, one of which mentions CertifySignOffInstances. Workflow Confirm and Certify Users Info | OneStream CommunityDisplaying user names on the workflow status report | OneStream Community I can also see WorkflowLockHistory as a table but any thoughts on which other tables store workflow status by user info? Appreciate any direction you're able to provide!  Thanks! 

Hi All,How would I go about passing a Consol member as part of the POV to a  FDXExecuteCubeView call? I want to pull one extract that is in Local currency and another that is in USD.  Can I do that with this call, or do I need to set up 2 cube views, one set to Local and another set to YTD?Thanks,Scott

T#2027:V#Periodic, I'm pulling the correct YTD P&L numbers for 2027.T#2027:V#MTD, I'm only getting the December number.How can I get the MTD number corrected on the total Year? It should match Periodic? Thanks.

Hi Everyone - Where do we have setting to configure Read/Write access to the folders in FileShare?  

In Grid view on the Account Dimension, when attempting to update the IsIC setting for an account I receive an Internal Server Error.I'm able to update the Is IC Account on the Member Properties view, however in Grid view it returns the error below: 

Please share your practical advice to help us assess the Data Size by Scenario by Year.- I failed to find existing KB or posts to help us meet this Data Size requirement. 🤯 Thank you folks for sharing your expertise.

Does anyone know what replaces the 2 utility commands below?  I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available?BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated.Thanks,Jun 

Hello, I would be very grateful if someone could offer some direction on fixing the issue of dynamically generated parameters disappearing on a refresh action. When the dashboard initially loads, all of the dynamic parameters render as expect. I have an extender service setting the count of parameters to 2 for each param type (Debits,Credits). These work off two stored member list parameters, par_DebitList and par_CreditList.When the dashboard is refreshed, I lose the _dynamic_2 even though the parameter count is still 2. Public Function GetDynamicParametersForDynamicComponent( _ ByVal si As SessionInfo, ByVal api As IWsasDynamicDashboardsApiV800, ByVal workspace As DashboardWorkspace, ByVal maintUnit As DashboardMaintUnit, ByVal dynamicComponentEx As WsDynamicComponentEx, ByVal customSubstVarsAlreadyResolved As Dictionary(Of String, String)) _ As WsDynamicParameterCollection Implements IWsasDynamicDashboardsV800.GetDynamicParametersForDynamic

Hi, For the v8 to v9 upgrade, it seems like we need to remove our custom tables and add them back after the upgrade. We have scripts to add the tables back but what is the process you follow to export and import the data back. Table Data Manager or write a script to save csv file to OS folder and load it back? Thank you in advance, Praveen

Hi Everyone,If end user enters negative value in the input form. Save button or form should not save the value.Do we have any solution for it?

Hi I am trying to understand the event handlers to see if we can leverage them to improve user experience and put some controls around recurring issues.   But the documentation is not helping. I think I figured the events in general and when they execute but can someone please explain the purpose of "Is Before Event", "Can Cancel", and "args.Inputs(x)" Thank you in advance, PM  

Hello!  What's your company's way of tracking OS changes and pairing them with approvals? Do you do it manually with a report out of OS that you put in excel and numbered to match the saved approval email in a shared drive? This is how I did it in a previous role where the changes were more manageable :)  Do you create a custom database table in OS and add a field to tag to those OS change reports to a ticketing system you're managing outside of OS?  Trying to brainstorm a more efficient way that meets auditors expectations but doesn't involve creating a full time role to pair changes with approvals. Any suggestions on how your company accomplishes this would be very much appreciated!  Thanks, Nicole

Hi all, for one customer we need to prepare a an input file template with cube views to deliver correct metadata (dimensions). The Idea is to prepare as much data and metadata from the applicatoion for the user as possible. We were not able to find a solution how to retrieve a list of all entities when the user has access only few out of all. So we switched to the Table view.We created a dashboard containing the spreadsheet with the template that is refreshed at load.The trouble is refresh itself. If I have a blank spreadsheet and add the table view there, the refresh (TV or the whole Sheet) is almost instant. If I have the template with just some Cube Views, it is also very quick (few seconds). But refresh of the same template with added Table View takes almost 2 minutes and it freezes the client and even the Excel if I use the add-in.Would you have any recommendations?

Hi all,I want to manage tabs on a dashboard in a programmatically way, showing/hiding them based on the result of an XFBR call (or similar).Can someone point me in the right direction, please ?Thanks in advanceRegardsFabioG

Hi. I have a .csv file that i am importing as a Matrix. I have 4 columns that each has different UD6 member. Problem is, one of the columns also have a different Account than the other 3.Can I somehow do a double matrix, or pull the data from the one column in another way. I would like to see if I can avoid loading the file multiple times or manipulate it otherwise before load.Appreciate any suggestions :) Details: Column1: U6#TECH1:A#0210Column2: U6#TECH2:A#0210Column3: U6#TECH3:A#0210Column4 :U6#UnallocTech:A#0205  

Hi guys.So I was doing some testing and I loaded some metadata wrong application. I have a recent copy of that application, is there a way to restore the application with the now wrong data using the copy?Thanks!

Hi, In our application Account hierarchy is Root>GL_Accts>SGL_Accts. The account A is created under "GL_Accts" heirarchy. The business requirement is the account A should move under SGL_Accts hierachy. Can we make change this change? please advise.

Hi,  Does OneStream require the OneStream provided 'Administrator' security user?  Can you tell me why it's required and how it is used? Administrator is a Native account, and our audit department wants our users to be SSO.  What would be the impact of changing the Administrator user account from Native to SSO? Thanks! 

Hi, Is there a way to check status of all load overlapped siblings enabled WFs?  The issue is that we have bunch of overlapped data WFs (even after L3 data unit) and people are stepping on each other, doubling the amounts every time someone loads their WF while other WF data load is in progress.  Wanted to try event handler and message showing load is in progress. Any other ideas to avoid this are also appreciated. Thank you, Mikki

We have a dashboard that was originally built in v7 that allows us to add an intersection of data to a CV . When you click on an intersection in the CV, the code takes the Linked Parameters from the CV and populates combo boxes with the members in the intersection. You then change one or more of the members in the combo boxes and click another button to add this intersection (by adding a penny to another account) which then shows up in the CV.  This used to work in v7 but now as we are testing this in v9 the linked parameters that are being passed to the code are not the current values in the intersection you are on. It seems to be passing old values.  Any thoughts?

Hi, I have a requirement from business that, want to restrict the roll-up in the entity dimension. for ex: i have Top entity, and all the members underneath are rolling up to Top, but i want to restrict one entity (ex: entity A) not to roll up for particular users which are part of group A.So, when Group A users retrieve the data at Top entity, he/she should see the total number except restricted entity(entity A) and all other can see the total numbers including entity A at Top. is there any way to restrict the roll-ups based on security.Thanks in Advance.any suggestions please, Appreciate your help. ThanksSatish P