OneStream Platform Forums

i am getting above error and unable to found any log for this .  

Is there an ETA on the Power BI connector ?

Hi, How can we ensure that a record is only saved in the SQL table editor or grid view after all cells are filled? A message should be displayed to the user if any data cell is left blank when attempting to save. Is this functionality available in version 7.4? Thanks

Client has a need to do USD overrides for specific accounts in the Balance Sheet and the entire P&L. The below code was working fine in prior periods for historical data from a flat file. Now we are importing from SAP, and it works for the Balance Sheet no problem, but the code to populate the Forms member in the P&L doesn't work, and even though I'm calling all base members, the Override calculation only works on some accounts. I should mention the account dimension is extended. Not sure why it worked before but does not any longer. Here is the relevant code. You'll notice both sections are set up similarly. 'Move the entered Local Override amount To the USD consolidation member To override the prior period's roll forward api.Data.Calculate("F#USD_HO_Input:C#USD:O#Forms:U1#Input_HO" & udFix & " = Eval(F#USD_HO_Input:C#Local:O#BeforeAdj:U1#Input_HO" & udFix & ")", "A#BAL8A8B.Base.Where(text2 contains FX_Fixed)",,,,,,,,,,,, AddressOf OnEvalDataBuffer ) 'Ca

  How can we reference substitution variables like |CVYear| in a Business Rule?  These variables are great for Cube Views, but now I'd like to access it directly in a Business Rule (custom calculate).   Dim ExampleCVYearDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula( "T#[CVYear]" ) Error processing Data Management Step 'Enrollment'. Unable to execute Business Rule 'zzzAdjRevenueDriverValue'. Invalid script 'T#[CVYear]' near 'CVYear'.   Dim ExampleCVYearDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula( "T#[|CVYear|]" ) Error processing Data Management Step 'Enrollment'. Unable to execute Business Rule 'zzzAdjRevenueDriverValue'. Invalid script 'T#[|CVYear|]' near '|CVYear|'.   At a minimum I'd like to know how to print the contents of the variable CVYear to the log. api.LogMessage("Value of |CVYear| " & BRApi.Dashboards.Parameters.GetLiteralParameterValue(api.SI, True, "CVYear") ) api.LogMessage("Value of |CVYear| " & BRApi.Da

I am building a Dashboard XFBR String to return a different Origin member depending on whether the time is before or after 2020. If the time is equal to or prior to 2020, it returns "Top". If the time is 2021 or newer, it returns "BeforeElim". The time is selected by a parameter when the user launches a cube view. The issue I am facing is using multiple time periods in a report. I need one time column to return 2020M12, and another column to return 2021M1. This is pulled as T#FirstPeriodInYearPrior1(|!TimeParameter!|) and T#|!TimeParameter!|, respectively. My XFBR can read |!TimeParameter!| but not the time function result.  Typically, I would use Time = parameter, but if I do that it cannot return two different results for the 2020 and 2021 time periods. CVTime does not work here either as I'm specifying the time in the member filters instead of the POV. MFTime gives an error if I try to use it..  Any help is appreciated. I am not sure how to make the XFBR acknowledge the ti

Hello.  I am a total rookie with dashboards, and am failing miserably at trying to tweak one for the first time.  OneStream has an existing dashboard for RCM; there is a chart called cht_ReconPreparationStatus_RCM that I want to use, but instead of the entity being populated from the WF Profile, I want the user to be able to choose the entity in a combo box.  I have created a combo box, and I have created an entity parameter for the combo box.  But I'm just kind of lost as to what settings I need to change.  I also assume this needs to be tweaked in the business rule, but I have tried a million different options and can't come up with it. I feel like this should be an easy one, but I clearly still have a lot to learn!    Combo Box settings (ParamBarEntity is my new parameters i created.  And the Dashboard 3a_scorecard is just a copy of OneStreams 3a_scorecard_RCM that already exists) ParamBarEntity - my new parameter Data Adapter: cht_Reco

I have a BR that runs a load process using ExecuteParseAndTransform.  When the data source is empty for that profile it throws the "No valid DataKeys" error and stops the job.  I don't even get the opportunity to check the status code of the import.  Is there a way to catch that error when using the ExecuteParseAndTransform method?  Thanks, Scott

Hi, Data quality is unfortunately not there in all fields. I would like to be able to remap an existing code to the defined EntityDefault member when the code is not included in the constraints. Without having to define each exception on by one - (this I can do). For instance, an entity must have only American customers (my constraint), unfortunately, in the source file I have records with customers from other part of the world. When this is the case, I just want to get them replaced by the EntityDefault member (that I know is part of my constraint). Any clever idea before jumping into writing a BR? PS. I hate writing code in tools that are meant to be no or low code.

Hi! has anyone tried to download dimension data?  For example the entity dimension i want to extract in a relatively decent format ? and ideas on how?

Hello everyone, Is there a way to import data in such a way that we have more than 2 decimal places in the import step?  Our .csv files have 4 decimal places and OS is rounding those amounts to 2 decimal places. We would like to keep that level of detail Thanks in advance

Hi, Recently we upgraded our onestream to 8.2.2 and after upgrade we were not able to create files on SIC server thru this function ExecRemoteGatewayJob. please help me with this issue.   Thanks, Manju K

