OneStream Platform Forums

I am trying out a complex expression in Time Data Source. The issue is the next: I have a Forecast scenario type with input frequency monthly and on the other hand I have a Long Term scenario type with input frequency yearly. Therefore, the colum time in the file is yearly, so I developed a complex expression where I can load depending on neither scenario type year 2024 or WFTime (forecast for this case) or scenario type year 2024 + M12 or WFTime + M12 (Long Term for this case). This is my complex expression (that is not working): Dim vYear As String = args.Value Dim scenId As Integer=api.CurrentDataClusterKey.ScenarioIDDim scenType As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,scenId) If scenType=ScenarioType.Forecast ThenReturn vYear + "M12"ElseReturn vYearEnd If I appreciate all your comments, Thank you.

Hi, This formula is working, but it's returning 100% for each Entity. Is there something I'm missing regarding Entity? Will this work in a member formula or only in a business rule? Dim entity As String = api.pov.entity.NameDim entityID As String = api.pov.entity.MemberIDDim OwnValue As Decimal = api.entity.percentOwnership(entityID) If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyforEntity())) Thenapi.Data.Calculate("A#NCI_IS:V#Periodic:F#EndBalLoad:O#None:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None= "& _"RemoveZeros(A#Income_Loss_before_Noncontrolling_Interests:V#Periodic:C#Local:F#EndBalLoad:O#Top:I#Top:U1#Top:U2#Top:U3#None:U4#None:U5#None:U6#None:U7#Top:U8#None * ( ("& OwnValue &")))")End If

What is the difference between WorkflowUnitClusterPk vs WorkflowUnitPk? When would you use one over the other?   Thanks, Scott

I am trying to get the journal post group in the workflow profile properties using JournalsEventHandler Business rule.  Does anyone have done this before? Is it possible to get the journal post group value from the Workflow Profile?

I am trying to call a database stored procedure from an extensibility rule.  The stored procedure returns an OUTPUT parameter, but I'm unsure how to reference that OUTPUT parameter, using the DBParamInfo object and ParameterDirection setting.  Can someone give guidance on the proper usage for OUTPUT. Stored-Procedure CREATE OR ALTER PROCEDURE [dbo].[TEST_OUTPUT_PARAM_PROC] ( @OUT_PARAM_VALUE VARCHAR(100) OUTPUT ) AS BEGIN --Do stuff that needs to be done here SELECT @OUT_PARAM_VALUE = 'Param from Procedure'; END GO Extensibility Rule 'definition DB Call To stored procedure Dim OutParamValue As String = "" Dim tsSQL_CallProcwithOutputParamter As String = "DECLARE RC INT EXECUTE RC = TEST_OUTPUT_PARAM_PROC @OUT_PARAM_VALUE OUTPUT" Dim parameters As New List(Of DbParamInfo) parameters.Add(New DbParamInfo("@OUT_PARAM_VALUE", OutParamValue,ParameterDirection.Output)) 'paramDirection: Using dbC

Is there a way to view application Workflow Status reports in excel rather than having to use a dashboard in the application that shows if an entity is certified/locked or not? Something that is easily refreshable so that you don't have to leave the current workflow you're in to view all entities workflow status? 

Hi All, I would like to create the Dashboard for the Adim which should display all the Current login users Details in the applications. Kindly help to achieve this development.   Thanks

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-other-rows-and/td-p/20227) Is the below solution post by OneStream still the only workaround for the question? I am trying to compare the variance of prior year and current year data and want to return a specific number format based on the two numbers. Thank you.  

       

Hello,  I would like to create a report book that includes several cube views and an xfdoc (ppt cover page). I added the xfdoc as an application database file and pointed it to the working URL.  However, when I run the report book I get a blank page.  I can't figure out how to get it to render the File (xfDoc).  It does render all the cube views as expected.  And I confirmed that my standalone xfdoc is working as well.   Thanks, Sean Report Book - Add File (XfDoc)Report Book Preview - BlankStand Alone Xfdoc - generating fine  

Hello,  Let's assume we have an extensibility on the dimensions account with 2 cubes. When we need to export the dimension account, we are only able to export the accounts for the 1st cube, and the accounts for the 2nd one (two files). Is it possible to export the full account hierarchy (within a single file), with a field specifying the associated cube ? Thanks for your support, Harry

Hi All, How can I show Cell Detail Classification in the report ? Thanks

Hello, Got a question. We are trying to configure Smart Integration Connector. With respect to that can you please send us the list of IP address to whitelist for the Azure Relay of Onestream Thanks in Advance    

