OneStream Platform Forums

Is it possible to create rules in Visual Studio?

I was running into issues clearing durable data prior to Clearing it so I calculated the data prior to the Clear statement so the data was "calculated", then ran the ClearCalculatedData stmt.  It works fine for me, but I have admin access and it works fine for a select few users.  But for the majority of users they receive the error "Error processing script: 'A#All = 0 * A#All".  I can not easily test in Prod as my hands are tied as far as making security changes.  In prod I have other users with the same set of security groups (just pointing to other entity WFs) and they do not receive the error.  In our Dev environment I can set up a native user with the exact same security groups as a prod user that fails and I do not receive an error.  As for it being an issue with data, I have an entity where 1 user can run it and another can not.  And they have the same set of security groups. Does anyone have any thoughts on what is going on?I also th

So we have a UD2 mapping set up in the List section. What I want is to be able to set up a Complex Expression in the UD2 Composite section so that for certain accounts it does nothing and so moves on to the List section, but for everything else we have a hard coded UD2 (e.g. None). I have no problem with setting the criteria in the Complex Expression, but I don't know if it is even possible to write some code that forces it to skip on out and look at the List mappings? I realise this is maybe a bit back to front compared to how the Composite mappings work, but we have a very tight list of accounts where we need to do the List UD2 mapping,  and everything else (which can be any other account) should just go to None.

  •You can set a text color on the Cubeview (i.e black) so all values show in a single colour, which would override the default grey/black. •You can also use a UD8 dynamic rule to hide derived values in future periods, if necessary.

Hi everyone,  Is there a possibility restrict the user only view the comment in specific CV and specific column cell.

I have a cube view with a parameter on UD5 |!param5!| that I would like to put in a tabbed dashboard that has one tab for specific members in UD5. I though the way to do this would be to use the literal parameter values in the Dashboard Properties. I have tried entering the following:param5=member1and done this for 4 dashboards. The problem is, ALL the dashboards have the value of member4 since this was the last dashboard in the list to be rendered. If I swapped the order (1,2,4,3) then all dashboards have member3 as the filter. I have tried setting the parameter up as a literal and input parameter and it behaves the same way.Is there something wrong with the syntax? TIA,James  

Hi, I am trying to create a OneStream Book that contains data in Excel format instead of PDF from a dashboard component. Currently, the book uses a dashboard report component to generate a .xfDoc.pdfBook containing the data, which Parcel Service then attaches to a list of emails and dispatches in a zipped folder. I attempted to create a book that retrieves the data from the same dashboard component but in .xfDoc.xlBook format. However, every time I run the Parcel Service to dispatch the file in Excel format, the Excel file is blank. Could you please advise if there is a way to obtain the same data in the Excel attachment as we have in the PDF attachment? Thank you

Is there a maximum number of source id values that can be loaded to one workflow? Is there a maximum number of source id values that can be loaded for an entire application?

Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables.I was unable to find any OneStream specific documentation on this PropertyId code and its meaning, so I created a business rule to complete the puzzle and get what we needed for the metadata audit at a very granular level.  For any one else experiencing an issue similar like this here is a table of the Member property Id's and their meaning.Dimension | PropertyID | PropertyDescription Entity PropertyID | 100 | Currency Scenario PropertyID | 100 | ScenarioType Account PropertyID | 100 | AccountType Entity PropertyID | 150 | IsConsolidated Entity PropertyID | 200 | IsIC Scenario PropertyID | 200 | InputFrequency Account PropertyID | 200 | FormulaType Flow PropertyID | 200 | FormulaType UDx PropertyID | 200 | FormulaType Scenario PropertyID | 300 | DefaultView Account PropertyID | 300 | AllowInput Flo

Hi allWe have come across an issue where the default load Method for workflow does not change from "replace" to "replace  all time". Anyone has experienced the same issue?Thank you for your feedbackNouria

