OneStream Platform Forums

I am writing to the community to see if anyone knows of a way to programmatically update a Parameter from a Business Rule to update the Filter Property (for a Member List or really any type of list). I can see the way to set the "Default Value" of a property but not a way to update the List which the property gets its values from. The member Filter is set to just reference Net Sales, but what I'd like to really do here is build the Member Filter from a list that I create in a business rule (Dashboard Extender, call to an Extender Rule, etc). I only see these options: This will set the value to 2024, but it has to be already in the List... This throws an error after the 1st entry, but still won't render in a combo box because I'm not really adding it to the List of Member Filters... This will set the 1st value, but doesn't work for a list ... only 1 value... I don't see in the api an ability to modify the Filter property or really inspect a parameter and change its other properties.

Hi there!I am using OS v8.1 and SIC with latest ERPConnectStandard20.dll and the other dlls.I can connect to SAP and retrieve data using READTABLE. Now I am trying to use CreateFunction but I am struggling.In my Smart Integration Function I have this :  Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.Linq 'Added for SAP ERP Connect Imports Microsoft.VisualBasic Imports ERPConnect Imports ERPConnect.Utils Namespace OneStream.BusinessRule.SmartIntegrationFunction.SAPTest8 Public Class MainClass Public Shared Function RunOperation() As DataTable Dim r3Conn = New R3Connection("1.1.1.1", "00", "user", "pass", "EN", "224") r3Conn.Protocol = ClientProtocol.NWRFC r3Conn.Open() Dim r3Func As RFCFunction = r3Conn.CreateFunction("BAPI_MATERIAL_GET_DETAIL") r3Func.Exports("MATERIAL").ParamValue = "1001" r3Func.Execute() Return r3Func.Imports("MATERIA

I would like to know if it is possible to search for contains when selecting data in a combo box. Right now when we search in the combo box for a certain piece of information it is filtered by starts with but we want to know if it is possible to perform this search by contains in a combo box.    

Hello, I'm writing a cube view and our old report (not in OS) has a max value calculation in the columns that looks at the current years values for each entity. I tried writing a GetDataCell(Max(A#Account)) but it's giving me no values. I looked through Golf Stream but didn't find anything but a member ranking which doesn't help. I've also looked at the other Min/Max posts, but they're not exactly what I need. Thanks, Will

Hello community,  Has anyone used a cube view extender rule to change between the portrait/landscape paper orientation on a PDF report? In our example, we are trying to use a parameter that allows the user to select the column template set needed, and although the idea of calling out the CV column template name sounds logical, I don't think OS has the capability to do this, similar to a column name as shown in the below example. Putting it out there just in case, as I promised our user we will explore different avenues.  

Hi All,  Is there a way to the use cb#cube in the data buffer FilterMembers?  I'm trying the following, but it does not work.    Dim sourceBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("RemoveZeros(FilterMembers(Cb#Cube:V#Periodic, [A#123.Base], [U7#Top.Base]))",)   Thanks.

We have a dashboard attached to the high level workflow that displays the status of specific steps within workflows. These dashboards utilize Report components adapted from the standard ones. While I understand how to make cosmetic changes to these reports, I need advice on changing the type of data displayed. In particular I would like to display the name of the user who certified the workflow step. Thank you in advance.  

When I run a OneStream book, the time zone in the footer is in UTC, which is 5 hours different from my time zone CST.   However, if I run the individual cube views that are included in that book, the time zone is converted from UTC to CST.  How do I get my books to properly reflect the CST time zone in the footer of each page?  Book in UTC time Ran cube view from book afterward and it is in correct CST time Thanks!  

Hi Team, We have client requirement that, Member needs to be moved from one parent to other parent. In this process, it should not impact rollup data for old parent for historical months. If any handle this in the past, please share your thoughts on this or any inputs would be appreciated. Thank you.  

I have the routine below that exports data from a datatable to a file.  I am writing to "Documents\Users\" & si.UserName.   The file gets created correctly; I am now trying to pick up that file with a business rule.  I am not familiar with all of the XF file functions.  I need to ftp that file to a remote server.  How do I go about getting the full path the Document\Users folder from another Business Rule. Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New XFFileInfo(fileSystemLocation.ApplicationDatabase, strFilePath) Dim xfFile As New XFFile(fileinfo, String.Empty, bytes) BRApi.FileSystem.InsertOrUpdateFile(si, xffil

I have an XFBR on the time filter on a Data Management step that pulls a list of time. When I run it on the Data Management tab it runs just fine and works. Now when i try to put that on a button to run on a dashboard, I get an error. I have tried using the Execute Data Management Sequence Server Task as well as running it through an extender rule. I am passing the required parameters to the either situation but im still getting an error? Why would it work on the Data Management Tab and not work while running it through a button?      

Our customer has been importing ANSI-encoded files to OS, which contains spanish characters, as 'ñ' and accents, for years. These characters were recognized properly until OS 6.8. But after migrating to 8.2.2, they are no long: 'España' is shown in the workflow as 'Espa�a'. This is a big issue for the customer, as they use the workflow stage tables for OS reports and export that data to a Data Warehouse. We have tested encoding a file as UTF-8 and worked, but changing the encoding the files is not a good solution for the customer as they load files from many different sources. This looks related to the migration: Is there any way to load ANSI-encoded files without this problem?