The goal is to get underlying dashboard data, I'm developing business rule using VB to call respective data adapter. The issue is, the data adapter has 1 parameter, not sure if it's possible to pass parameter value to it in BR. Below is my BR code and sample sql scripts for the data adapter, Dim isSystemLevel As Boolean = False Dim workspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, isSystemLevel, "Default") Dim adapterName As String = "da01_entity_hierarchy_filtered" Dim rsTableName As String = "OutputTable" Dim dctVars As New Dictionary(Of String, String) Using ds As DataSet = brapi.Dashboards.Process.GetAdoDataSetForAdapter(si, isSystemLevel, workspaceID, adapterName, rsTableName, dctVars) If ds.Tables.Count > 0 Then 'If there are >0 tables in the results Using dt As DataTable = ds.Tables(0).Copy() op_table = dt.Copy() ' Clone the DataTable End Using End If End Using     SELECT C.NAME FROM Member C WHERE C.Name = '|!Sel

I know there is the cell detail upload excel template, however we are trying to load multiple periods just like a matrix load but will be loading cell detail? We basically want to load the classification etc that the cell detail option has on our forms. Thanks!

Anyone know what report or how to implement this? I have seen this role in application security role but cant seem to find on what it really does. Says its gives a user access to a report in import workflow...Thanks!

Hi all,  I have developed a process to rollover a form from one period to the next. Specifically prepayments, where the monthly movement is explained for 4 GL accounts using 20ish flows. The user enters a value in the value cell and the commentary cell.  I have created a button to run a CustomCalc DM job to copy the values entered from the prior month form and past it to the current month form. I managed to get it working for both the Values and Annotations, so that it shows the rolled forward amount on the new month form. However, when I step through Input Form > Process > Confirm, it then wipes the value at the Process stage. The rolled forward annotation does remain. I notice that when I roll forward, the value is stored as "Calculation" and in blue font. When I type a value in manually, it is in black font and it remains when processed. The main thing that I am finding weird though, is that I developed this in v7.2 and it worked. However, we have upgraded to v8.2 an

Hi, the OneStream XF design and reference guide mentions that: "If an administrator wants the range of source Accounts from 11202 to 11209 to map to Account 12000, then he/she would enter 11202~11209 under Rule Expression with ~ as the separator."   What if the Accounts in the range have leading or trailing characters? Let say all my accounts start with A_ I have tried to use the the following expression: A_11202~A_11209, but it does not seem to work. Any suggestion? Thank you  

I thought I knew how to solve this but it is not working as expected. We are trying to prevent a Child Group of users called "App_Administrators" from changing System Security. We want them to be able to still 'view' security roles, groups, and users -- just not be able to make any changes. The Group called App_Administrators is a child group in the Administrators Group (which is needed because we want application administrators to be able to run OSD System Snapshots on demand). Since the child group is part of Administrators, we thought all we needed to do was create an Exclusion Group that effectively takes App_Administrators back out of Administrators and apply it to the ManageSystemSecurity roles (there are three of them). After creating the Exclusion Group and applying it to the following Roles  ManageSystemSecurityUsers,  ManageSystemSecurityGroups,  ManageSystemSecurityRoles, we found that the security group App_Administrators members could still modify security

Hi, I have an SQL data adapter that queries an application table, and one of the columns is the CostCenter. This CostCenter is also a dimension in our cube, where the table values correspond to the base-level members of that dimension. In the CostCenter dimension hierarchy, each cost center is either a descendant of Member A or Member B. I want to add a column to the data adapter that indicates whether each cost center is a descendant of Member A or Member B, so that users can filter cost centers more easily in their dashboards. Does anyone have any ideas on how I could achieve this?

Hi, Can someone suggest if the text file can be converted into xml file via business rule?

hi Team; I've a cube view showing accounts than need to highligh in red when overlap a number dependig the FxRate, I created an Finance BRule searching for a specific rate and multiply be a number where is more than this is highlighted in red. My problem is that number is recorded in a paramenter but is not working, maybe in the image below is showing better than my explanation; could sombody knows how is the parameter format? Thank you and best Regards Mario G

Hi all, I am trying to use conditional formatting in a cubeview and color all of the columns but I want it based on the cell value in Col3, not its own cell value. I have If (CellAmount > 0) Then ReportBackgroundColor = Green --- but I want it to be Col3 cell amount coloring col5.   Is this possible?

I need to create a composite mapping : For UD2, If Account is in range of 6099* and 6999* and UD2 is  [123 or 124], then UD2 is 100. In UD2 composite, If I put rule expression in composite like:   A#6099*~6999*     Target 100,  it works. But, I put expression in composite like:   A#6099*~6999* : UD2#123;124   Target 100. It does not work. It is ok, if I can even make  A#6099*~6999* : UD2#123 work. I can split above in 2 lines for list. But, I need condition for range and another dimension member. Any suggestions?  

We would like to enabled SIC in on-premises hosted environment. I see Azure relay setup is needed, is there any documentation or steps to perform those? Please advise. Thanks, Vasanth

Hello everyone!I’m trying to set up an Excel spreadsheet to be used in a dashboard, for users to be able to insert their FX rates in the Workflow.I’m using the XFSetFxRate formula, and it works when I hard code the time, for example ‘2020M1’. However, I need the time to be dynamic, to change based on the workflow.Is there a way to bring the Workflow time in the XFSetFxRate formula? I tried WF and WFTime, but it doesn’t work.Thanks!