OneStream Platform Forums

I'm trying to create a Dashboard parameter that has the OS Version number of the application. I would have thought that something likeDim osVersion As String = OneStream.Shared.Common.GeneralStrings.OSVersionwould return the value, but this simply returns the string "OS Version". Can someone please point me to the correct function or member to get the application version number?

I ran an import which was stuck on parsing data, I clicked on Cancel Task, but it has been stuck on 'Cancelling By User' task status for over an hour.Any solutions to cancel the task? I am unable to rerun the task as it is still "running"

I want to update the parameter of my dictonary . How can i achieve it? .add adds the value in the dictonary. Is there any update function to update the value of that key in dictonary Dim params2 As New Dictionary(Of String, String) params2.Add("Entity_param_db","E001" ) For Each MemberOfList As MemberInfo In Nonstreamproduct             params2.Add("Entity_param_db",MemberOfList.Member.Name)             BRApi.Utilities.StartDataMgmtSequence(si,dataMgmtSeq2, params2)Next

HI All,Good morning.Could you please share the documentation on 'Auto translate Currencies option' in entity properties. Also, how it works in below mentioned scenario.Scenario:  I have parent A and Children B both are tagged with Default currency 'CAD', but I want to translate Base and parent to USD in this case can I set Auto translate Currencies option to USD to convert data to USD without changing Parent A default currency to USD.Thanks in Advance. Thanks,Sandeep 

I am trying to do a calculation for a few specified members (putting to E and U4) but only for base of certain hierarchies under Account and UD1.  Here is the example of what we want to do: api.Data.Calculate("E#NonRolled:O#BeforeElim:F#EndBal:U4#NonRolled_Calc = RemoveZeros(E#1000X:O#BeforeElim:F#EndBal:U4#Reported - E#2000X:O#BeforeElim:F#EndBal:U4#Reported )","A#Management_Income_Statement.base") However, I understand you can not have Entity as part of the left hand side the equation since it would create an invalid data unit. Does anyone know a way around this, or an alternate way to accomplish this?  

I am trying to assign the text field stored value in a variable in Business rule. Here is my code that I am trying- but getting a compilation error.  dim pov_U7text1 as String = api. pov.UD7.Tex1   Please advise  

Hello everyone, I am trying to create a data source with two numeric values, one being amount and the other one being volume. But I am not sure if this is possible. Objective would be to be able to look at a P&L either in currency amounts or in unit volume. Is it possible?like this 

I need to load a XML file with a Business Rule. Like read the XML in a folder and load it automatic in OS.Is it possible? Thx on advance

I am creating a dashboard that has several sections. The middle section is a cube view and I need to add horizontal and vertical scroll bars. I looked at existing dashboards and can't find where the setting is. Could someone please advise where to change the settings. Thanks.

Hi everyone,I'm struggling with a feature of cube views, hope anyone can helpWhen i insert on the same row two dimensions, selecting for the second one more than one element, as shown belowas soon as i launch the cube view, the U2 dimensions are shown grouped:and i need to click + to show them.Is there a way to prevent the elements to be automatically grouped when I launch the CV?

Hello ! I would like to use a data buffer that would read data from another Scenario than the one set in my data management job, is it possible ? Right now, I have a simple formula that should retrieve data from scenario S#Simul while I'm running the business rule from a data management which is set on S#Actual, but it returns nothing :   Dim dbr_keys As DataBuffer = api.Data.GetDataBufferusingformula("RemoveZeros(FilterMembers(S#Simul:V#Periodic:AEAccount1:F#None:I#None:O#Forms:U2#None:U3#US:U4#None:U5#None:U7#HO:U8#None:F#None, U6#C4.Base))",,False)dbr_keys.LogDataBuffer(api, "dbr_keys",100)   Is there a specific data buffer script to use in order to run on another data unit ?   Regards,

Dear community, I'm creating a very simple balanced journal template, with the exception that this journal will have to use "alternative input currency" flows. For that, I have set 2 flows like below : Input_USD : Input_CNY (chinese yuan):   My journal is of "balanced" type. However, I have input done in both USD and Chinese Yuan and the Journal doesn't seem to care ? In the exemple below, I have 20 USD booked, and 20 CNY booked, and OneStream considers the journal posting as "balanced" : Am I missing something ? Regards,      

