OneStream Platform Forums

Hi Team, Can someone please help to guide how to read the view last source & log file using business rules and save it back onto File Explorer for a user to access it. Regards  Darpan Bhansali  

Hi there,We are trying to test data provider endpoints using Postman but they always fail with Error: connect ETIMEDOUT xx.xxx.xxx.xxx:50001.I have read the documentation, manage to call Authentication API with Personal Access Token but no luck with other endpoints. OneStream support has enabled calls in IIS and has no clue what's wrong.For example:POST "https://{OurBaseWebServer}:50001/onestreamapi/api/DataProvider/ GetAdoDataSetForSqlCommand?api-version=5.2.0"Request Body: { "BaseWebServerUrl": "{OurBaseServerURL}/OneStreamWeb", "ApplicationName": "OneStream Test", "SqlQuery ": "SELECT * FROM Dim", "DbLocation": "Application", "ResultDataTableName": "ResultDataTableName", "XFExternalConnectionName": "", "CustomSubstVarsAsCommaSeparatedPairs": "" } Any idea?  

In a data connector rule, we need to run the api.Parser.ProcessDataTable funciton that can process a DataTable. However, using SIC funciton, we have to get data from the source into a XFDataTable: Dim xfDT As xfDataTable = Nothing . . . xfDT = New xfDataTable(si,objJobStatus.RemoteJobResult.ResultSet,Nothing,1000) The XFDataTable is created and we can see that it has rows in it. We convert the XFDataTable to a DataTable using: Dim dt As datatable = xfdt.ConvertToDataTable(si)  When we run the new DataTable thorugh the ProcessDataTable, we get an error: "Data load Ado.Net DataTable is invalid or null." When we try to count the rows on the DataTable, we get an error: "Object reference not set to an instance of an object" Is there any information out there about the differences between a DataTable and a xfDataTable? Is there another way to convert a xfDataTable to a DataTable that will no result in errors?  

Hi Everyone. What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get in a BR the value of an intersection, as if it were in excel. Example the childrens of this.  

I have attached the Parameter (Delimited) in the Cubeview. In parameter I have added a drop down what that drop will do it will add 2 flow dimensions members data which is huge. for 2 column data adding it will works fine but when I run it for whole entity.base or account.base, after few minutes OneStream forcibly stop process. how can I solve this problem ?

Hi all, Good Day ! I just want to launch my Input Value Parameter before my main dashboard gets launched. Can you please help me achieve this. Thank You  Noor   

We would like to automate the load process but there are always a few validation errors.  Is there a way to get the data to load excluding the ones with errors and email a report of the validation errors.  We would be able to load the good data and work on the errors before the following day load.

When I try to upload my file it shows up like this, and this is the excel sheet I am trying to upload: any ideas? thank you!

Hi OneStream Community - I'm trying to create a rule to apply a specific % to the base entities of a specific region. To keep it simple, say we have 5 regions and I want to create an account that takes their PBBIT and multiplies it by a % that is different for each region, and I want it to calculate it at the base entity level, of that region. Is this possible? Many thanks in advance!

hello team  i am new OneStream consultant  kindly need to know how to setup Midstream Metadata Manager on OneStream application   Regards 

Hello, Wondering if anyone knows how to set up dimensions in order to have the following requirement :  - Users with access to the cube Consolidation need access only to data from the dimension B - Users with access to the cube Accounting need access only to data from the dimension C - Users with access to the cube FP&A need both access to data from the dimensions B & C (dimension A) The following setup does not yet meet our needs :  Thanks for your help. Harry

Dear community members, I have a DM Export Sequence defined in a workspace.  However, i am not able to save the data source after assigning the DM sequence to the Data Mgmt Settings:Data Export Sequence. While i am able to select the sequence, when i try to save  i get this error message:  And while the new workspaces are awesome i dont seem to be able to correctly interpret this helpful note in the design & Reference Guide.  If OneStream lets me select my DM sequence, does that mean that my DM sequence follows these rules? I have a Non-Default Workspace and a DM Sequence Name. But alas ....We are on 8.2.2.  Any tips or references to a solution that may already be here on community would be much appreciated.  

Hello, I was wondering if there's a way to use one of the OneStream Excel functions (i.e. =xfgetmemberinfo) to grab data from a Cube View Connection? I know I could pull this data from the headers, but my work doesn't like using them really and was wondering if there was another way. Thanks, Will

I have SIC version 8.2.1 I already created the gateway and is online, is a Direct connect type configured to connect with SAP I already install the SAP dll in the SIC local When I try to compile my SIF in the Onestream App asks me for the Gateway, but I can't see my direct connect gateway, only shows the Database Gateway What I'm doing wrong?   Regards

Hello, You can add a sample file in OS for a delimited or fixed data source type.I cannot find where to find it in OS database in base64. I had a look at the [ParserLayouts] table, but i can now find anything more...Do you know where it is hiding?Thanks

