OneStream Platform Forums

Hi All,   I was reviewing the following link below regarding strategies to reconcile historical data.  Strategies for Data Reconciliation - OneStream Community (onestreamsoftware.com) I noticed the following statement "You can turn-on’ translation for periods when the translation is what you will use going forward. It is possible in OneStream to load parent currency. By simply using the Flow dimension, you can see how simple it would be to handle historical currency issues."   Can someone please point me in the right direction in terms of documentation on how this is done / the details. Ideally from either the OneStream handbook, design and reference guide, or OneStream academy.   Cheers!  

Is there a way to enable Account descriptions in other languages like Dutch?

In my screenshot above, I would like to add a $ sign. I know this is done under Number Format. However I would like the $ sign to be aligned to the left-hand side. Would adding a narrow column allow me to do that? Not every line will have a $ sign attached to it. 

Hi everyone, I am looking for a solution to insert dashboards in extensible PowerPoints. I know how to put cube views, reports, etc., into PowerPoint. However, in the object lookup, there is no option for embedded dashboards or other dashboard components. Some background about the dashboard. It is set up using the same way dashboards are set up in Golfstream. It uses some state indicators and labels. The headers and state indicators are set up in separate dashboards and are merged into one dashboard using 2 rows and 1 column.  I have looked at workarounds on how to get the dashboard into a PDF or report. However, I did not find a working solution yet. Therefore I am reaching out to the community. Any help would be very much appreciated.  Thanks Floris van der Poel cpmview E: Fvanderpoel@cpmview.com

Hi everyone, I am trying to add records to a table via an Excel Table View. Using the example in the Table Views documentation, I am able to update existing records; however, any new records added are cleared once I submit the sheet. Is there additional code I can add to allow the Table View to write new records to the table? Thanks! Molly

Hi all is there a way to get rid of the + on a nested dimension? In the example below The + on EQUITY accounts indicates that EQUITY is a real parent of the accounts below the +. But for the nested dimension Onestream displays always a + and it "seems" that the element "sys_CLO" is a parent of the element below. But in this case it is not true. "sys_CLO" is only the last element of the subset in the nested dimension.     My goal is to display a list of elements in the nested dimension suppressing 0 values on the rows.   Do you think this is possible not to show the +? Thanks in advance for the help. Marcello    

Hi All, We have some cube views which dynamically pull columns as per the cycle being planned.  Cycle1 : 4 quarters Cycle2: 3 quarters Cycle3: 6 quarters Cycle4: 5 quarters  These cube views have column separators, highlighted rows and columns. Cube views are included inside spreadsheet component which are then embedded inside the dashboards. ISSUE: Formatting is different for every cycle due to varying number of quarters. We have had to manually update the spreadsheet components for every cycle due to formatting going off. Would anyone have a dynamic solution for this?  

I need to move data between two mutually exclusive cubes. Cube1 (FinPlan) U3 dimension base level is ProductType, Cube2(SalesFcst) UD3 base level is SKU which rollup up to ProductType. SKU also has a Text6 field containing its ProductType Code.   I also have separate Account dimensions: Cube1 uses FinAccounts for Forecasting, while Cube2 uses the SalesFcstAccts dimension   To move the data from Cube2 to Cube1, I tried using a Business Rule using the api.Data.ConvertDataBufferExtendedMembers function Cube is an option:    Dim summarySalesFcstData As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("SalesFcst", "Fcast1", dbSalesFcstData) However, it didn’t replace the SKU with its ProductType. Does anyone know is this function will work between mutually exclusive cubes with different account dimensions. The second approach I would like to try is to extract the data from Cube2 including the SKU Text6 value of ProductType, then I

Hi !I'm interested to get data from the AuditFXRate table, however this table is not giving the Currency names, but only its ID.The problem is that, the Currency names are nowhere to be find in the datatable of the application ( it is not in the "Member", "MemberProperty" or "MemberDescription" table). The only plase I can get a reference of these currency is in the "AppProperty" table, where all currency are stored in one row.Needless to say, the table "FxRate" is not showing the Currency Name as well 🙂 --> Where can we find the CurrencyID + CurrencyName information in OneStream ? Regards,