We have our main hierarchy that has intercompany eliminations working as they should. We also have 2 alternate hierarchies where one is eliminating as it should, and the other is not eliminating.  Consol -   Primary Hierarchy - Percent Consolidation 100Consol - Alternate hierarchy - Percent Consolidation 0  - Elimins not working at first common parent,Second Alt Hierarchy - Percent consol 100 - Eliminations working as they should.  

I need to update a WFP property through a Business Rule, properties like AccessGroup, WorkflowName, etcIs it possible? Thx on advance

I am building a cube view that has 3 row set options. The user selects their row set by a parameter, placed in the row sharing property of the cube view. Depending on the row set selected by the user, I need the page caption to change. The page captions for each row set options are static and will not change. Is it possible to pull the page captions when the row set is selected? Or, can I make the page caption change depending on which row set option is selected? I would like this to be selected concurrently with the single parameter that already exists. I don't believe I can pull the row set POV to the page description, and I cannot figure out a way to pull a delimited list based on another delimited list parameter selection.   Hypothetical example: The user selects from 3 row set options; GBP, EUR, or USD. Depending on their selection, the page caption should read 'Investment Report GBP', 'Investment Report EUR', or 'Investment Report USD'. The row sets are different depend

In the extensibility rule, there is a case choice of ExtenderFunctionType.Unknown. I am wondering in which situation we should use this? It would be great if we could have a few use cases with examples. Thank you

I am trying to load data into a new cube from the vStageSourceAndTargetDataWithAttributes table.  I am seeing most lines duplicated numerous times and the only field I am seeing with different values is the 'Ri' field.  I have not been able to find a listing of the definitions of the fields in this table and so am struggling to determine why the data is duplicated in Stage.  I have checked the actual data import from Snowflake and it does not show duplicates at any stage of the import process. The SQL I am using to pull the data is: SELECT TOP 100 *FROM"vStageSourceAndTargetDataWithAttributes"WHERE Si = 'SF_Rev_Summary'AND Ac = 'ACCT0334_AC'AND Et = '0034_ME'AND Tm = '2023M1'The results from the data adapter are below, the first 5 rows are duplicated apparently due to the 'Ri' fieldI appreciate an insight or feedback folks may have. Thanks

Hello,For purpose of grouping we have some accounts listed as member filter in a single row:A#VOL_O_StockWIP:Name(Opening Stock Volume), A#VAL_O_StockWIP:Name(Opening Stock Value) etceteraSome of these would need a different format to make it easer to recognize them, if I make a separate row the grouping on the primary filter will be gone.Is there a code that can be used after a member filter to apply formatting?A solution in either the cubeview, or Excel AddIn would be helpful.Thanks in advanceBen

Hi dear Community, I'd like to know whether it's possible to create a dynamic CV description somehow. So far, I've tried using parameters, substitution variables, and Business Rules (BR) in the description field but it's always considered as a plain string. Thank you in advance for your help. Best regards, Carlos  

I am creating a cube view by defining "member.childrenInclusive" on the rows. Is there a way to increase indentation on the child members without defining each members on separate rows and specifying indent levels?

All,Is there a way to extract metadata(entity dimension) with just parent child relationship information and not all the application member properties  using the usual export process?

Hi All, We are using XFGetCell's all the time in excel and one of the user reinstalled MS Office recently and he started facing issues XFGetCell. Please see screenshot below. XFGetCell function is defaulting to OneStreamExcelAddIn.XFFunctions.XFGetCell and this is causing refresh issue. If I try to remove the highlighted part the sheets are working fine. Any suggestions will be appreciated ? Thanks Sridhar 

HiI am executing a data management sequence from a business rule and I would like to display the task progress dialog box. Is this possible?e.g. When I click run from the Data Management tab I get the following:I would like the user to see the same thing when I run the data management sequence from a business rule.Regards,Mark 

I am wondering where are the files in the Application Database Folder and System Database Folder physically stored? I am able to find the files under FileShare in the directory where OneStream is installed, but I cannot find the physical folder structure of the Application Database Folder and System Database Folder. Please advise. Thank you

Hi,We have a workflow as below - contains multiple 'Import' workflow profiles.  We want to be able to lock 'IFRS16' without locking 'ImportAX', 'RevenueImport'.  Lock after Certify is activated.  When selecting IFRS16, Lock, all 'import' profiles are getting locked.  Do we need Workflow Channels or split the Workflow and keep IFRS16 separate ?  Thanks for your advice. HildeWhen selecting Lock with IFRS16 highlighted :