OneStream Platform Forums

This may be a long shot but I was wondering if there was any kind of functionality to have a message appear if you leave a dashboard page/try to close out of it. The use case is that I have a dashboard that has a button that is hitting when a conference call happens and it updates security groups so certain users can't make updates during the call. I have another button the user SHOULD hit when the call is done and this will put the security back to what it was originally.  If the user of the dashboard forgets to hit that other button at the end of the call then the security never changes back. Was hoping to give a pop up message or something that forces the user to hit that end call button so the security goes back to what it was.

I'm getting the message "'Function GetLiteralParameterValue(si As SessionInfo, isSystemLevel As Boolean, parameterName As String) As String' 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.'."   Anyone know what object & method should I be using instead?     strSomeString = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si,Nothing,"pm_SomeParameter")      

What I have found is that using the BRApi.Finance.Members.GetMemberInfo or Metadata.GetMember calls with True for includeProperties or even the first call to BRApi.Finance.UD.Text(...) all incur an average of just over 2 seconds and we are looping through 27,000+ projects so 15 hours to check and update the text fields. It seems that it gets cached either in OneStream or the SQL server so a second call done in the update function is no additional cost. The Dimension Library object obviously does this a much faster way, maybe by specifying the individual properties wanted in one of the optional objects versus all properties?   There has to be a faster way.  When using the Dimension Library and setting Grid View's Settings to NOT display parent child relationships, you gain access to the Text# fields.  You can update a lot of these at one time FAST.   I have even updated a function I used to add calling the GetMembersUsingFilter with the option to include All properti

Is it possible to update the Application Security roles with in an extender Business rule? I want to be able to update the Modifydata role with the push of a button.

Hi AllI am updating the Admin Consolidations Dashboard (ADM) so that only some users can execute a Force Consolidate. I can hide the radio button group if the user does not have access but I am struggling to update the radio button group (Consolidate/Force Consolidate) so that the correct option is selected. The list of values for the radio button is controlled by a parameter (pm_ConsolType_ADM). In the LoadDashboard event I have updated this parameter using SetLiteralParameterValue (using v6.8). I am assuming that this is how the radio button selection is controlled as I can't find anywhere else where it can be set. If I click on the 'Reset parameter selections' it works.I have tried unsuccessfully to Redraw the dashboard like this:Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedSelectionChangedUIActionInfo.DashboardsToRedraw = "2_1_AutomationTasks_ADM"Any help you can give me is much appreciate

I need to build a cube view that shows my closing & average FX rates in my row set. Which dimension has these options? 

Workflow, journals Hi all, So our client wants the end users to be able to create journals but not post them. Group finance team will review and approve and post all the journals created. I think the security bit can be done using the workflow profile settings. The question is: Is there a way for the group finance users to see all the journals created by end users and go through them instead of navigating to every workflow to approve the journals. Is there a way to do this? Thanks

Hi Team,I am using Excel Column width option in cubeviews to reduce the width of Blank Columns in Excel but it's not working,Please provide me any suggestions

Hello OneStream Infra Experts, I would like to know if we are customer to OneStream and bought the cloud Onestream application, Can't we download and setup an Onpremise Onestream server like Hyperion Onprem version. Please let me know the server details and configuration to Install the OneStream. Thanks

Guys, There is a requirement to reverse the signage of all Revenue Accounts, So we have a Code that gets all The Revenue Accounts and Multiplied it with ' -1' , And the data is getting Flipped . But when we try to Consolidate that flipped Data , It is getting Cleared . Also When We try to run The rule 2 or 3 times , then also the Data is Getting Cleared. Any idea why this is happening. This is the code that does the flipping :Dim accountDimName As String = "Financial_Statements" Dim mFilter As String = "A#[4.00.000.000].Base" Dim lstAccounts As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, accountDimName, mFilter, False) 'filter on revenue accounts Dim lstRevenueAccounts As List(Of MemberInfo) = lstAccounts.Where(Function(x) BRApi.Finance.Account.GetAccountType(si, x.Member.MemberId).Equals(AccountType.Revenue)).ToList() For Each MemberInfo As MemberInfo In lstRevenueAccounts Dim nMemberId As Integer = BRApi.Finance.Memb

Hi All,I am trying to create a simple view using SQL in BR. it works if do it directly in SQL server so no issue with the syntax. When i am trying to do the same using a BR it gives this error: anyone seens this and know the reason and how to resolve it? Code:  