Hello everyone! Quick question. Does anybody know how to change the Load Method for a ProcessDataTable through the connector code? We have a dashboard where the user wants to choose the Load Method with a radio button. We are able to pass that parameter to the code and change the api.LoadMethod property to Append but the load still executes as Replace.The above works if we change the load method directly in the WF, but not from the code

Hi, A dynamically calculated KPI returns "Nothing" for future months in the Actuals and therefore I expected the line in the advanced chart to stop at the current month. However, it's not doing that, instead it is dropping to zero, creating a rather undesirable effect. I can't imagine that this is the default behavior of OneStream. Am I doing something wrong? Did I overlook a setting or is there another way to prevent the drop to zero for non-existing data?

Hi,Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views?  We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view.  There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks

Hi all, How to download the table contents from the System --> database --> Tables or Views, when I tried to download, it is allowing to download the 50 rows only - I'm not sure where is a restriction like this and how would I avoid these issues? Thanks  

Am i just missing something or is there not a simple way to produce a total row in a cube view? I have one row that pulls a list of accounts based on a combo box selection. When I try to use GetDataCell(CVR(Row1) it only brings me the total for the first line in that 'row'. I feel like there should be an out of the box option to grab the total of row 1 that may have multiple accounts. 

I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places.  I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!

Dear Community Members,Found several great posts about creating account members from a rule.  I am trying to clone a scenario member (Forecast with Range defined). I have to admit that i am running into a knowledge gap when it comes to how to create some of the properties.I am reading the properties of my source scenario and naively thought i can just use SetStoredValue with the property of the source scenario.  Got stuck at InputFrequency.Any pointers to documentation, Golfstream, Community posts, or samples would be greatly appreciated.

Dear Community, How can we override the GetDataCell method in rows? In columns, I have a Ud8 member with V#Annotation(which pulls text1 property from Entity). In the screenshot below, the rows displaying "ROW" and "OTHER" are not using the GetDataCell method in rows. However, the rows with " - " are using GetDataCell in the row member filter. I attempted to override the method, but Getdatacell is not being overridden. How can I display text in those rows?I need to display the text1 property in those columns.  

Does anyone know how to remove the highlighted crosshair label?  When adding crosshairs to advanced charts, the legend pops up, however, an additional field pops up that is not formatted accordingly. 

Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here?   Regards,ND

Hi,  at the moment we are migrating OS from v6 to v8. The logon procedure in V6 and V8 is SSO, while login in V6 on there is a small pop-up window to choose an account for OS. This pop-up automatically closes after the choice. In V8 the button External provider sign in is not there, instead via logon it opens a full window that does not close automatically.  is there are solution to get this full web-page closed in v8?   thanks,

We have Workflow A, and Workflow B.   We get an error when the loadCube step in workflow B, when Workflow A is in Validation step.  The error we get is "Cannot execute step because the prior workflow step is not completed. . (WP#WorkflowA.Import:S#Actual:T#2022M1)"   The name the actual workflow has been changed to protect the innocent. Our question is:  what is causing this issue and how do we fix it?  It's not clear in the documentation what exactly triggers this error message.  The parameters passed back imply that one cannot load to the same scenario and time if another workflow to that scenario and time is still open.   WorkflowA and WorkflowB are loading to the same scenario and time, but to different accounts. 

Hi everyone,  I have a Budget Workflow profile with two import steps. Both steps are set up on different data source and different transformation rules. When Importing and Validating data, it works fine. However, when I get to the Load step, if I load one step, it works. But as soon as I try to load the other step, I get the error message: Error processing data. The Entity dimension member '' is invalid. I have checked the data and transformation rule and everything is fine. The issue is not with one particular step because I tried loading the second step first and vice-versa and the error message also shows. Any idea what it could be? Thank you!

Is there an easy way to bulk delete members in OneStream?

I am trying to move a Narrative Report book from one environment to another and am struggling to do so without having to re-build it. Is there anyone on this Community that has managed to do so successfully? Would truly appreciate the steps you followed to get this done successfully.