OneStream Platform Forums

Hi everyone,   I'm having issues when launching the consolidation process after loading data on the cube. Below you can see the calculation that is triggered when the consolidation process is launched:   api.Data.ClearCalculatedData(True, False, False,"A#2A900A01","F#CHI","I#None") api.Data.Calculate("A#2A900A01:U1#None:U3#None:U5#None:I#None:F#CHI=A#3ABCDEF0:U1#TotProduct:U3#TotMarket:U5#TotCostCenter:I#Top:F#None") The 3ABCDEF0 account is the top node of the PL account hierarchy, and the intersection is correctly populated. The 2A900A01 is the balance sheet account that should be populated as a result of the consolidation process, nevertheless it doesn't get populated. I have already verified the intersections, and they are correct. Does anyone have any suggestion on why the 2A900A01 account does not get populated? I know the question is a bit vague but I'm really struggling to understand what the issue might be Thanks in advance for any help!

Hi, All I have a column in a cube view for which I need to get the time description prefaced by "YTD". This was no problem for the current period as I could use a variable "wfTimeDesc" as follows: T#WF:Name(YTD |wfTimeDesc|) However, when trying it for a prior period, I couldn't find a variable to use that gave me a description.  This is close, as it returns "YTD M9 2023" but what I really need is "YTD Sep 2023": T#PeriodPrior12(|WFTime|):Name(YTD |WFSubPeriod| |WFYearPrior|) I know I could add a header row and put it underneath, but this was the request, if I can do it. Thanks in advance!    

I am getting error "Unable to access database table 'ABC'. Database table 'ABC' does not exist". If we create a table with extensibility. Does it solve the problem?

I am trying to post an adjustment to OwnerPostAdj member using FinanceFunctionType.Calcture function, is it possible to do that. If so could you please share some reference or if there are any cube level setting that I need to make. Currently I am getting the following error, even if I specify the OwnerPostAdj as a part of my data unit, but same works fine for Local member: 

We see some ghosted elimination amount stuck at parent level and they keep getting carried forward to the rest of periods. The elim amounts are greyed out, but still get aggregated up along the entity rollup. Is there a way to stop the ghosted elim amount?  We copied the actual data from Actual scenario to Fcst Scenario.  Actual scenario is fine, but Fcst scenario has this ghosted elim amount issue.  Is there any setting which triggered this?

Hi, I am creating a report for our auditors that takes the IC accounts and their elimination "Plug" account throughout the Origin dimension. I don't want to create a bunch of separate reports for AP/AR, Sales/COGS, IC Expense, etc. My thought is to define these in a Parameter and then build a book. Can anyone point me to a good starting point on how to define these 4 different drop down options? For example, the AP/AR one would include A#19999, A#29999, and A#IC_DIFF, and the report user would select AP_AR_DIFF or something like that. Any insight is appreciated - the forum has been very helpful! Thank you!

hi Team, good day; it is possible to block the file upload in the Data Attachemnt cell? theusers need to type an explanation, not just upload a file. Please let me know if it is possible. thanks in advance. Regards Mario G

Hello All, Anyone knows how we can achieve Consolidation- NCI, Equity pick up, GW calculation in OneStream?

Just wondering if anyone out there has figured out a way to report the attributes/properties of a Workflow profile.  What I'm actually trying to do as part of a security overhaul is determine WHERE a particular security group is actually being used.I am using the XFGetMemberProperty() function to pull security for all of my dimension members but I need a solution to pull the security groups used in each of our FPA workflows.There is no built in security dashboard report to provide this and the best advice I've received so far is to download the application and search for the security groups there.  That's one way, but we literally have dozens of security groups set up so it'll be a long and manual effort.Would love to hear from anyone who's found a better way to do this.  Thanks

Please can someone explain to me : 1. What is the best practices to set up the Parent Sort Order for entities in a legal (default hierarchy) and an alternative rollup.  2. How is it used (Best practices)  3. What is the impact if it is changed  I cannot find significant information around it.  

Is there a way to retrieve the Text field value in QuickView along with the $ values on the trended time report. The Country values are available in Text1 of the Entity Dimensions also have created a UD8 member formula to retrieve the values. But unable to retrieve both Country and $ values in one single Quick view.   Below is the format of the QuickView report. Where Country details can be retrieved from the U8#ENT_COUNTRY:V#Annotation:Name(Country). Any Idea?

Hi We are evaluating the SIC tool for integration and noticed that API keys and DB passwords are stored unencrypted in plain text files. This is becoming a huge security concern as this way of storing credentials is going to case sensitive data leaks. Not sure if this is already identified by any other client and if it is in the roadmap of fixes? Did any of the clients report this issue?ThanksVidya KadiyalaCN Rail

What level of data do most of the companies import from their ERPs to OS, e.g. balances or transactions?  

Trying to use IC Member Filter on the account dimension to limit the entities that can be used at IC partners for the account.  Does anyone know the syntax needed; I don't see any documentation on it.  I tried a list of just one entity member name and that didn't work. 

