OneStream Platform Forums

Hi All, I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelationshipProperty(), both returns an error when I try. =XFGetRelationshipProperty(“Entity”,"",B15,“Parent”,"","") returns “#ERROR: Parent”=XFGetRelationshipProperty(“Entity”,B16,"",“Parent”,"","") returns “#ERROR: Member Name”=XFGetRelationshipProperty(“Entity”,B17,"",“Parent”,“ACTUAL”,“2021M1”) returns “#ERROR: Member Name”=XFGetRelationshipProperty(“Entity”,B4,B5,“Parent”,"","") returns “#ERROR: Parent” =XFGetMemberProperty(“Entity”,B13,“Parent”,“Finance”,“Actual”,“2021M1”) returns “#ERROR: Finance”=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”=XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR: Parent”=XFGetMemberProperty(“Entity”,B11,“Parent”,"","",“2021M1”) returns “#ERROR: Parent”=

Hi all, We’ve set up a UD1 member to account for headcount in our application. We have cost centers in our account dimension which we’re using in conjunction with the headcount UD1. The issue is that the numbers translate when reviewing at a base entity depending on the currency or, if we load a USD JE, the numbers are just not visible for base entities in a different currency than USD. I’ve reached out to OS support and they have no reference for a customer using UD for headcount and say that any account type outside of Balance or NonFinancial will translate (CC accounts are expense). Any thoughts on workarounds for this? We’ve settled with the USD JE though that’s clearly not optimal. Any suggestions would be welcome! Thank you,Nicole   PS. I had to add a letter to the header because it didn’t meet the minimum which is why there’s a random r up there 

Hi there, I wonder if anybody knows how to access dashboard combo box selection from SaveDataEventHandler? I was able - through BRApi - to get the parameter assigned to the combo box (with the entire member list in it), but not the actual selection. I think this is possible from Dashboard Extender BR, but not Extensibility. I would appreciate any tips & advises. Best,Karol

We have a user who's add in files are adding a prefix to all the formulas of:=@onestreamexceladdin.xfgetfunctions.For all other users this does not show up.  I tried looking at the settings and searching several Excel forums to see what the issue might be.  I am thinking this is an Excel option that may not be set correctly. Has anyone seen this before and do you know what the issue may be?Thank you!  

Looking to start using the View txt fields (Annotation, Assumptions…) and understand that there is no natural way to have that information aggregated/consolidated up. I am told that a BR is needed to do this. Just checking to see if this is correct and if anybody has had success in this getting it to work. Ideal use would be for our regional leaders to be able to see summary comments on specific line items that we report on.

Hi Folks, I have created a dashboard for Flash reporting, and I’m trying to add a section for commentary. I’ve used the View member “Annotation” in the cube view. This works fine for short comments or comments the length of column, anything beyond that is not visible. Anyone have an suggestion on how to get around this, eg wrap text or maybe another option to add comments to a dashboard. As an FYI, the comments are linked to the parameter on the dashboard. Thanks in advance.

Hello, Do you know if there is a way to display in a dashboard the users / entities access by user / the type of access (read, write...)  Thanks, Regards, Harry

Hi I'm trying to get the current pov - cube and entity - within a member list (i'm using for selection as drop-down). Unfortunately the api.pov.entity.name is in this case not returning the wf pov, but the cube pov. The args.SubstVarSourceInfo.WFCubeRoot doesn't work as well. Any ideas? Thanks Jana

Good EveningWe are working on an OneStream implementation and one of our sources of data is OpenAir. This solution is cloud-based. We are trying to extract data via a ODATA call.Does anybody have any code examples on how to use ODATA as a data source?Thanks in advance.Marco A. Rossodivita

I would like to know from fellow OneStreamers where you’ve done a daily forecasting application. I’m not necessarily looking for a solution. Just ideas on how this can be done. How do you load day into a daily forecasting application when the data file is rolling forward by day? I’m looking at the design guide and there it is talking about UD dimension as a channel. However, that needs you to create multiple channels and multiple import workflow profiles. (the example with Departments is awfully generic, as you can have department files and can have department import child profiles) When I load day 5 today, I’m only going to get data from day 5 onwards. When I load the data then the prior days of May 1-4 are gone. Thank you for your suggestions. CK

I can can create reports showing descriptions (for accounts or other dimensions) in each users’ own language. Question Credit: Noemi Nagy   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

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!  

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 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?  

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