OneStream Platform Forums

I am trying to revamp the data integration between OneStream and Oracle Financial Cloud. The implementation partner used HttpWebRequest throughout the integration business rules but under platform 8.2 this functionality is now obsolete. Is there a working sample from OneStream on how to employ HttpClient with Oracle? 

Hello Experts,  We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account)This has to be done for range of accounts. I am not sure if there a any functions to refer data value for row? (GetSource and GetTarget seem to be only for dimension data)Any ideas on how we can achieve this? Thanks In Advance,

Hello ... Under platform 8.2, we get warnings in business rules that reference function QueueDataMgmtSequence. Does anyone know what function should be utilized instead?  1) Warning at line 114: 'Public Overloads Function QueueDataMgmtSequence(si As SessionInfo, sequenceName As String, customSubstVars As Dictionary(Of String, String)) As TaskActivityItem' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'.

I am looking for a sample code for SqlTableEditorSaveData function to restrict saving No value from my SQLtable editor drop down. I have Yes, No  and Yes_optional in my drop down but I don't want user to save No option as yes and no are based on some value criteria but they can select Yes_Optional.      

Hi, I have a button that runs a dashboard extender business rule. Between the 4 server options available, which one should I choose when, and should I even care about choosing the right one (i.e. when does it make a difference)? Thank you      

Hi all, how do you run an aggregation, i.e. calculate the "Aggregated" member of the consolidation dimension, without running a consolidation? In particular, would it be possible to setup the Process step of a workflow profile so that it runs an aggregation (as opposed to a consolidation/force consolidation)? Thank you

Hello Experts, I am looking to write a Dashboard Extender rule by which I can fetch the list of all the dashboards under a Dashboard Group and set the value as a delimited list to a Parameter.  Is it possible ?  The idea is to dynamically populate a list with new Dashboards as they are added.  Please suggest other workarounds if the above is not feasible.    Many Thanks   

Hello Expert, Is it possible to make employee register fields mandatory? we want users to select certain required fields before committing save.  Let me know, thank you

Is it possible to update a users security group with a business rule? If I have them in Group A but want to add them to Group B without going to the system tab and updating their security manually can I update their groupings with a Business Rule? 

Hello Everyone,We have been using ExecuteFileHarvestBatch to automate our Data Loads. However I could not make it work for Direct Load profiles.Is anyone aware if we have api support to automate Direct Loads?

Hello Experts,I'm trying to automate an export of account hierarchy which is then used to replicate same hierarchy in another app/tool. However, when I export Metadata in XML (tried both via Business Rule or via Application>Load/Extract) , it doesn't capture information on order of arrangement among siblings.So, while loading XML extract to new app, by default all siblings are arranged in ascending order of their member names.Is there a way to capture this information when doing export? Thanks,Gaurav

OneStream is the best EPM app for consolidation and everything planning - it is going to kill Hyperion / Essbase !! Does anyone have a sample business rule BR for sorting rows in a column based on values in a column.  e.g. in screen shot, I want to sort by ascending order of values (NR) in column B  in Cubeview? I probably have a written something similar long time ago, but would like to see if someone else wrote a better BR.

Unposting

Apologies if this question has been answered elsewhere - I have been searching for a while but didn't find anything that solves my problem.I have a cube view with a single column whose member filter is T#|CVTime|.BaseIt displays 12 columns, which is great - one for each period of our fiscal year. For example, if CVTime is 2025 then the cells of each column going left to right will have their POV Time as 2025M1, 2025M2, ... 2025M12. Wonderful!However, on a single row within the cube view, I want to instead display values from the previous fiscal year using a column override for that row.  In other words I want the POV Time for the cells in that row to be 2024M1, 2025M2, etc.Seems straightforward but the two seemingly obvious options I tried do not do the trick:T#YearPrior1(|CVYear|).Base  (yields 2024 for each column.) T#YearPrior1(|CVYear|.Base) (yields 2025M1, 2025M2, ... 2025M12)   - I don't know if it matters but it's not clear to me if that's how the syntax

