OneStream Platform Forums

I have a loaded set of base data in our People Register, but this needs to be amended to capture New Hires, Leavers, Promotions etc. I had thought that this would be possible by using the excel file template that was used for loading the base data. I've tried doing this for a leaver, where I have manually changed the base entry to show the "to period" as the month that the person leaves and then created an entry in my blank template to show the remainder of the period with no salary (this enables me to build a bridge of starters, leavers etc.) When I load the file the new entry overwrites the row already in the People Register. What I need it to do is to add a row. The load method in the file shows "Merge" and I wonder what I should change this to in order to get the import of the adjustment file to add the adjustment rows rather than overwrite them.      

Hi all Onestream stores a lot of information using an integer ID instead of a name. And most of the time we also deliver a simple way, to get objects (or names of objects) using an api or brapi call. Somehow getting the name of a dimension from its ID is an exception. Is there a simple way to do it? Cheers  

Hi, in the getting started with BI viewer I see they make use of a date field, which enables you to drill down to quarters/months etc. How do you create such a field (I guess I have to something with the time dimension which contains my years and months). I'm struggling with finding an expression that works...

Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type.  This shows you the results in a hierarchy that can be expanded or collapsed.   When building an interactive dashboard I need to present the user with a large number of members to select from.  The Combo Box option isn't particularly easy to browse through as it simply lists the members (albeit this can be indented with a BR to imply the hierarchichal relationships).  Is there a way of replicating the Member Dialog Parameter Type in a Dashboard component? Regards,Lee    

Hello Experts, I am trying to export Cell Details to a CSV using a business rule function as shown below:     If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Export_CellDetails_CSV") Then Dim wfUnitInfo As WorkflowUnitInfo = api.Workflow.GetWorkflowUnitInfo() Dim SRCTimeName As String = wfUnitInfo.TimeName Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) Dim timeStamp As DateTime = DateTime.Now '.UtcNow Dim AESTNow = System.TimeZoneInfo.ConvertTime(timeStamp, TimeZoneInfo.FindSystemTimeZoneById("AUS Eastern Standard Time")) Dim timeString As String = AESTNow.ToString("yyyy_MM_dd_HHmm") Dim xfolderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.fileShareRootFolder, si.AppToken.AppName) Dim csvFilePath As String = xfolderPath & "\" & "Cell_Details.csv" If File.Exists(csvFilePath) Then File.Delete(csvFilePath) End If

I am building a cube view with two rows and 12 columns. Assume POV=2021M12:   The first row is A#Sales and in the second row I want the variance of the sales from row one this month minus the sales last month. (Think POV minus POVPrior1)   In the Column I have one Column with T#POV.AllPriorInYear.   The problem is that the formula in my month over month isn't smart enough to populate 12 cells of variances.    I know I could do 12 separate columns and use CVC, but that isn't a great option to me for other reasons. Anyone have any ideas on how to do this?

Hello, I am working on a CTA plug account and also historical overrides. Right now for the plug and overrides to run I have to force calculate and translate. Is there a way the user would be able to run the consoldiation and the formulas run correctly without having to go through a whole sequence of steps? Basically, is there an easier way to run the translation logic within consolidation? These are the current formulas I have: CTA Plug with formula pass 8 being used: If (api.Cons.IsCurrency() And Not api.Cons.IsLocalCurrencyforEntity()) ThenDim entityDimPk As DimPk = api.Pov.EntityDim.DimPk Dim entityId As Integer = api.Pov.Entity.MemberPk.MemberId If Not api.Members.HasChildren(entityDimPk, entityId, Nothing) Then api.data.calculate("A#313001:F#TB_ENDBAL:I#None = A#TotalAssets:F#TOT_USGAAP:I#Top - A#TOTALLIABEQUITY:F#TOT_USGAAP:I#Top") End If End If and for overrides I only have one formula being used for “Historical Override Prior” on Formula pass 1. I think this may be part

Hello,   We are using scenario types 1 and 2 to house multiple scenarios. I'm running into an issue where i can't correctly split out the needed scenario forms separetely. For example, The forecast scenario (scenario type 1) shows the budget forms since budget is also under scenario type 1. Is there a way to filter out the different scenarios? Because it's all under Scenario Type 1 the forms I'm using contain all scenario forms needed.   Thanks!   Paula

Happy New year Y'all,  Is their a way to extract entity dimensions and load inside a dev environment? I don't want the entire application extracted. Any ideas will be appreciated.  Thank you!

So I currently have this cube view: Is it possible to configure the cube view so that the headers for the second member expansion (for UD2) start expanded, while the other row headers stay collapsed? Ideally it would look like this: I have tried using the following header format: However, this doesn't work, presumably because RowExpansionMode is a "Entire Cube View" setting. Is there a setting I'm missing, or would it be possible with an extender rule?

Hi community 🙂We have created a new scenario (not actual or forecast) for manual KPI accounts ( no formula on them), e.g Market share. We would like to create a input form where the submitter should populate e.g. market share for the specific month, for the specific QTD and YTD. I asked a question earlier regarding the account setup for this and I got the answer that they should be Account type Balance.  From my understanding you need to say Periodic or YTD on the Scenario settings (default view, input view for adj etc). But what to put when it´s regarding these kind of accounts?  Also, regarding the input form. Now we have built YTD and monthly in the same form. For QTD in a separate form. But when populating an amount in monthly, the YTD is automatically updated with the same amount. Any suggestion on setup in the CV to not make them "talk" to each other? 

