Recent Discussions
Get dependent entities on a review level workflow
Hi All, We have a parameter attached in the entity POV of all our cube views, and it works perfectly on base level. However, not in the review level workflow. Is there a way to include dependent entities in a review-level workflow via XFBR String? The entities in the review level are dependent, coming from the assigned entities in base level workflows underneath it. I have tried using objList = BRApi.Workflow.Metadata.GetDependentProfileEntities(si, profileKey) with no luck. Perhaps I am missing something. Bound list has been tested as well, and attaching the parameter in the POV of a cube view, only works in the base level workflows as well. When the workflow is a review, it will show a full list of entities that we do not want. Is there a way through the XFBR string and parameter in the member dialog? Appreciate all suggestions.cons13 days agoNew Contributor III6Views0likes0CommentsThe supplied Workflow Time is more than 3 periods after the last import period
We are currently in the process of upgrading to OFC PV840-SV112 and just applied the upgrade to our Customer Acceptance Testing Application where we have our imports and matching running daily. However, the amount of data imported is much less in this applicationas it is using a test database to import the data from and one of the matchsets has not imported any data for many months. The matching step for that matchset erred out a couple of days after the upgrade with the message "The supplied Workflow Time is more than 3 periods after the last import period". We discovered that if we loaded just one "dummy" row for the matchset that the error stopped happening. My questions are - has anyone else noticed this? And, if so, is there a setting somewhere to either turn this check on or off or increase the number of months that it looks back? Thanks for any information you can provide.Ruth_Sillman4 days agoNew Contributor12Views0likes0CommentsHow to validate metadata in Journal on submit / post
I would like to build a business rule that will execute when user attempts to submit or quick-post a journal. The rule will check that correct Flow dimension member had been used and display the message to the user if that is not the case. If anyone has something similar in use, can you please share. Any advise will be greatly appreciated. Thank you! YanYanSavinsky4 days agoNew Contributor III30Views0likes0CommentsTransformation Rules - Possible Bug
I have an issue, since we migrated to V9, OS is adding on its own a space after transforming a member and this prevent us from loading the data to the member. (This is in the validation step when it fails) Data source has been checked, adjusted, and tested in many ways. The extra space doesn't come from here. Transformation rules have also been tested in many ways, and the space is also not here, we event tried one-to-one, masks, all ,and this is not the issue The error is only happening with 2 UD3 members US4 & CA4 both ending in 4, I created a fake one for testing "US41" and this one works fine. I have been checking with OS support, but they just want to repeat over and over the same testing we already did with them on a call To me, after checking all that I could, seems like a bug in the new V9.1, but if anyone has any ideas please let me know.Luigi_Caroli5 days agoNew Contributor II17Views0likes0CommentsMatrix data load with entities in columns
Is there a way to set up a single matrix data source for a file with accounts in rows and entities in columns where the entities could change, as well as the number of entities? Can you set up matrix for max number of entities and read entity from specific row?DEReam236 days agoNew Contributor17Views0likes1CommentIdentifying API Parameters for OneStream Audit Log Export via Postman
Hello all, I joined a company where they have implemented OneStream solution. I have access to the platform, and still exploring the way it was implemented. I am currently working on integrating OneStream with an external platform and need to export audit logs using the product's API. While setting up the request in Postman, i've encountered difficulty identifying the correct values for the following parameters: ApplicationName AdapterName Despite reviewing the available documentation, these tags remain unclear. Has anyone successfully queried audit logs via the OneStream API and can share insights on where these parameters are defined or how to retrieve them? Any guidance or examples would be greatly appreciated. Thank you in advance!46Views0likes3CommentsCube views and Parameters
Hi All, I encounter this issue while opening a cube view from a form template in the Workflow. The same cube view opens without any issues directly but if you try opening the same via the workflow, it gives this error "Cube Views used for Forms cannot use parameters when referencing other cube views for Shared rows or columns. Unable to resolve substitution variable <paramtere_name>" .Some detail worth mentioning here is that we are using paramters for formatting and in one of those formatting parameters we are using another parameter. Has anyone encountered something like this and how did you overcome it. Thanks for your help 🙂 KR Arpitarpitm10 days agoNew Contributor III1.5KViews0likes7CommentsConnector rule - Drill back on dimension using a business rule logical operator
Hi, in a connector business rule, when a dimension has a business rule logical operator, is there a better way to build the SQL drill back query than reverse engineer what the business rule is doing? In the example below the business rule brings "Zero" to the stage when the source UD1 is null. The code in the drill back is reversing that to get the right source data: 'UD1 If sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString.XFEqualsIgnoreCase("Zero") Then whereClause.Append("And (Department IS NULL Or Department = '') ") Else whereClause.Append("And (Department = '" & SqlStringHelper.EscapeSqlString(sourceValues.Item(StageTableFields.StageSourceData.DimUD1).ToString) & "') ") End If However, this is a simple business rule. I am wondering if there is a way of getting the source data before it is passed through the logical operator business rule, to reduce code complexity in the drill back. Thank youSolvedAndreaF10 days agoContributor III1.6KViews0likes3CommentsPass parameters through Rest API
Hi All, This is probably an easy one, but I am stuck. I have a Dashboard dataset rule that used FDX to run a query. It takes two input values. I have a data adapter that calls that BR and I can hardcode parameters in there to pass to the BR. Now I am trying to call that Data Adapter using the REST API. I am trying to pass parameters using CustomSubstVarsAsCommaSeparatedPairs. How should I have the Data Adapter set up to accept these parameters. For reference the hardcoded query looks like this: {_GetData}{GetDataSet}{ScenarioName=Actual, TimeName = 2024M3} What do I need to change "Actual" and "2024M3" to in order for it to use the values from the REST API call? Thanks, ScottSolved20Views0likes1Comment