Hello OneStream Experts: I created an account called MyAcct to store calculation. I run the business rule in Data Management step and put Net Income to MyAcct. api.Data.Calculate("A#MyAcct = A#NETINC") After I run the business rule, the Calc Status in View dimension show CA for both NETINC and MyAcct. However, after I run right click the data cell to run consolidation or Calculation, the value in MyAcct got lost, the calc Status for NETINC became OK. I wonder why my calculated account lost the data value after I run consolidation. Thank you advance for any answers.

Hi, I'm a new-ish user to OneStream and the QuickViews.  Is there a way to prevent a dimension from repeating when you refresh - for example, I want monthly (periodic) columns with a specific UD#7 variable - we will call it A.  Then, I want YTD with a different UD#7 member, B for YTD view.  Whenever I refresh the QuickView, OneStream will give me both A and B for all periodic and YTD data.  Is there a way around this? I don't want YTD with UD#7 member A or Periodic with UD#7 member B but not sure what I need to change for the ad-hoc build.  Thank you!

Hello there, As intuitive as it seems, I'm trying to pass bound parameters from a CView to a DM Sequence. Upon selecting a CView cell, I click on a 1st button to open a dialog window (at this stage, bound params are resolved). But, within this dialog, once I click on 2nd button that launches my DM Sequence that uses the previously resolved params; I retrieve " |!mySelectedAccount!| " instead of the needed value. Button Configuration: DM Step Configuration: Solution Attempts: Since I am able to retrieve the bound params on the 1st button click, I tried storing them to a 'Literal Parameter' that uses an XFBR to string.join values, but when I try retrieving the literal param value i get " XFBR(BR,Function, Account=|!mySelectedAccount!|, Entity= ... " instead of resolving the XFBR ( Which is normal ?) I tried using "Globals" but I get the same result ... literal value instead of resolved value

Hi all, Currently I have a cube view with GetDataCell formula for ad hoc calculation, may I know is there any rounding off function in the GetDataCell formula? For example, we would like to have a formula like Round(A#100) - Round(A#200). Thanks a lot for any possible solutions.

Hello OneStream experts: I created and account=MyAccount and put member formula. api.Data.Calculate("A#MyAccount = A#NETINC") I set AccountType=Dynamic Calc Formula Type=Formula Pass 1 I am able to compile the syntax and run the calculation successfully. But MyAccount account member showing no data from my quick view excel sheet. My NETINC account has data. I wonder why the calculation is not working. Thank you for any feedbacks. 

Hello - Does anyone used the AWS SDK (Dot Net) to download the file to the OS batch harvest folder? using SIC if so, could you please provide high level steps?   Any Help would be appreciated.

Hi i now have access to Onestream Navigator and would like some recommendations of which courses to complete to get an understanding of how to extract data out of Onestream  Does anybody have any courses that were done that would be of help

Hi All , I was trying to build a dashboard with a Index or a guided List like below. For the below dashboard these are the steps I took :  a. Created A Delimited Parameter  with all the reports  b. Created an embedded dashboard with the value of this parameter  c. Created a List Box with the delimited parameter.  So on the Main dashboard when one click on any of the values on the list , the Dashboard opens on the right.  Although it works , I noticed that the performance of the dashboard is quite bad compared to if I create the same dashboard with tabs .  Both the dashboards are using the same underlying cube view then why is there a difference in Performance ?  Is there something wrong with my approach ?  Tabbed dashboard   Regards, Saurav

I am working with text editors and found that when I try to undo something I keep getting the "Object reference not set to an instance of an object." error. Does anyone know if this has been fixed in newer versions (currently using 7.4.2 for this) or if there is a way to fix this within the application?

How to create a form with dynamic cost buckets (columns) that change every year for different entities in OneStream ?

Hi Team, I wanted to double check if origin Import can be used within XFSetCell. It gives me error and my assumption is we can only use origin Forms.  It's strange that this field is not predefined and we can type there "import": Many thanks!  

Hi, I am trying to create an account member formula where I have Account A divided by Account B, but the scenario in the denominator should be decided based on Text3 in the POV Scenario. E.g. A#10000:S#Actual / A#20000:"& SourceScenario &" SourceScenario = IF Pov.Time + 12  > Scenario Text 3, ThenSourceScenario = Forecast, ElseSourceScenario = Actual   This is how far Ive come but it is not working yet: 'Use FC as scenario if POV time is more than 12 months more than last seeded actual month in FC.If api.Pov.Scenario.Text(3) > api.Time.AddTimePeriods(12, True) ThenDenominatorScenario = ":S#FC_WIP"ElseDenominatorScenario = ":S#ActualL4LAtRealRate"End If