OneStream Platform Forums

Auto Translation Property will impact the systeam performance in consoladation?

Hi , We are trying to upgrade our OS version from 7.4 to 8.4. We are following the Manual Guide provided by Onestream, and done with all the instruction as stated, But we are stuck at the last part where we need to configure the IIS Manager.  I am not sure what should be entered in the Username and Passoword. Our system is On-Prem and we used to connect to the software using this domain http::localhost:50001/Onestreamweb. Let's say my Username is ABC and password is 123. What should I write in the Username section ? Because some online instruction manuals say I have to write "domain/username" in here. I have tried multiple combinations but the connection is not working out. Please find some attachments below for reference.  Looking forward to your support and guidance, Any help would be appreciated

Hello - recently in our Production environment a new user inadvertently locked and certified all of the workflows used for variance commentary before they were completed for the period. These workflows are descendants of the top workflow for the actual scenario type. We were eventually able to unlock and un-certify them, but going forward, is there a way to prevent this from occurring again without assigning specific user groups to each individual workflow? Right now, all of the users that enter variance commentary are in one user group, because their property assignments change on a regular basis, and it would create a maintenance headache for our admin team having to keep up with the much larger user group population. 

We are having typical issue with Metadata, it's a single currency application. The Auto Translation for Currencies property is Blank and doesn't have any value. But when I check System diagnostics I notice that for all Entities(~12k) this property is having value and there is a warning. If I go into the property and see there is no value in the Stored Value, but "Remove Stored Item" property is enabled which is saying that there is some hidden value. I had to manually goto each and every member and click on "Remove Stored Item" property to get rid of the value. Reloading the metadata with this property set to BLANK is also not helping solve the issue. How can this be resolved without manually updating each Entity. Any thoughts anyone ?

Hi there, I'm trying to clean up the column headers on my cube view so that it leaves the view blank.  I have achieved this by adding the view to the member filter and using adding the following text:Name( ). I needed to use the view member filter since I've adding a trailing 3-month average column, otherwise the view member is determined by a dashboard parameter.   This works fine except for the column where I've needed to use the second member filter to designate the scenario such as the forecast column.  Does anyone know how I can modify this to so that the view member is blank for all columns?  

Hi,  Trying to upgrade from 7.3 to 8.2, I've been follow the "Upgrade Guide" from Doc-On-Premise but I have an issue at the end of the process.  I updated all Databases and Server configuration files as the documentaion shows.  I have Microsoft.AspNetCore.App 8.0.3 and the desktop runtime  Microsoft.WindowsDesktop.App 8.0.3. AspNetCoreModuleV2 is installed too.    But, when I try to connect to OneStream, the message is "Unable to connect to server using address "http://localhost:50001/OneStreamWeb": I've checked Event Viewer to get more detail about the issue and I got this information:  Thanks in advance for any help.  Regards    

