OneStream Platform Forums

Hello, Is it possible to modify datamanagement job description on the fly ? We want adding more info for monitoring issues.  

Hi all, I created a workflow Import profile with the Workspace/Import/Validate/Load steps. Inside the Workspace step, I added a Dashboard that has a button, which, in turn, has an Extensible BR that executes the following:Downloads a file from an external source and leaves it in the file ShareAfter that, this file is imported with the Import step through a Dashboard Extender BR called from the same Extensible Rule, which Imports, Validates and Loads the same workflow profile.I would like to see the Taskbar progress and also to automatically refresh the workflow profile status:If the button launches the Extensible Rule, I see the Taskbar progress but the workflow status is not automatically refreshed.If the button launches the Dashboard Extender BR, the workflow is automatically refreshed but the Taskbar progress is not shown.Could we have both functionality? Have you seen it before? If yes, could anyone send me an example of the code us

SOURCE: CHAMPIONS Does anyone know if we can call the Refresh Workbook function using VBA? I’m looking to introduce a button on worksheets that performs the Refresh Workbook option that’s located on the OneStream XF ribbon.  

Hi,We are seeing the below issue on data load process.we always see the last file uploaded, it seems if you upload another before one is deleted.If you upload another file you will see only that one and not the rest of the files.We want to see the all upload files .Please suggest.Regards,Rk

Hello, I have a Book in OneStream that generates the following: The book generates the following excel with data in each tab (without the index tab), I add the index tab manually with the Hyperlink code   In the Index tab, I have manually created a code to put some hyperlinks from the Excel frame.     I would like to know if it is possible when generating the Book from OneStream I can create a code so that the Hyperlinks are made at the same time that OneStream generates the Excel from the Book and not manually create a macro from Excel after generating the books.   Thank you a lot team

Hi all, We have a requirement to run IC Matching report including journal that may have been posted as parent adjustment. In this way we are also excluding form IC MAtching deconsolidated entities and considering the amount based on the consolidation % as well as not considering equity method entities.  This should mean running IC MAtching report specifying Parent/Entity relationship in C#Elimination.O#Elimination, compared to the default setting which poitn to C#Local or any other currency. is there a way to run an ICMAtching report or having a data adpater which pulls data, from a consolidation different than local?

Hello,   I'm trying to format No Data cells as dashes on some cube views. Currently, the number format for the cube view is as follows: [#,##0;(#,##0);-]. This is formats zeros as dashes, but not No Data cells. Is anyone aware of a special formatting to change No Data cells?

Is there something that can be used as a wildcard in OS? I have multiple accounts like 524000, 564000, 544000, etc. can I just plug something into the X for a wild card get all those accounts? "5X4034"

Hello, We have a use case that makes extensive use of dashboards. The BI viewer component seems like an attractive solution for this. However, we have been struggling to fully adapt it to our needs. One problem is the (seemingly) fixed font size for table content and axes. A particularly surprising effect is that there is no change in font size when maximizing a specific component. This could be a very smart feature, e.g. during a beamer presentation. Unfortunately it only increases the white spaces, while the fonts are identical. This seems almost like a bug - or am I missing something? (screenshots are original scale!) Thanks, Frank.  

Hello,We need to create bulk users to perform stress test.We tried to use the suggested solution in the post Solved: Re: Issue with bulk native user creation using internal authentication. - OneStream Community (onestreamsoftware.com), by removing the line <encryptedPassword> in the XML file, in order to have the default password, without success.We would like to provide directly a different password to each user (even if he will have to change it afterwards).What are the best practices to perform it ?Thanks,Regards,Harry 

Hello, we are 'suddenly' seeing an increase in the time for a matrix data source import to complete the validate intersections step.  It has gone from 5 minutes to over 2.5 hours to complete one step during the import step of the workflow.  The subsequent cube load takes another 2+ hours of time once the validation step completes (for a total execution time now over 5 hours).We have backed out all changes since the previous execution that completed in 5 minutes with no change to the time.  We currently are not suppressing zeros on the data source, however even with that enabled in our QA instance, the time to complete the validate intersections step is still much longer than 5 minutes (40+ minutes).Any suggestions on what else we can check?  We are currently on platform version 7.0.1. 

I am trying to pull the value of a parameter, =XFGetDashboardParameterValue("SourceScenario","Test") but it just shows the default value I put in.  I've tried every variation for the parameter name I can think of but only get the default value.  Anyone have this working? 

Hello All, We have a requirement to make some text display dynamically showing or not based on whether the entity member selected in a combo box is a base member or a parent. In my XFBR, I found this function that would give me this information but when I set it up, it returns me false, whereas in some cases, the entity selected had children (so is a parent). "Dim IsParent As Boolean = BRApi.Finance.Entity.HasChildren(si, EntitydimPk, SelectedEntityID, Nothing)" Could you let me know where my function's set up could be wrong or also if you would propose to use an other solution to achieve this requirement ? Thank you