Under Calculation Definitions, there are options to run a task for either Loaded entities or Assigned entities. 1.  I am assuming that loaded entities stops to filter through only those entities that are part of the data load?  Am I correct in this assumption?  I saw nothing explicit in the documentation to that effect, but maybe I wasn't looking in the right place. 2.  Has anyone ever tested to see what the performance impact of using loaded entities might be?  Up to this point, I have only ever seen assigned entities in a workflow.  

Hi OneStream Community, I hope you are all doing well. I am currently working on a project where I need to create a dropdown in a specific cell within the OneStream SQL Editor, and the values for this dropdown should be dynamically based on the value of another input parameter. Here's the situation: The SQL Editor only accepts delimited list parameters. I need to dynamically populate this delimited list parameter based on the value selected in another input parameter. For example, if the user selects a country from the first parameter, the second parameter (the dropdown) should display a list of cities from that selected country. I am struggling to find a way to dynamically feed a delimited list parameter based on the value of another input parameter. Could someone please guide me on how to achieve this? Any help, examples, or pointers to relevant documentation would be greatly appreciated. Thank you in advance for your assistance!

I have couple of Connector DS and multiple Flat file DS in OS.Currently, the client wants to include Eurpoean culture for some of the users. I noticed that the dataload is behaving weirdly. The same data load now multiplies the data into 100 for a Eurpoean user/ what are the possible places where this should be fixed? Please note that I have multiple Parser,Conditional BR running on DS and TR as well.  

Hi, Does anyone know a report that shows all workflow profiles and who processed them? I know that for forms we can use adapter - FormsStatusForWorkflowUnit, but it's just a forms - I need all inputs. Many thanks!

I am using below sql to get validation messages from the workflow transformation process to be used in  Transformation Event Handler. But, I need to put the output of this dictionary into a flat file. How I can read the contents of this dictionary created. Thanks so much for your help! sqlValidation.Append("Select * ") sqlValidation.Append("From StageToFinanceValidationError ") sqlValidation.Append("Where StageToFinanceValidationError.WorkflowProfileKey = '" & wfPk.ProfileKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowTimeKey = '" & wfPk.TimeKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowScenarioKey = '" & wfPk.ScenarioKey.ToString & "' ")   Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) dtValidation = BRAPi.Database.ExecuteSqlUsingReader(dbConnApp, sqlValidation.ToString, False) Dim sb_ValErrorsReport As New Text.StringBuilder() For E

Hello - I'm looking for a formula to calculate data from one entity to another for two specific accounts. I would just use a standard data management job for this since the amounts are not changing, however I want the sign to change, so the amounts will net to zero when the entities are consolidated in the same structure. Can I use api.data.calculate for this? And if so, would the formula be stored on the two accounts? 

Hello everyone,  newbie here,  We about to embark on phase 2 of our implementation with the first task of creating drill back capabilities to our Oracle EBS 12.2 (on Prem) application.  I want to try to organize as much of this as possible up front since my IT resources are extremely busy at this point.  I have been searching for guidance on the best options for setting this up, but have run into so much disparate information.   Is there any one of you fellow Oracle EBS users who would mind jumping on a call with me to discuss some of my options?  1.  Where can I find Oracle SQL code examples to drill back to trial balance, journal and subledger information 2. Where could I find OneStream code snippets that could be incorporated into my application for this drillback data.  Any help would be greatly appreciated.

Hello All,We are having a requirement where we need to export Dynamic Calc members through FDX. We have few dynamic accounts which are complex and it refers to different time periods like (T#POVPrior, T#2023, T#2022). So whenever we run the export, it generates a very huge amount of error logs , 1 Million, referring to the T# Summary: Error processing script '((Divide(A#ABC:U8#Sample,A#DEF:U8#None))*100)'. Unable to execute formula for member 'ABC'. Invalid script 'A#DEF:I#Top:T#LastActualPeriod- A#IJK:V#YTD' near 'T#'Here LastActualPeriod will be calculated based on current actual period, Example T#2022M1Any idea why this happens and any alternate ideas to come out of this and export the Dyn Calc Accounts.Thanks in advance for your help !

Dear OneStream Experts: Thank you so much for the great help in the past. I am converting one Hyperion Planning application to OneStream application and would like to know how to use if statement to check calculation flag. For example: I have 3 dimensions Account dimension has the following 3 members Sales Rebate Rebate_Flag UD1 - Product Dimension has many Members TOTAL_Product  Parent member with children(Product_1,Product_2,Product_3,,,,,,Product_N). No_Product UD2 - Country of Sale Dimension has one parent member ALL_Country and 2 children members ALL_Country   USA   Canada In Hyperion application, I have Rebate_Flag->USA->No_Product =1 Rebate_Flag->Canada->No_Product =2 I want to calculate Rebate only when Rebate_Flag=1. In OneStream, I want to do api.Data.Calculation("A#Rebate=A#Sales * 0.10", "UD1#Total_Product.base",true) But how to I apply the if logic. In Hyperion, I can do Fix(@Relative("All_Country",0),@Relative("TOTAL_Product",0)) If("Rebate_Flag

Is there any way to perform bulk copy of a compressed data table to an Oracle Database using SIC.