Hi All,   I am wondering if there is a way to display a text value in a cube view cell directly from a cubeview member filter?  In other words, in the same way that you can use a member filter with GetDataCell to force a number to be displayed (ie. A#Net_income:GetDataCell(100) will display 100), can you do something similar for text values like A#Net_Income:GetDataCell(Hello) to display Hello in the cell?  It doesn't work for me and I have also tried using A#Net_Income:V#Annotation:GetDataCell(Hello) and that doesn't work either.   Any thoughts?   Thx, Mike

Hi Community ! I am building an application where there is a need to have different "culture" on the accounts. In my cube view, I have a column where the "cell type" is defined as a combo box based on a parameter where the user can enter Yes or No. This parameter is of type "member list" with "Yes" and "No" being actual member of a dimension, and those are translated. However, when I change the language, or when a user with another language open the cube view, the parameter displayed value remain the same (Yes and No, insteas or "Oui" ou "Non" for French).   Is it normal? Or is there a workaround or specific config that should be done in order to achieve that ?   Regards,  

Hi, I have account for which I don't want entity aggregation to occur. I have tried using the dimension for aggregation on entity dimension as FALSE but I have not received the desired result and its showing the invalid intersection and hence I am not able to input the numbers at base level. Moreover suggestion on account type are also required. any suggestion would be helpful.

I have a single Connector BR that makes several independent API calls to external systems. When it's called the Task Progress window sits at 11% with the message "Parsing Source Data". I would like to update the task as it goes along so the user knows something is happening.  I found reference to the below snippet but don't know how to properly instantiate the extenderArgs variable. I tried using it with Nothing but it did not seem to work as intended. Is there a sample of how I can do this in a Connector BR? Dim bValue As Boolean = BRApi.TaskActivity.UpdateRunningTaskActivityAndCheckIfCanceled(si, extenderArgs, activityDescription, percentCompleteToAdd)  Thanks.

Hello,   I have a requirement to display an error message in a cube view if the value of a cell is greater than the absolute value of 1000. Under the Cell Format I have "If (CellAmount >= 1000) Or (CellAmount <= -1000) Then " Is this approach correct? Is there an absolute value synthax that I could use? Also what is the syntax that I can use to display an error message after the conditions are met?   Thank you for your time and best regards.

Is there an addin whereby I can retrieve data from OneStream into a Word document?

The image above shows the Subtitle 4: Right (For the Year Ended April), border and the columns for the report. Is it possible to have that subtitle be centered above the three columns? 

  I am trying to change the zeroes in my report to become '-'. Can I accomplish the above with an If Statement?  

I get this error when try run dashboard. Any suggestion what is happening here?  

Hello all, is there a way to export a file to a users local folder (Outside of OS share)? For example the exports drom Data Management or anything that we created in a BR?   I know how to send it to a table/DB, but the question is if i can export directly from OS to a local folder. Am I missing something very obvious?   Thank you in advance

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting  BackgroundColor = pink will cause the cell to turn pink. BackgroundColor = u8#memberfomula my u8#memberformula has only one line: Return "pink"  For unknown reason, 1S is not formating my cells pink ??(I assume the text "pink" is returned by u8#formula) I know my formula is executed by 1S because I put a debug statement in there and it is showing in Error Log that my formula is executed .  

I am trying to clear entered data from the particular Cube but unable to do so using "Clear Data" Rule. Can anyone suggest me the process to clear data from any cube without disturbing other cubes' dataset.

Hi allis there a way to disable the "Create Journal" button  (red)and keep the ""Create Journal using selected template" button (green) I would like to force users to select specific templates where the entity selection is limited to the E#Root.WFProfileEntities So that users cannot make mistakes posting a journal on an entity which is not part of the workflow. Thanks in advance for the help.Marcello  

Hello I have built a workflow structure for a statutory application where every legal entity has is own workflow. In the entity assignment only 1 entity is assigned to the specific workflow. Data load and input forms work fine because Onestream blocks user to enter data on an entity <> from the WF entity. Inside each entity workflow we enabled the user to post adjustments.   But for journals Onestream behaves differently.  Because when creating a journal, Onestream propose the list of companies the user has access to regardless which is the company assigned to the workflow.   Here I am in the workflow of company 1.   But Onestream prompt with the list of entities I have access to. So I can post a journal on entity XYZ on "company 1 workflow". So I am allowed to post a journal on an entity outside the assigned workflow.   Is there a way to force the user to post a journal only to the workflow entity?   Thanks, Marcello      

Hi I am tried to configure a hard error on quarters and warning on off months for IC balances above thresholds.   The error I can use frequency Quarterly but for the warning I want it to run 1,2,4,5 etc.  I tried #TWFYearM1 or just 1 or just M1 but none of them worked.  Help?  Also checked the documentation says nothing about format and there are no examples in Golfstream.

I can use substitution variables across multiple OneStream applications on the same server. Question Credit: Gabriela Columna   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases