OneStream Platform Forums

Hello Experts, Here's the scenario: We have a flat file coming from the client's source with multiple source columns. We need "Region", "Cost Center", and "Business Unit" in this case from the file to build the solution. We have developed an unique UD2 dimension in the app which will act as a target dimension for these 3 source columns(Region, CC, & BU).Creating a one to one mapping for all the possible combinations for (Region, CC, & BU) would be tedious.Currently, we are thinking of writing a Complex Expression in the UD2(target) transformational rule, that would first lookup the parent values of all the base members from the 3 columns combination and return the respective value of it's target. Something like the below snippet. Any sample code or alternative solution would be really helpful. Thanks!Dim U1 As String = args.GetTarget("U1#") Dim U3 As String = args.GetTarget("U3#") Dim U4 As String = args.GetTarget("U4#") Dim objDimPk As DimPk = BRApi.Fi

Hello!  We named an alternate hierarchy account parent AR and are now trying to find where that account was called/used because we want to remove it without impacting other things (we'll redirect wherever it's referenced to its replacement/new hierarchy).  We use Finit's Toolkit/SearchIt (replaced by OS's ownership in more recent releases) but as you can imagine, searching "AR" gets 100s/1000s of matches. Is there a way folks might suggest to narrow down this search? A#AR has helped but I'm afraid we'll still miss areas where the A# isn't referenced in front of the account name. We also tried searching the member ID in SearchIt and that doesn't work.  Any suggestions appreciated! Thanks!-Nicole

HiIs it correct for OneStream to include “No Data” rows in the IC Matching Summary?  The matching tolerance is set to 1000 and “Suppress Matches” is not selected (since matches need to be displayed).  These accounts previously contained data but were cleared out.   

Hi everyone, I've been trying to use the Environment Monitoring feature, but for some reason the graph doesn't display any values. The interface loads correctly and I can select different metrics and time ranges, but the chart area stays empty—no lines, no points, nothing. Has anyone experienced this before or have any idea what might be causing it?Any tips on how to troubleshoot or configure it properly would be greatly appreciated. Thanks in advance!

Hello,I’m facing an issue with a Data Adapter that launches a CubeView.The problem is that the Data Adapter seems to be looping and triggering the CubeView multiple times, which results in a very long execution time.When I manually cancel some of the tasks related to the CubeView, it looks like new tasks keep getting created, as if the main process is still running.My question is:Is there a way to kill or stop the main task/process that was initiated by the Data Adapter, so that all dependent CubeView tasks are also stopped as a consequence?Or is there a recommended way to safely terminate this kind of runaway Data Adapter executionPS :The same OS environment hosts both development and production.I’m currently running OneStream version 7.2.Thanks in advance for your help.

Hi Everyone, Can we use one windows/local server for SIC setup to both Prod and Non-Prod. Thanks

I have to create a task manager build that does not include weekends in the duration. We have tried adding the weekends to holiday profiles and excluding them from the explicit day map, but the duration will always include the weekends. Right now, I have due dates on weekends an holidays even when calling them out in the Holiday Profile and setting each one with an offset of 1. Is there a work around for this or any other solution to have the durations skip weekends/ due dates not be due on weekends or holidays?

Hello, I have following two cubes in onestream: Volumes Detail All the cube dimensions are the same except for UD1. For volumes, UD1 cube dimension is VintageDim and for detail its FunctionTotal. I am trying to copy data from "Volumes" cube to "Detail" Cube through a Business Rule. I am running this business rule from Data Management Step. The rule runs perfectly but it doesn't copy the data. I don't get any error too. Please can someone help to understand the issue? Public Sub CopyData()      Try         'Define the source and target information Dim sourceCube As String = "Volumes" Dim targetCube As String = "Detail" Dim sourceScenario As String = api.Pov.Scenario.Name   '1. Pull data from the source cube (Volumes) 'Using a formula to capture the desired data unit Dim sourceDb As DataBuffer = api.Data.GetDataBufferUsingFormula($"Cb#{sourceCube}:S#{sourceScenario}:A#Product_Sales")   '2. Convert the data buffer to match the target cube's d

Hi,I am calling a Business Rule (BR) in a Cube View using XFBR as follows:XFBR( BR_ParamHelper, FunctionName, WFname = |WFText2|, SelectEntity = |!WF_AssignedEntity!|, Time = |!Time!| )Inside the BR, I parse the year from Time to control flows:Dim wfYear As Integer = 0If args.NameValuePairs.ContainsKey("Time") Then    Dim POVTime As String = args.NameValuePairs("Time")    wfYear = CInt(Left(POVTime, 4))End IfIf wfYear >= 2026 Then    ' Remove  flows for specified entitiesElse    ' Keep historical flowsEnd IfProblem:When I log POVTime or wfYear, it always shows 0001-01-01, so my logic for removing ENT/EXIT based on the year never triggers.What I have tried:Verified the Cube View POV is correctly set.Passed Time = |!Time!| from the Cube View XFBR call.Logged args.NameValuePairs("Time") — still returns 0001-01-01.Question:Is Time = |!Time!| the correct way to pass the POV period to a BR?Is there a difference between |!Time!| and |!POV!| or T

I need some assistance.  The following error is displayed during the Load and Transform WF step (v9.0.1.17608): The use of "?" and "*" is discussed in the Design and Reference guide as per below:Requirement:  There is an entity with 5 characters with suffix _ICI30 that needs to map to C4500 if the IC has 5 characters, and another with 9 characters with suffix _ICI30 that needs to map to C3000 if the IC has 5 characters.   How do I define the rule expression if E#[?????_ICI30]:I#[?????]  and E#[?????????_ICI30]:I#[?????] are incorrect?   

Hi All,The login is successful, but when I return to the OS app page, nothing happens and I can’t select or open any application. I’ve cleared the cache, the Desktop and 2.0 folders, and I also have the latest .NET runtime installed. Is there anything else I can try? Thanks 

Hi,I need to provide a demo for a customer who is exploring using Narrative Reporting.I am using the Termplate to create the Root/Section/Document structure.Can anyone provide me with the Extensible docs that are associated with the template and imported into NR?Displayed in green below:It would save me a lot of time and effort.Many thanksGuy

Hi,I'm trying to find Narrative Reports in the Solution Exchange.Can anyone let me know where it is so I can download.ThanksGuy

Is there a way to create a FXRateType from a Business rule?FXRate types (average rate, closing rate...) are used to set FX rates in addition to Time, source and destination currencies.In addition to default FXRate types, new ones can be added:Is it possible to create such FXRate types by business rule?Indeed, by business rule (with BRAPI.Finance.MemberAdmin.SaveMemberInfo), we can create a scenario, set parameters, set an existing FXRateType for P&L and for BS, but I've not found how to create a new FXRateType that could be used for this scenario.

Hi everyone,In my CubeView I have a cell defined with the Date data type and I would like to force its display using the number format dd/MM/yyyy,However the format never changes and is always displayed as MM/dd/yyyy, probably due to the US culture settings.Do you know if it is possible to override this behavior? I assume it should be since multiple date formats are available.Thanks, Nicolas 

I'm hoping someone can verify behavior I'm seeing when trying to copy files between folders in File Explorer.  I'm able to move files between Application Database and Application Database folders, File Share to Application Database, but not Application Database to File Share (DataManagement / Subfolder). Is that expected behavior?  At first I thought I had an issue with the Business Rule but now I'm starting to suspect that you cannot pass a file from Application Database to File Share? Thanks, Brandon

Hi Everyone, Need your support  I am currently preparing a dashboard to manage user security details in OneStream. As part of this, I need to retrieve and modify Workflow Profile access groups. Specifically, I want to get the Access Group names corresponding to each Workflow Profile (e.g., for Workflow Profile US, the View group is US_View and the Modify group is US_MOD) based on scenario type. Currently, I am able to retrieve the AccessGroupID, but I am unable to get the group names. Could you please provide guidance or confirm the table/approach I should use to map Workflow Profiles to their Access Group names? Your assistance will help in correctly setting up the dashboard and managing user security efficiently. Data Adapter to pick group Data adapter to pick Workflowprofile and assigned entities. Thank you in advance for your support.

I have a cube view with a parameter on Entity |!Entity_select!| that I would like to put in a tabbed dashboard that has one tab for specific Entity member. I am using dashboard type "Embedded dynamic repeater" where the component is data explorer report.Data explorer report has data adapter component to the Cube View. I thought the way to do this would be to use the template parameter values in the collections. But it shows error as attached below.It seems that the template parameter value was not passed to Entity_select parameter. Is data explorer report component compatible for dashboard embedded dynamic repeater?Is there any sample of Embedded dynamic repeater dashboard using data explorer report component?TIA,Nuryana

In v9 we are misssing Ic matching accounts where as i can them in 7.3 is it know issue in v9?Intercompany matching settings has been enabled and parameters are set.      

Hi Team, We have an issue in publishing the document in the Narrative Reporting. while Publishing the document, it is saving under respective user folder. how to publish a document in share folder or any group folder. Can you please help us resolve the issue. Thank you, Shiva Prasad

Hi all!  I know there's a Business Rule - Updated audit report but it doesn't actually show the changes in the BR, just reports on whether a rule changed in a date range. Is there anything out-of-the-box that I'm missing? I know the database table shows the rule code every time it changes but it's annoying to copy/paste and find the differences, especially the way the database table shows/resizes with giant rows to accommodate the whole script.  Any guidance will be helpful!  Thanks!

Hello everyone,Trying to create dynamic dimension in v9.0 application, I'm not able to an option to do the same in the create dimension source type dropdown. Only seeing the following     Same issue with creating Dynamic Dimension in a Service Factory (see ss below)Also not able to see any Data Binding Type setting on the cube in order to turn the into dynamic cube      Does anyone have any idea if I may be missing anything here, or does the dynamic cube/dimensions is something I have to ask OS to enable in my application?Appreciate your time, thank you! 

I need assistance in selecting the immediate parent of a base member. Currently, I am using a Business Rule (BR) to identify the Top 10 Business, but I am unable to retrieve the correct members. My requirement is not to select the base members themselves, but rather the member directly above each base member in the hierarchy. Scenario:  I am using the following formula to select U6#Top_Business.Base.options. However, instead of retrieving the base members, I need to capture their immediate parent. Is there a member filter formula available that can achieve this? U6#Root.CustomMemberList(BRName = -----, MemberListName = Ranked, RankType = Top, RankCount = 10, LoopMemberFilter = [U6#Top_Business.Base.options(Cube=Main_Cube, ScenarioType=Actual, MergeMembersFromReferencedCubes=False)], DataCellToRankMemberFilter = Cb#Main_Cube:E#Top:C#USD:S#Actual:T#2025M11:V#YTD:A#Example:F#Example_activity:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U7#Top:U8#Top)

Good morning, So, I am creating a Report Component with, at least, 75 different data cells from Data Adapters.  When it comes to a Formatting Rule, I am looking for a single rule where the condition is dynamic based upon the value of the cell it is applied to. This is just a small portion of the cells.  I would like to format all of them as ($##,###) in Red if it is negative.  I have tried using [Value] < 0 in the condition but everything is turning red.  I have created calcualted cells to turn any text into Decimal.  I don't want to have to create a rule for every cell. Also, when it comes to the Format String, what is the syntax to make negative number show in parenthisis?  

Hi experts,Is there any audit report, to see Who did the Load ?When did it happen?What XML file is used to Load?I could not find it in the Navigation center?//Suresh