Hi,We are facing one issue where if we pass periodic entry then the next month it is automatically passing a negative amount of the same value but I need it to be zero only.Example-March =10000 (loaded at view periodic)April= -10000 (should be 0)Can anyone help me how to resolve this?

Hello, I'm in the early stages of building a long-term forecasting cube in our application. The initial requirement is that the business can load volumes, SSP, and product cost by product type to a single 'memo' entity, market, and customer, and then the model will allocate this across base members based on some % drivers.  The Entity piece seems the most complex as I need to translate the amounts to the local currency when allocating so that the business can perform sensitivity analysis on FX rate changes. I've managed to get something allocated across a few entities just using an ADC, however it is writing the amounts to local currency as well as GBP (group currency), which means that when the entities consolidate, they remain at their 'local' currency levels. I tried specifying the destination C#, but it seems to not allow this. Has anyone else done something similar, or knows if OS is capable of this?  

Dear community,  We build an Excel import template (XFDRange) for our client's planning process.  We understand it is possible to load Text Value into Stage; however, we need to retrieve the comments in a cube view for an overview, so the comments need to be stored in the cube. Currently, we set two different columns for the View dimension, one for Periodic view to import the data and the other for Annotation to import text.    We saw there were some similar questions raised in the community, but solutions are not applicable to our case.  Hoping to get some more suggestions regarding this!   Thank you in advance! 

Hi All, Does someone have a best practice regarding scope changes during the year or over the year? I'm already using Custom share so I could add logic which compares Current Period with Prior period relationship properties. Thanks in advance! Kind regards, Jorrit

Hi,Two questions related to XFSet Cell:1. Is there any audit trail to see who entered data via XF Set Cell?2. Is there any functionality where we can restrict specific users from entering data just into XFSetCell but allow them to enter data via other modes like Forms, etc.?

Hi, I have this loop that use multiply unbalance to get the UD3 member segmented in the accounts, this is the current rule but it's not delivering good performance:  I try to recode the rule like this but is not calculating as the loop:  Thanks for your time,

HI All,We are using Control m to trigger DM Sequence in OneStream with API call; we are able to trigger the job without any issues but now the issue is we are unable get response from OneStream to know whether DM sequence completed successfully or failed.Do you know the API, designed to provide success or failure?Thanks in advance.Thanks,Sandeep  

When I use the Pre-Aggregated Member settings, it is copying the data twice.  I've tried multiple settings and multiple scenarios.For example, I have tried just O#Top=O#Forms.  After I run the consolidation, there is data in both O#Import and O#Forms, doubled. It also happens with multiple Dimensions.  I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions 

I would like to create a derivative transformation rule that will add _Qty to the end of the Account and pull the ActualQuantity field from the data source as the Amount.My DataSource has a field for ActualQuantity.I have a Derivative Rule that looks like this:The complex expression on the derivative rule is:this returns 0 instead of the amount in the ActualQuantity field. Thank you in advance.

Hello All, We had to make changes to our 2022 (Prior period) data as we identified some issues with it. We cleared the data and tried reloading a bulk file with Full year 2022 data (Split Quarterly). Previously, We used to batch import data in one period (E.g. March), all the other quarter end months would automatically get a green tick and show data for that period in staging table.This time when we loaded numbers to March (data included periods M3,M6,M9,M12 for 2022), we can only see the data in March (M3), we are not able to see data in other periods. Please find the below snap for  reference.   Any help would be appreciated.

Guys , Any idea on how to write a business rule that retrieves a list of all Revenue Accounts .Thanks 

Hi,I am experiencing a strange behavior with a piece of code in the drill back of a connector rule.I have the following piece of code: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") 'Else ' whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If  When the ELSE condition is excluded as above the first IF works:However, with the ELSE condition included (see code below) the retrieve from the Zero values does not work anymore: If StageTableFields.StageSourceData.DimUD1.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL) ") Else whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If Any idea why this is happening? Thank you

Hi,I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary.As I have to change the view to “Annotation” in order to import a text value, I was thinking about duplicating the rows by a derivative rule and change the view in that rule. The outcome shows the duplicated rows, but these are missing the text value. So this approch is not working.I also tried to duplicate one time column and use a parser rule to change the view. Doing so, I would need to identify, which time period I am in during pasing, as otherwise all rows are changed.Any ideas about that?Regards,Tobias

Has anyone used BouncyCastle succesfully for PGP decryption? If so, would you mind sharing your BR?Thank you!