OneStream Platform Forums

I am stopping users from running forced calculate/translate/consolidate with the following in "WcfEventHandler".  If args.IsBeforeEvent AndAlso (args.WcfServiceType = WcfServiceType.Calculate) AndAlso (args.OperationName="CalculateChartLogic" OrElse args.OperationName= "StartConsolidation" OrElse args.OperationName= "StartProcessCube" OrElse args.OperationName= "Translate" ) Then Dim isForced As Boolean = args.inputs(2) If isForced = "True" Then args.Cancel = True Throw New XFException(si, New Exception("You do not have access to Force Calculate/Translate/Consolidate.")) End If End If How do I stop users from running these functions in a report in excel? 

Hi all, I am building some form templates for my workflow profiles, and have a query regarding the best way to setup the form template and entity parameter (setup below):   I would really like to be able to have users navigate between the forms, and the entity POV that they have selected in the parameter remain constant between forms. As it is now, when they move from a form, it always goes to the top entity in the list. I have some workflows with 20+ entities, and it may be that someone is working on the forms for just 1 entity at a point in time so has to re-select the entity each time. I've seen a "Sticky POV" idea raised on IdeaStream, but that hasn't moved since 2022.  I have seen mentioned at Splash that there's an option to have the user state pov remain through a business rule, but haven't seen anything other than a SetUserState? And I'm not really sure how to write the code and apply it here.  Any advice would be really helpful.  

I have stats account, user is input the numbers for September Time period at base level in Actual scenario for Periodic combination and the -ve number are showing in October TImeperiod. that -ve number is YTD of September. as user is requesting to clear that October Actuals -ve data. Is there way that we can delete and also, I am surprised how this -ve number flow into the Oct Time Period. The flow is EndBal_Input. users are entering the number from quickview. Any suggestions to solve this issue?

Im being given an account consisting of 4 numbers, a - and 4 more numbers like:5150-0707. Im using range TR to map to the OS accounts, so for example 5000~5050-0304 works fine, but if i put the ~ after the - like this: 5000-0001~0304 it doesnt work any more. is there any way to fix this and make it work?

I'm sure this question has been asked before in the forum, but I just couldn't find it in the community. We have this requirement where in the same Actual scenario, Corporate (a group of users) can only access the Actual data after  the actual data is finalized by different entities. Any point of time leading to Day X, the entity has the control to pull the switch on releasing the data access to Corporate. On Day X, all the data is made accessible to Corporate. I thought about slice security, but it doesn't seem to accommodate this requirement due to the static nature of the DU filter; neither does Conditional Input, which doesn't control the general data access. Can someone please shed some light here on this design whether it's possible to lock down a group of users by time period? 

Hi all, I'm trying to find a way to extract comments and text inputs using a data management job. OS doesn't let me select V#VarianceExplanation member in the dataunit section. Error processing Data Management Step 'ExportComments'. Non-numeric View member 'VarianceExplanation' cannot be used in data filter Any help is appreciated.

When loading data, all of our accounts from source match the names of the account in OneStream so we've always used a *:* rule for the account maps. However, we have a new dataset coming in and we need to flip the sign for those accounts that are of account type Revenue in OneStream: not assets or anything else, just revenue. I have working code that will conditionally do something if it's a revenue account else pass through... but I don't know what that something should be to flip the sign. Other people have posted questions about how to do a sign flip in a complex expression but there are no answers. I definitely do not want to maintain a manual list of 1,500 1:1 rules that do nothing but flip the sign. The complex expression feels like the only scalable solution but this detail is missing.

Does anyone know how to write a formula that calculates an average based on the POV's number of days? Thanks

I have a client that has a app with 7 years of data in it.  They would like when we get to the end of 2024 to chop off the last year in the app so that in only ever has 7 years of data in it and archive that data to another app.  Just curious on how people are doing this with chopping off a year and putting it into another app.  Thanks

Dear coleagues,  when I need to change transformation group within multiple transformation profiles I wanted to export XML file, do the change and then reupload it. Unfortunatelly it add new group but does not remove the old one. I guess the merge approach it to blame.  Do you know a way how to do this excersise in more sophisticated way than running a clicking derby? Thanks for help!

Hello OneStream CommunityDoes anyone know how to get the data source time to use the WF time instead of the start Time range scenario . The import data source is using the start time instead of the WF , POV time. Thank you