Hi All, I was hoping to brainstorm a solution to a problem. Our auditors have requested a mapping of base-level data to the aggregated, financial statement line item data that appears in our financial statements. This is fairly easily done for the Balance Sheet, which only depends on the Account and Entity members to generate, but for the income statement we simply have too many data intersections (Account, Entity, Cost Center, Line of Business - generates about 15,000 rows of data) for a cube view to be able to process the request, even with suppression enabled. Currently, to work around the problem I've set up a book that loops through each entity (approx. 200) and exports an excel with each entity's income statement as a separate tab. I then have an excel macro that copies each tab into a single aggregated file that we can then send to the auditors. However, I was wondering if anyone has figured out a way to have OneStream do the work of aggregating all the tabs together so we don't

The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate only up to the members directly below the top parent. Nothing else has changed, except the data source. This was working as of a couple of days ago and suddenly stopped. I can see it running calcs fine, but the numbers in regular accounts do not roll up. Any thoughts? I've checked all the properties I could think of and turned off all calculations, but nothing helps.

I have a form template profile containing 2 form template groups. Each template group has a selection of CubeViews.Template Group A has Access group = Everyone. Template Group B has Access group = SuperUser. The template profile has access security = Everyone (although it doesn't seem to matter what is in here). All forms are visible and all forms can be completed as long as the CubeView group access group is low enough.The form template profile is attached to a workflow form profile. The workflow form profile access group = everyone.I had hoped that the list of forms would be restricted for everyone, with only SuperUsers seeing and executing a slightly longer list of forms (ie Form template group B).I hope I have made sense. The only way I seem to be able to restrict access is by applying CubeView Access security. It looks like all Form security settings are being ignored or overridden by some other security. Can anyone throw any light on this, please?

Hello, I'm trying to get all the stored items of Entity relationship properties, but w/o success. Any idea what I'm doing wrong? Dim oVMProperties As New VaryingMemberProperties(DimType.Entity.Id, iChild, iParent) Dim oVMPropertiesStoredItemsList As List(Of VaryingMemberPropertyItem) = oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.GetStoredPropertyItems() I'm expecting the list (row #2) for some use cases (relationships) should return > 0, and it seems to be always 0: {sChild} under {sParent}: {oVMPropertiesStoredItemsList.Count} | {oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.GetNumStoredPropertyItems()} | {oVMProperties.GetEntityRelationshipProperties().PercentConsolidation.HasStoredPropertyItems()} None under Root: 0 | 0 | False CONSOLID under Root: 0 | 0 | False INACTIVE under Root: 0 | 0 | False Global under Root: 0 | 0 | False TOTAL_LE under CONSOLID: 0 | 0 | False

Hi All,is there any way to clear the added comments in V#VarianceExplanation/V#Footnote using rule or any other method. I tried using rule but it's not working as expected. we are storing our comments at parent entity and mostly Top members in UD dimension , please let me know if any other information required.our intersection where we are storing the comments:E#ParentEntity:P#?:C#USD:S#ActualComment:T#2023M9:V#Footnote:A#acc:F#EndBal:O#Top:I#Top:U1#TotOPU:U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#Top:U8#Top

I am building parameter to pull user defined dimensions descriptions. Anyone knows where it stored in Database?  

Hello, What happens to the OneStream application when a database shrink is performed? Are there any risks associated with this? Thanks  

Hello All, Is there a functionality of Change of reporting period for entity (From Jan- Dec to Apr-Mar) in OS. For Example, if currently I am working for FY Jan to Dec but in future, I want my FY to be changed to April - Mar, so how can I achieve the changes without getting any impact in the historical data?

I'm struggling to understand how exactly to calculate what I need, a confirmation of direction and a little guidance would be great!  I need to calculate an account value (Factored account)  from a Driver account * a Percent account.  The Driver account data contains many different dimension attributes (product, region, customer, etc).  The percent account is at the 'None' member of those different dimensions.  The calculated Factor accounts need to be at the same level (members) as the Driver account.  I'm sure (i think, lol) I need to use the data.calculate, but I'm struggling on the syntax of the function to calculate using data at 2 different account POVs, and the results residing at the same level as the Driver account.  Whether I'll need to create data buffers and manipulate / save or simple filters within the data.calculate.  I do have multiple Drivers for some Factored account (i.e F1 = (D1*Pct) + (D2*Pct) + (D3*Pct)), and multiple Factor

Using the below rule it seems my derived Zeros are being copied as real data zeros as a result of my Forecast Seeding data calculate.  This is causing a problem with my "isrealdata" check in my override rules.  I can do a work around on my Actual data by copying the already calced amounts and then suppress the calc rules, but then if the users have forecasted override changes they won't work.  I guess my question is can you use a Data Calculate that will result in derived zeroes for the copied Actual periods? Case "FC_Sep" Select Case curMonth Case "M1","M2","M3","M4","M5","M6","M7","M8" api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = S#" & actScenario & ":V#Periodic", "A#Balance.Base",,,,,,,"U4#Top_Srce.Base.Remove(Calc)",) api.Data.Calculate("S#" & curScenario & ":O#Import:V#Periodic = S#" & actScenario & ":V#Periodic", "A#Nat_Net_Ctrl_Income.Base, A#S_Dozens, A#S_NCIpct",,,,,,,"U4#Top_Srce.Base.Remove(Cal

Hello, When working in Workflows > Budget scenario, I would like to add a new column in People Planning that would depict new annual salary after discretionary merit increase. Any idea's?