OneStream Platform Forums

Hi there  I need to write a composite UD1 composite mapping rule based on a another dimension (Entity)  Example :  looks to see if the Entity is a base of Parent A , then map it to UD1 X , otherwise if the entity is a Base member of Parent B, then map it to UD1 = Y Please help    

Hello, I am trying to seed data from Actual to Forecast scenario. I am running the Business Rule through a DM step, whose data unit contains the forecast scenario, so that it picks this forecast scenario in the destination string. My Actual (Detail level accounts) are on more granular level and extend my planning accounts (plan and forecast accounts). The planning accounts are on top level.  Now, when i try to seed the data, it picks the Planning Accounts (since i have Forecast Account in my DM step), due to which my  Actual accounts are not picked up by the process. and the data copy is partial. I am trying this by using DataBuffer. Please let me know if there are any suggestions or solution to this. Thanks

Hi . Does someone know what is the maximum number of members allowed for a product dimension?, we are assessing implementing the SKU reporting level and we manage around 13k products, I am wondering if the application can manage this volume of data. Regards.

I am building a balance sheet report where accounts will show on the rows. Under accounts receivable, we'd also like to show its payor breakdown which we use UD3 for the payor data. Is there a way to apply UD3 into the rows but only show for the accounts receivable section?

Is there a way to add a blank row/column within Cube View? I know it can be done, but can't seem to remember the code. I believe it was "|!Blank|"....   Thank you!

Dear community, we have requirement of pulling level 2 parent for a member in writing UD8 Dynamic calc, do we have any method of pulling it in writing business rule. Any solution to this will be very helpful and appreciated.    

HiCan anyone advice how to push OS data back to SQL server by using SIC gateway?We setup the SIC to import data from SQL servers to OS successfully in SIC business rule, but no idea how to push back data from OS to SQL by the SIC.Business rules created in Extensibility do not work like BRApi.Database.SaveCustomDataTable function.Thanks 

Hi Is it possible to configure default group settings for a grid view? E.g. I've got a table here, and I'd like to configure the table so that it is grouped by the message column: Regards, Mark

When a comment is added to a cell or file is attached to a cell, there is not mark on that cell for other users to know about the comment or attachment. Is there a way to highlight the cell with tick mark or anything else for the user to realize there is a comment? When view annotation is used to add the comment, it is not obvious to the user that there is a comment on a specific cell as there is not red tick on the cell. Appreciate your help!

I have a BI Viewer grid using 4 accounts. When I use these numbers in a grid or pivot chart, they can only be sorted alphabetically, or ascending/descending by the data. I would like to manually sort these numbers. E.g. My accounts are Automotive Expenses, Operating Expenses, Non-Operating Expenses and Total Expenses. I would like to sort it as: Operating Expenses, Non-Operating Expenses, Automotive expenses, and Total Expenses.  Is this possible? Thank you in advance.

Hi All,  We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ? Regards Sridhar 

Hello Community...       I can get only one cell data from using FdxExecuteDataUnit. But After that i want to get all data including Rows and Columns. So, For that any sample code...? or what format i need to use..?

Guys, We are using difference of  multiple CVR functions to get the value for a row, and it is working correctly in the Data Explorer , the data is also correct , but when we generate the report in PDF or Excel we are getting an error  in that cell with the name of the first row used in the CVR GetDataCell.For eg: If "GetDataCell(CVR(A1)-CVR(A2)-CVR(A3)-CVR(A4))" is the function , then the error displayed in the cell in PDF and Excel is "Error : A1" .Any idea why this is happening? Thanks

We created a customized application support security group (Pseudo Admin role) which excludes the accesses of cube view form input, JE create/post and user security provisioning.  This is required by internal control as segregation of duties.  We updated maintenance group setting with this Pseudo admin group in all applicable components. e.g. Workflow profiles, Transformation rule, dimensions, confirmation rules, Forms/JE template, Dashboards etc.  The limitations we confront are that the following components are accessible only to the default administrators.  Can we enable the discrete security settings to those components instead of default to admin only?  Thanks!System Diagnostic DashboardCATExtensibility business rulesDatabase under System tab

Hi All, We are facing an error "Unable to execute Business Rule 'BusinessRuleName'. Select a valid workflow, scenario and year, when executing step from PowerShell/REST API. We are passing the parameters using the option "CustomSubstVarsAsCommaSeparatedPairs". Please help if the execute step and the execute sequence works for business rules with parameters using Data Management api from PowerShell. Please help me with sample code. Thanks & Regards, Lova Ramisetti.

Hi Everyone,I have requirement to run 4 data management steps in parallel, is there a way to run 4 data management steps same time? Thanks in advance.  

  Good morning, I am writing to inquire about the correct formula for calculating the difference between two values in the same column in a Calculated Field of a Report Design. For example, if I wanted to calculate the difference between the values 121.46 and 120.30 in the "Col0Value" column, what would be the exact formula to use in the Calculated Field? The data are read from a cube view data adapter (not MD). The image below shows an example of the data from the data adapter. Thank you.      

Hi there, I have a Workflow Import process that runs automatically via Task Scheduler. My question is, is there a way to capture the Invalid Intersections then send it via email? The idea is to get alerted via email without opening the application that the Validation failed. Regards Jesse

Hi All, Does anyone have the Consolidation and Planning in separate applications? If so, what are the reasons for having them separate or what are the challenges.

Hello Community - I am using multi select combo Box to pass periods selected by user back to business rules, receiving the selected periods in the BR but while executing getting error "Error processing Data Management Step".  Under Data Management I have set Time Filter as WFTimeYear_CopyFAPC=|!ml_WFTimeYear_CopyFAPC!| and  Parameters = WFTimeYear_CopyFAPC=[|!ml_WFTimeYear_CopyFAPC!|]. It looks like the Time Filter is not processing multiple periods from the Parameters, what is the correct way to pass these periods into the Time Filter under Data Units section. Thanks.

I have an excel template. I had a DataList on a cell coming from another sheet.  I added the name ranges for the TableView as it gets data from SQl.  It used to work but it has stopped working and the DropDown of the list doe not happen. It shows the arrow for the partuclar cell but when you click it does not show the list.    Thank You, Indu

Dear Community: I am trying to add a previous year M12 balance to a SCF report.  I can't seem to get prior year data to come over.  However, If I code the amount it does work. ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#POVPriorYearM12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100:T#2022M12") does not work ' api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + A#33100") does not work api.Data.calculate("A#CF_RepaymentEquityInvestment = A#CF_RepaymentEquityInvestment + -62225") ' Returns amount as intended   Thanks

Hi all, i need to buil a chart that it is easy to build in excel, but I don't know how to handle it using a chart in the report designer of the report component.  The chart that i have to build is the one in the attached picture. It is a waterfall chart in which you can see the delta between actual and budget distributed on the different line of business (for example delta between actual vehicles and budget vehicles is 31.5, delta between actual rail control and budget rail control is 13.3... and so on). On the other hand though the two bars representing actual and budget have the percentage distribution of the line of business (for example for the budget you can see that the total is 439.3 of which 57% is for vehicles line of business, 37% is Rail Control... and so on). Is there anyway the chance to build a chart like this one using the report component?   thank you in advance.

Hi Everyone. Is there a way to delete accounts in a scenario that have a certain value, for example, 0?

Hi Does anyone know where all of the below information is stored?    Thank you, Mikki