Does anyone have information on how to get Data Cell Access (Slice) Security (henceforth DACS) to work when applying it to multiple UD dimensions?  The app has the entity and scenario security set.  Those are working fine.  If I put only one UD in the DACS, that also works fine.  The problem comes in when subsequent UD dimensions are added to the DACS.  It seems OneStream ignores the DACS and goes back to entity and scenario security. To add a bit more information, I have tried it multiple ways, with the multiple UDs in the same or different rows in the DACS setup.  It doesn't matter. Thank you.

Is there a way to format 'NoData' cells so that when the report exports to excel it shows a dash or 0, instead of the cell being blank?

I have an IsOptional=True direct connect Import/Validate/Load Workflow channel.  I would like to be able to Complete this Workflow channel via the OS api without having to import/validate/load anything, the same as if someone selected the 'Complete Workflow' button just to the right of the 'Clear' button in OnePlace.  Actually, I have a number of such workflows, some are only required for M12 and others are placeholders for data that is being copied directly into the cube from other non-linked cubes. I can complete/revert the Workflow channel if it is set to Workspace using BRApi.Workflow.Status.SetWorkflowStatus().  And I can revert Import/Validate/Load workflows with the SetWorkflowStatus() too, but I do not appear to be able to complete the WF unless I'm at the last step or advance the steps with SetWorkflowStatus(). The BRApi.Import.Process.* functions will advance me through the Import/Validate/Load steps, but I cannot see how to do so without the functions imp

Hello, We have a client who has requested the ability to use the alternate translation currency property on specific parent entities but then also to be able to pull that alternate currency in reports without changing the currency in the POV. For instance, the parent entity's currency is USD and it will be setup with EUR as an alternate translation currency in the equity pickup property section. The children of that parent entity are all EUR currency entities. In their reporting they would like to be able to show parent entity and children at the EUR without changing the Cons POV. The reporting could have multiple instances of this setup with different entities and currencies so setting the Cons to EUR wouldn't be an optimal solution. Ideally, they would like to set the consolidation to local for the whole report. We have alternate hierarchies setup but they would like to only worry about one member name for the parent and one hierarchy. Does anyone have any suggestions on how to achie

Hello everyone,I am trying to create a table in OS with the fx rates by calling an APIwhile calling the API, i can get the data needed but i have this error <Type 'SqlBulkCopy' is not defined.> that's doesn't allow me to copy the data in a table in OS.this is a part of the code, the lines in orange are the ones not working. 'create table ' #Region "Create Table Currencies_Mantu" Dim sSQL As String = $" IF OBJECT_ID('Table_rate_mantu') IS NOT NULL BEGIN     DROP TABLE Table_rate_mantu END   CREATE TABLE Table_rate_mantu (            fromCurrency varchar(255),     exchangeRate numeric(18, 5),     date varchar(255)   ); " Dim strPeriod As String = "" Dim strCurrency As String = "" Dim strPivot As String = "" Dim strclo As Double = 0 Dim vavg As Double = 0 For Each row As DataRow In dt.Rows strCurrency = row("fromCurrency") ' strclo = row("Value1") vavg = row("exchangeRate") strPeriod = row("Date")

 

hi Experts, i've a member formula (stored calc) to calculate %. My scenario type is periodic. i'm calculating % for various P&L accounts. M1,M2 and M3 %s is correct but for quarter, system is adding M1%, m2% and m3% which is not right. i want to write specific logic for qtr..for example: take quarterly expense and divide by revenue to calculate Qtrly %. is there a way i can override Qtr%? i may use dynamic calc to override V#QTD in report. but just wanted to know if there is more elegant way of doing this. pls guide

I'm trying to pull a Text field from a workflow in a transformation event handler rule but ran into an issue.  I originally tried to use api.Workflow.GetWFText1() but that does not work in a transformation event handler rule.  Is there a way to get it using a BRAPI

Is the any documentation available on all of the listed functions in OneStream for namespaces/libraries? other than API Overview. 

Now I have it in two places on the tree.  It includes children with data.  I need to delete the one I just created, including all of the children, but I'm getting an error that says it can't be deleted with data. How can I go about fixing this?  

Hi All, I want to ask about my issue on FDXExecuteCubeView. It cannot export annotation columns or columns with text even I have put the parameter includeCellTextCols to True. Here's the annotation column member filter :  Fyi, the annotation appears in cube view but not in data table result from FDXExecuteCubeView.   Thanks for your help.