OneStream Platform Forums

Hi I have two source accounts bringing in same amounts for multiple Entities. Some of the entities are local and some overseas. The only unique identifier is Text7 field in the entities. How can I map the source accounts to OS accounts using Entity Text Field 7. Below is the example Acc 1000 - $7000 E#AUS Acc 2000 - $7000 E#AUS Acc 1000 - $9000 E#NZ Acc 2000 - $9000 E#NZ In the above example Amount $7000 belongs to local Entity so should be mapped to A#Local_Tax and Amount $9000 belongs to overseas Entity so should be mapped to A#Overseas_Tax. The problem is in the import file the amounts 7k and 9K sit in both local accounts Acc 1000 and Acc 2000. The only unique identifier is the Text 7 value in the Entity. Please advise if I can use this text value in Composite Transformation rule or if I need a complex business rule. Any suggestions are welcome,  Thanks Sam

Looking into a way to turn off translation for specific entities, yet only for the budget scenario and select gain/loss accounts. Having translation on for Other Expense and Net Income as it relates to budgeting is skewing the EBIT bottom line. Is turning translation on a budget scenario and specific Entities possible? Thanks in advance, 

All,  We currently have a combo box (with entities) in a dashboard but we would like to make this list a bit smaller and based on the security rights a users has. I want to solve this with a XFBR which i afterwards attach to a parameter and that parameter in a combo box. Does somebody has an example of this XFBR code which i can look into? Or is there a better way to do this.   Thanks

Hello - I have a cube view that's linked to another to show detail. I have bound parameters set on the time, view and account dimensions. These parameters are all working properly except for the calculated column I have in the main/parent CV - its a column that has a GetDataCell expression. When I right click and select "Navigate to Entity Drill" on a cell in this column, the account and view members are still correct, however the time period its passing through to the linked CV is incorrect. The time member it passes through to the linked CV is the period of the first column in the main CV. So for example, the time period of the first column is 2024M4 while the period for the GetDataCell column is 2024M8 - the linked CV will show 2024M4 even though the Cell POV shows 2024M8. How can I send the correct time period to the linked CV on this GetDataCell column?

Hello, I am creating a dashboard with a grid view and gridview is binded to a Data Adapter which calls a business rule to get data thru an external web-api call. Now I have to show data in Gridview and the record count on the dashboard on a button click. I have used following settings on the button. The Selection changed server task is happening first and then the data load is happening, so I am able to update the literal parameters with counts after data load but they are not reflecting on the dash board. Any help appreciated.

Hi all, Using the CV Drilldown function, is there a way to show the Reporting Currency for a group of entities rather than just the Local currency? I've had a few of our users ask for this, but I don't believe it's possible out-of-the-box but interested if anyone has a way of showing this. For example, I have a Euro currency group that is comprised of USD and EUR entities. Is it possible to drill or show a drillable view which shows all the amounts in Euros? See below, the users are keen to be able to drill so they can see all the base values in EUR, rather than the mix of USD/EUR. It may not be possible, or I might just be missing something obvious. Thanks

Hello Team  I am currently using the "FDXExportDataUnit" function to load data into a DataTable using the following code: Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si,"FPA_CM","E#Entity_top.base","USD",scenarioTID,Scenario,timefilter,"MTD",True,"Amount <> 0 And Flow='EB'",16,False)   he resulting DataTable contains 678,123 records. I plan to insert these records into a Snowflake database. To speed up the inserts, I am dividing the DataTable into multiple DataTables of 150,000 records each. However, the inserts are currently happening sequentially, and I want to run them in parallel. I am considering the following options: Pass the split DataTable as a parameter to a Data Management sequence:This would allow me to call the sequence using "QueueDataManagementSequence" so the process runs on different servers. I need assistance on how to pass the DataTable as a parameter to the sequence. Run bulk insert SQL statements in parallel using threading tasks:

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6).  I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead. In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6. Is there a way to suppress zero after the script runs or write zero suppress into the script?  Thanks Scott

Hello, I am trying to create a Dashboard with several cubeviews in it. I created a delimited list parameter with different categories of cubeviews. Does anyone know how to assign the cubeviews to the different display items?For examples, I will have a category "Sales" and when the user will select "Sales" in the drop-down menu, I want certain cubeviews to be displayed in my dashboard. thank you!!

Hello OS community,I am currently developing my Cash Flow Statement  and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement  variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?

Hello,      I am having trouble with a selection screen on a Dashboard where items are moved from one ListBox to another. It is a multiselect=True but how can we have the items selected on the 2nd list box. I have to read this list in a BR but until and unless they are selected the item is not passed to the BR for further processing. Any help would be appreciated. Thank You, Indu

Hello,There is this grid view property that has been bugging me for a while called 'Show Row Headers'. Using VB.Net, we cannot define 'Headers' for the rows of a DataTable object, so I'm curious to know how to use this property to the fullest ?By switching it to 'False', the only noticeable difference is this little blue arrow that disappears: I assume that we can have a CubeView-like formatting with Row & Column headers using the grid view, but I can't seem to enable it.Thanks for your help.

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? 

Looking to shorten a report so it fits on one page. The Auto fit to Page Width is set to True.Using General Settings, Report, is this achieved by adjusting the bottom margin? How else might this be achieved if the above is not the option.   

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,

Hi, I am trying to establish a connection between OneStream and my local SQL server but getting below error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (SQL Error Number -2146232060, -1) Business rule and error  

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?  

Hi all, looking at the Train Me download available in the OpenPlace exchange for our org. Am I following correctly that this is ONLY for video uploads? Some of our users do not like videos and prefer a quick reference guide instead. I'd like to layer both options in ....curious if anyone has rolled this out and your thoughts. Also open to any other suggestions for documentation on training and MEC task how-to's.  We have a Teams site but it's clunky at best and would like a one-stop place for all the info. Welcome any insight, thank you!

.

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 wanted to know what the difference was between the following security: Workflow Execution and Workflow Access. Can someone please help.

I am an administrator however it will not let me change the colour of the onestream dashboard (This is for the test environment). It is greyed out so will not let me change. How do i change the colour? Thanks

Are report components (report designer) drillable when using vStageSourceandTargetDataWithAttributes? I want to be able to click on a value in a report component and it provide detail specific to that value. I know this can be done with cube views and other things where bound parameters are passed. Can I do the same for report components? If so, how? I can easily get the detail but I want it to be specific to a value in the report.

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 Team, I know that periodic is calculated in system as a difference between current month YTD and previous month YTD. What happens if we just copy this periodic from one month to another?  Many thanks!