Source:   Migrated from Champions Hello all, I’m creating a Data Adapter that is using SQL to poll an external database. I can get it to work when I’m just supplying the strings for dates. However, I wanted to get fancy and be able to parse the effective dates using variables. When I go to an online SQL tester (https://www.w3schools.com/sql/trysqlserver.asp?filename=trysql_func_sqlserver_left), I can get the below code to return ‘121181’, which is the Julian date I need in querying JDE. But the OS SQL Query returns an error saying ‘int’ is an invalid token. does anyone know if there’s a way to use variables in this way? Declare @YearRun intDeclare @YearPart intDeclare @MonthRun intDeclare @Global varchar(100)Declare @GetTime datetimeDeclare @RunTime varchar(100)Set @Global = ‘2021M6’set @YearRun = LEFT(@Global, 4)Set @YearPart = Right(@YearRun,2)set @MonthRun = Right(@Global, Len(@Global)-CHARINDEX(‘M’,@Global))Set @GetTime = EOMONTH(CONCAT(@MonthRun, ‘/’, 1, ‘/’, @YearRun))S

We are looking at the performance of several huge base data imports.  What are the best practices for setting cache page size and cache pages-in-memory limits for the best possible import performance?    We have broken the data load up into >40 separate imports but we still have some imports taking over 40 minutes.  I am hoping there might be other ways to improve the import time without having to break the data imports up further.  

Cube View: When trying to sum a column that contains T#POV.AllPriorInYear the return is only for the first column reported. Is there a function to sum these in the cube view? I am combining scenarios that can be dynamic and need to sum the results. Same would be true for AllNextInYear.

Hi everyone,  I have a cube view that uses an entity parameter with member filter E#Root.WFProfileEntities for users to select their respective workflow entities when opening the cube view. However, the list of entities depending on the workflow chosen is quite large and the order of entities in the dropdown seems to be random, when I was hoping the order would mirror the entity assignment order in the workflow section. Would anyone have any suggestions on how to organize entity dropdown list as per workflow entity assignment?  Thank you,  Royce 

Hi. Question regarding accounts. We would like to create an input form templates for KPIs. An example is Market share. We don´t want it to be summarized (month+ month=YTD), is the best to put it as Balance on Account type then?

Hi community, We are doing some changes in the legal structure and we would like to move an entity from one EntityDim to another EntityDim. Best would be to copy the entity to the new structure  and put in a "to date" in the old structure and a "from date" in the new structure under "In use"-parameter I guess to keep the history. Does anyone know if that is possible? The entity will have the same ID.   Or do I have the rename the old entity and create a new with the same name in the new structure? Or any other ideas how to move an entity to a new mother?

Hi all How can I avoid the ampersand in string operations? I need to concatenate a pov for a calculation, but with all the ampersands, it looks complicated: "A#" & accountName & ":F#" & flowName & ":UD2#" & ud2Name & ":UD4#" & ud4Name  

HelloI've tried to load my excel file through the data source fixed files with a complex expression on the time dimension, and i think it doesn't go through the complex expression at all so i'm wondering if i can use a complex expression in fixed file data source ?    The check i'm trying to do is to verify the workflow period and the time that's in my load file. if it's the same it can continue loading but if it's different i'm asking OS to pop up a error message.If anyone has an idea please share it with meThanks 🙂

Dear Community - Is there a way to convert to Basis Points within Cube View? I'm sure there must be a setting. Any help will be appreciated.   Thanks,

Hello everyone,Hope you are doing good.I have a little question, im trying to load an excel data file using a time parameter that will allow to put load the workflow time automatically, but OS tell me that |WFTime| is Unmapped.   does anyone know if using the parameter wrongly or shouldi use another parameter ? Thanks in advance for you help.

Hi there,  I want to add data to a dictionary with a key that contains 3 fields. I've been advised to use a ValueTuple but have tried all the syntax options that i could find in Google without success.   Ideally it should be like the setup of a databuffer where the key is the databuffercellPk and the value the actual stored number. My key should contain 3 strings and the value a decimal). I've tried something like: Dim dctDict as New Dictionary<(String sn, String Tm, String Ac)>, int(); and various other options.  Does anybody had a suggestion how to create the best performing Dictionary Key that exists of 3 strings?

Hi - We are try to create logic that will determine whether a scheduled job would run. We have been able to create the logic to only run if current date is <= to the day of the month (Calendar Day) but what we really want is to be able to know if it is before for a specific working day so excluding weekends (for example working day 10 in September 2021 would be the 14th) . Has anyone created this logic and would be willing to share?

I've been given a task to debug an error that happens when we confirm a month, and I'm not sure what some of the messages are telling me.   When I run Confirmation, I get an error in a dialog box, and the title of the Dialog Box is "Extensible Finance." Should I be looking for a confirmation or a business rule with that name? The error text is "A#Facilities_Allocation:F#None:O#Forms:I#None:U1#None:U2#1:U3#None:u4#None:U5#None:U6#None:U7#None:U8#None" which I recognize as a ... I forget the term but I think of it as the filter parameters. But I'm not sure where to look for this. If I scroll down further in the task activity and open the error message to see the details, I see a line that says      Source code: ConfirmationEngineWcf.cs, line 133, method ExecuteConfirmation Is there a rule called ConfirmationEngineWcf that I should be looking for? Chuck

Would like to modify the "UPPER" case descriptions in metadata to "Proper Case" in Cube Views. Any formatting options for this?