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!

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 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

Dear Community,Can we have common column header for multiple columns. For example, we have same entity name for different columns, and we want to merge and center those column headers for multiple columns. Below is the attached cube view and desired output image.Desired Output:Any solution to this will be very helpful and thankful.

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?

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.

Hello!  Hopefully an easy one, but not finding and answer already out here on this topic.  Using Spreadsheet in the OneStream application.  Building a quickview and wanting the column titles to use wrapped text.  Apply the formatting change, save it and it looks great.  Change the time parameter and the formatting is gone and need to highlight the column headers again and rewrap the text. How do I make the formatting 'stick'??

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?

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?

Need to burst out a file (ie multiple tabs) in excel to non-licensed users (ie preview of dept expenses for Fcst to managers).  I have done this with output being pdf (CV's and FXGets via Books), just not sure how to do with output being excel.  Right now I have it all working (bursting, passing parameters,...) and delivering an excel doc, just can't figure out how to convert the FXGet formula's to values.  File is getting delivered but still with the formula's.  This is when I am just using a direct link to the excel file on my App Doc's folder.  I have tried to insert the excel doc in a book but that just delivers an empty excel file.  Not sure what I am missing there.  Direct link to Excel allows the Supplied Parameters to be found and populated so I am thinking I am missing something on the Book setup. Anyway - Anybody been able to send excel FXGet report converted to static values via Parcel Service?  Can you let me know what I have missed.

Hi! We are exploring using Parcel Services for mass reporting. We would like the flexibility to create reports in Excel using XFGet formulas (as opposed to created Cube Views in the desktop) and then burst them into individual reports for different users. Is this possible, or has anyone come up with another solution for mass reporting with the excel add-in? Beth

Hi Experts,I have to eliminate Equity and write elimination portion to NCI account. as part of this firstly i am testing with one of the equity accounts i.e "Sharecapital". For this i have written a rule as below and when i execute no errors as well no results. i do not see any reversal entry in C#Elimination.O#Elimination of source buffer value.Kindly evaluate and help me if i am missing anything in the rule. even i do not see any record in the source buffer log. but there are records at C#Share for A#Sharecapital account. Rule >>>>Case Is = FinanceFunctionType.ConsolidateShareDim entity As String = api.pov.entity.NameDim entityID As String = api.pov.entity.MemberIDDim Pown As Decimal = api.entity.percentOwnership(entityID)Dim Pcon As Decimal = api.entity.PercentConsolidation(entityID)Dim pmin As Decimal = Pcon-PownDim vMethod As OwnershipType = api.Entity.OwnershipType(entityID)If Pown > 50.0 And Pown < 100.0 AndAlso vMethod.ToString = "FullConsolidation"

hi all, I wanted to retrieve a workflow status and form status.  I am able to do this using the data adapter method query for the same. I also wanted to assign a user responsible for each workflow and retrieve that info . I was thinking of doing this using one of the workflow text properties. How will i be able to retrieve that info into my status report? has anyone done something similar?  

Hi, Does maybe anyone know how can I get a status of a single process in workflow from BR? I was trying to use method GetInputWorkflowStatusForMembers, however I can't select any specific process there: Dim wfInfo As WorkflowInfo = BRApi.Workflow.Status.GetInputWorkflowStatusForMembers(si, cubeId, entityId, scenarioId, timeId) I need this check in Extensibility Rule as it will be ran using DMJ. Many thanks!

Is it possible to change the color or format the header of a column of a SQL table editor component??  

Hi All, As you can see, Oct,Nov,Dec are preceding after Jan 2021. This is being repeated at many several points.  I'm wondering if anyone had a similar issue.    I'm using a CV MD data adapter. Here is my CV period headers