Hi All Is there a way to set default date to Now() in the Date Selector component of the Dashboard? Thanks,

is there any documentation available explaining the details of File Explorer? What each of these folders are, when these will be used, these are consuming large hardware space, how to purge files in these folders, what are the pros and cons of purging. I feel there is a lack of documentation in this area.  

Hello, I have created a Workspace with is Shareable Workspace set to True (workspace 1). From another workspace/ cubeview group/ cubeview I would like use the row from a cube view in workspace 1. I am not using parameters in the cubeviews (yet). If I run the main cubeview I get the error message What can cause this is? Do I need to reference in row sharing to a specific workspace? Regards, Arjen

Hi,I'm trying to set the number format in the Cube Views for negative numbers with gaps instead of a minus.The User culture is in Spanish because I need the decimals with the comma.I don't find how can I customize the format for that because N1 is not an option because the negative numbers appear with a minus.Thanks,

While not on the list of Reserved Words, I was wondering if Member should be avoided in Dimensions and Dimension Names? Could using it cause any unwanted downstream effects?

HI All, I have been asked to see if OneStream can take a feed in to update the metadata. We are looking at having a Master Data Management system which will be used to update all the downstream systems. SO new accounts, entities or dimension members get created in this MDM system and then ideally gets automatically updated into OneStream (either mapping tables or Metadata hierarchy updates). Has anyone tried to do this ? Thanks Tahir

Testing

I am looking to implement an incremental data extraction feature for our cube data. Specifically, I need to extract all data from inception and continue to do so on a quarterly basis, including any updates to previous quarters. Any ideas or best practices on how to achieve this effectively would be greatly appreciated.

Hi Team, Can any one help on this. I have text in the cells, so based on my text have to apply the conditional formatting. if my cell has "YES" text then should be Green color, if my cell has "NO" text then should be in RED color.  Can any one please help us to get the result.

Hello - I need to get the most recent Property change on our UD1's. I'm assuming I need to get the AuditTime from the AuditMemberProperty table.  Would I use this function? If so, how do I find the textPropertyIndex value?  BRApi.Finance.UD.Text(si, dimTypeId, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId)  Your help is much appreciated!  Thank you!  

Is there a way I can check my source records before importing data into a stage? If I am in a workflow for Import, Validate and Load, Even before the data is imported, I would like to check my source record for a condition like if it is less than a particular value. Only if the condition satisfies, I need to proceed to import else stop the workflow. If someone has done it, can you share the setup and code for the same. Appreciate your help!

I have a UD8 dynamic calculation that returns different results based on the UD2 member value. E.g. If UD2 = Houston, return "A#:Total_Expenses:S#Plan...." This works well using api.pov.UD2.Name for normal member intersections, but it's not applying correctly for GetDataCell calculations. By using the Cell POV button on the cube view, I can see that the GetDataCell rows have a POV set to the cube view POV. How can I have my Dynamic Calc read the UD2 value inside the GetDataCell?There is only one UD2 member referenced inside the GetDataCell. The GetDataCell format is as follows: GetDataCell(A#Total_Expenses:S#Actual:U2#Texas - A#Operating_Expenses:S#Actual:U2#Texas):name(Net Texas)

Good Day,In order to implement Org-by-period Consolidation, you need to set the Consolidation View to Periodic so that the correct Share for e.g. the income statement can be calculated for only the period for which an entity was consolidated to a parent.The guidance is clear that "When Consolidation View is set to Periodic and no data is loaded to the IC Accounts fora specific month, custom Elimination rules are required". I assume this is because of built in zero suppression settings on the Elimination data buffer.However, here is what is strange to me and I'm not sure if I'm missing something.When setting the Consolidation View to Periodic and note that No Data Zero View is set to YTD as data is loaded YTD, for any entity, there is a problem with eliminations as follows:When loading 100 000 in January, the full 100 000 is eliminated. If you load 100 000 again YTD in February, nothing gets eliminated. If you load e.g. 100 000.01 YTD in February, then the full amount gets eliminated ag

Hello All, I have a case where I need to show workflow assigned entities into dashboard using Data Adapter method query. For example: Base Input WF Entity assignment Workflow1 Site1, site2 Workflow2 Site3 Workflow3 Site4, Site5, Site6 So, whenever I am selecting workflow1, the entities assigned to this workflow should list and come as output. Kindly help to advise some options here. Thank you.