Hi All,   I think i have a very simple requirement but i cant seem to get it to work. I just want the API to make use of the entity which the user is currently using in the workflow. The code i now have is as following                    Dim sURL As String = "xxx"                     Dim pkWFunitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si) Dim sYear As String = TimeDimHelper.GetYearFromId(pkWFunitPk.TimeKey).ToString                         Dim sPeriod As String = TimeDimHelper.GetSubComponentsFromId(pkWFunitPk.TimeKey).Month.ToString                         Dim sAPIKey As String = "xxx"                         Dim sYearPeriodParam As String = String.Format("?yearPeriod={0}{1}", sYe

When loading data to cube, through workflow step.  We can get Load error as below: Where are these load errors stored? I need to put these errors in an email content

Hi team , My client is demerging . So their current app has to be split into two new apps based on Entity structure.  What is the usual data migration strategy that is used ?  My question is more focused on Data Migration :  There are 4  sets of data :  1. Data Corresponding to Origin Import :  2. Data Corresponding to Forms  3. Data Corresponding to AdjInput ( i.e Journals Data) ( Along with Journal Information )  - Do we need to pass the journals again to the new Application or is there a way to export ( can be done using DM but any other way ) and importing them back in ?  4. Annotations  What is the best practices around it ?  What are the things that one should take care about ?  Regards, SS  

So this seems like it should be easy, and still may be, but it has me stumpt.  If I know the name of a cube, say "Houston" from Golftream, how can I determine within a business rule what Attribute and Value dimensions that cube has active for its various scenario types?  So in this example, for the Actual sceanrio type, Houston only has Attribute1 active with an alias of "InvoiceNo".  I can not figure out where to find this information.  I looked at both the Cube and CubeInfo classes but nothing jumps out at me.  It seems like CubeInfo has everything else but this information so maybe it is there but just not sure what property is is buried in.  Has anyone had to get this information for a business rule before?

Hello,   We have recently upgraded to v8.   With the new security properties on Adjustment Workflow Profile disabled, users still don't have the "Quick Post" button after creating a journal :  -Prevent Self-Post = False  -Prevent Self-Approval = False   Users have access to the 3 journal steps :  -Journal Process Group -Journal Approval Group -Journal Post Group   Does anyone know how to activate the Quick Post functionnality ?  Thank you.   Regards, Tahina  

Can you please provide a snippet of Finance Business Rule code showing allocation of data based on a driver.

Hi Guys, We got a request from user to get data from 2023M12 from actual scenario to forecast scenario. for Balace sheet accounts, the value from 2023M12 to be same till 2024M12 for specific account.  Can anyone help me to find way to retain same value for BS account, i have tried but due to activity calculation and endbalance input value, the value become zero for all the months. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- If Not api.Entity.HasChildren() AndAlso (api.Cons.IsLocalCurrencyForEntity()) Then Api.Data.Calculate("S#FCST_6_6_Test_Same_value:A#121010:V#YTD:T#2024M1:O#Import:U2#None:U3#None:U4#None:U5#None:U6#None:U8#None = S#Actual_Proforma:A#121010:V#YTD:T#2023M12:O#Top:U2#None:U3#None:U4#None:U5#None:U6#None:U8#None")End If If Not api.Entity.HasChildren() AndAlso (api.Cons.IsLocalCurrencyForEntity()) Then Api.Data.Calculate("S#FCST_6_6_Test_Same_v

Hi, I have downloaded the Narrative Reporting solution from Marketplace but 'Mode' dropdown option is not available in the Narrative Reporting Dashboard where it usually should be (I have drawn a blue box). Ss attached Please assist.

Is there a way to download OneStream Libraries to GitHub? We need to use gitHub for version controlling of the business rules.

Is there any documentation available for the backend tables in OneStream? Many of the tables are composed of keys pointing to other tables, and it can be challenging to discern the relationships between them. Additionally, understanding what each column in a table represents would be helpful. For instance, in the vStageSourceAndTargetData view table, columns like Wfk, Wsk, and Wtk essentially form the Workflow POV, but this isn't explicitly stated anywhere, making it difficult to interpret.

We can write a business rule to export data from the OneStream backend/custom tables, but is there an out of the box solution to do so? The Data Table Manager marketplace solution also has the option to export data, but only up to 5000 records.

in OneStream we can do custom table with process development, also there is Thing Planning where we can do process development. Is there any document or anyone can help us to provide the pros and cons of these 2 development methods? 

Hi, I am trying to access a file stored in Azure File Storage to import in the cube, but I need help to do that if I try using the REST API as the namespace Microsoft.Azure or any other Azure related namespace, as they are not available in the OneStream library.Has anyone encountered the same ?  Any better approach to achieve the desired outcome ? Thank you for your help 

Hi everyone. i want to make the following calculate, but i want to make the one of all the departments and all the projects, but when i put it as .base it gives me error in the calculate, then i would like to know how i can solve it or in what other way it should be made so that it works correctly.an image of my step configuration api.Data.Calculate("CB#[HLFPLN]:E#"& entity &":S#[" & scenario & "]:T#" & time & ":A#cra_639950:F#InCostsAllocation:O#Forms:I#11201_11207:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None = (E#11201_11207:S#[ForecastAllocation]:T#" & time & ":A#cra_ALLOCPRCT:F#None:O#Import:I#11201_11257:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None)*(E#11201_11207:S#[" & scenario & "]:T#" & time & ":A#cra_639950:F#None:O#Top:I#None:U1#ALL_DEPARTMENTS.Base:U2#P0000:U3#LOCAL_DATA:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None)",False)

Hi, Good Day ! I would like to change the Entity Relationship property from dashboard. When the user clicks the button, the metadata associated with the entity relationship property should be updated to reflect the option the user has chosen from the dropdown menu. Can you please help me how can I achieve this requirement.    Thank You     

We upgraded to 8.2.2 last month and switched our data connector to the SIC connector.  Since upgrading all our drilldown cube views (to stage data) have been loading slow.  Most of them used to load instantaneously.  Now some take 5-15 minutes to load.  Has anyone had this issue?  I have an open ticket with support.   They ran indexing and that helped but just a bit.  Thanks in advance.

I am trying to get dimension info using a member name. I came across the function, Dim nValue As Integer = BRApi.Finance.Members.GetDimIdFromMemberId(si, dimTypeId, memberId), but it requires dimTypeId. Is it possible to get dimTypeId using member name

How do I concatenate 2 member filters? Something like this:  

Hello!We are using the OS API to pull data to ADF using data connectors and cube views.  This has been working fine until we upgraded to 8.2.2 a few weeks ago.  Here's the error I'm getting in ADF.  Our URL actually didn't change.  Has anyone seen this or know how to fix it?  THANKS IN ADVANCE! Operation on target Copy Actuals from HTTP Endpoint failed: ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 400 BadRequest, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'. Request URL: https://xxx.onestreamcloud.com/onestreamapi/api/DataProvider/GetAdoDataSetForAdapter?api-version=5.2.0/.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (400) Bad Request.,Source=System,'