The Data Cell is read-only because the Parent Workflow Profile 'FR Food HR' has no active Input Profiles for the Workflow Channels that are assigned to the Data Cell's Account and/or UD member. Entity=entityname, Account=Accountname, Origin=Forms.  

Hi , I added a row from a different table to the Drill back table, but it's also showing up on page 2. Does anyone have any idea why? Thanks,    

I was wondering if it is even possible to create a transformation rule which involves different dimensions like the following composite A#[5000-0002]:UD4#[2010]:UD2#[2412] but adding ranges to it. so instead of having 10 different TR that have the UD4 going from 2010, 2011, 2012 to 2020, have only one composite including a range for the UD4 mentioning 2010~2020. Is that possible? what would be the TR be?Thanks    

Does anyone know how to get access to the "OneStreamGatewayService" Import through a Smart Integration Function in OneStream WinApp.  I am trying to run remote business rules/ remote queries through SIC but cannot seem to find any documentation related to SIC Server assemblies needed, or BR Assemblies needed to access this Import.   See line 10 below  

I have some BIBlend tables I have created during testing of a Workflow. that I want to delete/Truncate Resetting the Scenario doesn't do it. Do I need to do it programatically or via a Data Management job? When I try this it tells me that the SQL is not safe (I have tried with TRUNCATE TABLE and DELETE) Thanks Steve

Hi All -  I am wondering if anyone can point me in the right direction on how to reference a business rule to generate the SQL statement within a data adapter for SQL / External type data adapter? Any help would be greatly appreciated!

Hello Community, I have a puzzler for you.  My confirmation rule is set to evaluate a data intersection.  If the intersection is greater than zero, then an annotation is required in another intersection. I have tested both of the intersections in a quick view to ensure I have identified the correct data intersection members.   When tested, the rule identifies the numeric intersection (first condition), delivers the error message,  but does not identify the annotation intersection as being present.  Below is the rule: 'Check an Account value and if it is greater than zero, request a comment be made to a Cube View under the Analysis section of this pageargs.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:E#" & api.Pov.Entity.Name &":T#WFPrior3:C#Local:S#Actual:V#YTD:A#9610:F#EndBalInput:O#BeforeAdj:I#None:U1#Admin:U2#Top2:U3#TLOB:U4#None:U5#None:U6#None:U7#USGAAP:U8#None").cellAmountIf args.ConfirmationRuleArgs.DisplayValue = 0 Th

Anyone aware if the Smart Connector solution supports a way to access a SMB fileshare on the clients network? Use case is that client uses a file-share for flat-file exchange

Hi Everyone. I have some entities that have text at the end, for example “_Test”, and what I want to do is that in the data management I can remove the text at the end to use the original entities.Example: 12001_12000_Test to 12001_12000 I want to remove that in the section that is in the image, so I wanted to know if it is possible or if there is a solution so that the api.Data.calculate and api.Data.SetDataCell use that entity without the “_Test”.  

Hi all,I have a data management step which is of "execute business rule" type, and make use of parameters so that when I run it, it prompts me to select the parameters. The parameters are "member dialog" parameters.Now, since I want users to be able to run the step without giving them access to the Application tab, I am creating a dashboard that has a button in it to run the data management step.I have built some combo boxes that use "member list" parameters, created a data mng sequence that contains the data mng step, and a standard button which runs the data mng sequence. How do I pass the combo boxes selection to the data mng sequence?Thank you

We have created a book that when run outputs an Excel file that is 67 tabs.  It can take 20+ minutes to run on our desktop Clients and many times will time out if we are at home vs. in the office.  Anybody ever created something that would allow this book to run on the server and save the output to the Application Folder.  That would allow it to run using the Server resources and only impact our laptops when downloading the file, which should be manageable. 

Hi all, I am building a CV that needs to show quarter data starting from Q1 2022 with YTD data after Q4 of each year and wanted to build it as dynamic as possible. I am trying to avoid having to update the filters each quarter if hardcoded. I also have a parameter that prompts selection of a specific Quarter/Year. The layout should look like the below. Is there a way to do this dynamically? I am also coming across an issue when calculating the growth % on rows where there is no data. It is giving an incorrect growth % of -100%. I have tried conditional formatting to try to hide these incorrect % but can't seem to get it to work and wondering if there is a better way. Thanks in advance for any help!

we have 2 import steps on our workflow, the main Budget Import and the Fixed Cost Reallocation import. The main TB is loaded via the budget import and the fixed costs for this TB are loaded to 1 default department. Later, the entities will reallocate the fixed costs to the correct department via the Fixed Cost reallocation import, the reallocations use the same accounts but a different UD6 to distinguish between the 2 imports. But the original fixed costs amounts loaded via the main Budget import are being overwritten. Any suggestions to prevent the original fixed cost amounts be overwritten? we are using separate workflow channels, and we have tried flipping between using True and False on load overlapping sibblings but nothing is working. thanks