Is it possible to create a popup msg in a DM business rule like the msg below (created when 'Complete' is clicked).  The Load button calls a DB business Rule and I need to first check if WF channel is locked or not.  If locked I'd like to notify the user that the channel is locked and the BR is running    

When OS call an authentification API, OS use the IMPLICIT parameter. This parameter is deprecated since 2 years. When are you going to update these calls with the new standards?

The default length of visible line items for comboboxes seems to be eight. Is it possible to change this to larger numbers? Often there is more space on the screen and this would help avoid unnecessary scrolling. Thanks! (example from GolfStream App)    

This was posted originally in 2019 and added to Office Hours in 2021. Please See below for follow-up question: Question:  Is it possible to have a historical override for a single account, but for multiple currencies?  If I have an equity account which I would like to have a USD override amount, a GBP override amount, etc.  On the Override account settings, I can only choose 1 currency.  How can I resolve this? Answer Yes, this is possible but on your closing balance Flow member, you will have to use a rule instead of the “Source Member for Alternate Input Currency” property, since as stated in the question, you can only choose one member here. The flow would look something like this: Opening Activity FX Closing This member would have a rule that uses this logic: If base entity and foreign currency then   If currency is EUR, then = Override_EUR   If currency is GBP, then = Override_GBP, etc… End If Overrides (one for each potential currency you

Hi All,I am wondering if anyone has an opinion on using slice security for specific UD3 level security vs. using a Finance Business Rule to control access to certain UD3 members.  Basically, I am looking to say if a user is in a certain security group, they should not be able to write data to certain UD3 members.  I believe it can easily be written using slice security (Cube Data Access Security) or with a conditional input FBR (if user in g.  I see an advantage to not having to update every entity with turning the Data Access Security to True and potentially adding categories vs with a BR, just writing a rule that doesn't touch metadata.  I tend to typically try to avoid 'touching' existing metadata if I don't have to especially when adding in a Planning Cube next to a pre-existing and well established Consolidation Cube.  Does anyone know if there is any real pro/con to either approach other than less updating of metadata which I mention above?  Would pe

Hey everyone -  How do I clear data from these workflow manual imports automatically?Right now, I've been going through each month one by one. Wondering if there is a BR that can run them all together and clear up data from those specific imports and time dimension. Here are the steps I want to follow: Navigate to import that needs to be cleared > Clear > Re-Transform > Validate > Load Cube    

Are there any issues with using the OS Database "Member" table to generate a view? The solution requires a dynamic list of account members for a SQL View query and the member table seems like the perfect source table. Just to clarify, nothing is being written to this table. 

BI Designer shows description labels correctly for each one of the 3 cards, Total Actual, Total Budget and Actual vs Budget, this is the view   Actual dashboard omits the Label of the cards, All 3 cards have no description,  they show blank, I do not know what am I might be missing.     

I have a parameter called IntigrityScaling with parameter type "Delimited List" as belowMy cube view uses this delimited list twice.1. As USD in |!!IntigrityScaling!!|   -> it is used to display the description of the value2. Under formatting -> I am using Scale = |!IntigrityScaling!|Cube view runs fine and prompt me to enter value for Scaling and and display both 1 and 2.The issue is when i pass this parameter in a book , it doesnt take the value and prompts me to enter the delimited list parameter. How do i pass a value to the delimited parameter without prompting me to enter ?I dont want this prompt to pop up after i run the book.NOTE= Liter paramter works fine when passing from books 

Hello - we'd like the ability for a Combobox to run an XFBR to generate the default visible value every time the dashboard is opened/refreshed.  We want to provide the user with a 'suggested' value that can differ depending on Workflow, Scenario, Time, etc., and then let them select an alternate choice if applicable. Does anyone know if this functionality on Comboboxes/Dashboards is possible within OneStream Dashboarding today?

Originally posted by Jeff Wood 12/11/2019 I have a sub consolidation where all the children have the member property currency setting as EUR but the parent currency setting is USD. When I run sub consolidation cube views in local currency the children display in EUR but the parent displays as USD so the cube views total don’t foot because it is in USD. How can I over ride the rate of the parent to display in EUR when I run forms in local?

Is it possible to add an assembly reference to OneStream that will allow the BRApi to reference the Microsoft Outlook Object Library....or any other library that is not currently included in the OneStream.I would like to provide a dashboard button that allows the user to open up a new Outlook email message.  Done similarly in other VB.NET projects like this<add assembly="Microsoft.Office.Interop.Outlook, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"/>  Imports outlook = Microsoft.Office.Interop.OutlookDim OutlookMessage As outlook.MailItemDim AppOutlook As New outlook.ApplicationTryOutlookMessage = AppOutlook.CreateItem(outlook.OlItemType.olMailItem)Dim Recipents As outlook.Recipients = OutlookMessage.RecipientsRecipents.Add("myemail@hotmail.com")OutlookMessage.Subject = "Sending through Outlook"OutlookMessage.Body = "Testing outlook Mail"OutlookMessage.BodyFormat = outlook.OlBodyFormat.olFormatHTMLOutlookMessage.Send()Catch ex As ExceptionMes