OneStream Platform Forums

Hi All,I wish to change the property 'Show Manipulation button' of my SQL table editor to hide manipulation buttons if the workflow selected is a parent but show if the workflow selected is a base. Is this possible?Regards,Mark

Hi OS Community,We have custom business rule to manage Data cell access security (Slice security). We have created new row category(DHRStat_Fcst)select group and it should have Read access only to PLP register but issue is it also have write access to add or make changes to register (screenshot below highlight in yellow) which we are trying to retrict through BR. Custom BR code: Line 253-259 is it is for data cell read access for PLP registerLine 263- 264 is the code for write access for PLP register and we try to restrict by category, but it is still not working. If Not itemAccess.Category = "DHRStat_Fcst" AndAlso itemAccess.MemberFilters.Scenario.IndexOf(wfscenarioname) > -1 AndAlso brapi.Security.Authorization.IsUserInGroup(si, groupID) ThendashSet = "3b2b1w_RegisterMaint_PLP"End If Data access:I need help with the BR code change to restrict the write access to the particular Data cell category .Let me know if you need any more details.Appreciate your help!!

Hi All - I am trying to create a View using a Extender BR and It is compainling without any issue but when I try to execute it am getting the below error. Any help would be appreciated.   Dim vSQL As New Text.StringBuilder() vSQL.AppendLine("CREATE View dbo.v_stageData AS SELECT WFP.ProfileName As WorkFLowProfileName, S.Sn AS SrcScenario, T.SnT AS TgtScenario, S.Tm AS SrcTime, T.TmT AS TgtTime, S.Et AS SrcEntity, T.EtT AS TgtEntity, S.Ac AS SrcAccount, T.AcT AS TgtAccount, S.Fw AS SrcFlow, T.FwT AS TgtFlow, S.Og AS SrcOrgin, T.OgT AS TgtOrgin, S.Cn AS SrcConsol, T.CnT AS TgtConsol, S.Ic AS SrcICP, T.IcT AS TgtICP, S.U1 AS SrcU1, T.U1T AS TgtU1, S.U2 AS SrcU2, T.U2T AS TgtU2, S.U3 AS SrcU3, T.U3T AS TgtU3, CAST(S.Am AS DECIMAL(18,2)) AS Amount FROM StageSourceData S INNER JOIN StageTargetData T ON S.Wfk=T.Wfk AND S.WtK = T.WtK AND S.Ri = T.Ri INNER JOIN WorkflowProfileHierarchy WFP ON WFP.ProfileKey = S.Wfk WHERE T.SnT = 'Actual' AND T.TmT = '2023M1' AND WFP.ProfileN

I have UD8 DynamicCalc members that calculate various Growth %s.  These work as expected when the Account dimension member referenced in the formula has a normal Account Type (e.g., Revenue or Expense).  It doesn't work when the Account Dimension member's Account Type is a DynamicCalc.Any tips on how to solve for this?  We can workaround this with some math in Cube Views, but would love to have a workaround for XFGetCell and Quick Views.

We have made the latest upgrade to 7.2.1. When I use the Excel Add and use the keep and delete buttons it suppresses all data in that field opposed to only keeping or removing the items that I selected. Anyone else have this issue. The other members of the team don't have this issue and we have the same settings in place.

Hello, I've deleted several on prem databases from both SSMS and the Database Configuration Utility, however, when I access System > Tools > Environment the deleted databases are still listed under OneStream Database Server with a message "((Database Not Found #))".  There doesn't appear to be a way to remove these via the front end. Is there any other way to remove these?

Hi, I am currently working on creating a ParamHelper business rule to be used in a CubeView. The goal is to have the S#scenario driven by the time dimension parameter selected by the user, rather than by the workflow time. For example, if T# contains M1, the scenario that should be returned is S#Projection. I would appreciate any pointers or guidance. Thanks in advance for your help!

All Scenarios belonging to the same Scenario Type must have the same Formula assigned Question Credit: Janice Kirkbride Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi AllI am trying to build BR (Finance or Extender (General Server), activated by Dashboard button) to calculate Journal (based on two different Cubes) and post to Dt or Ct ('if' statement to define where exactly)?I thought it would be possible with 'api.Data.Calculate' by just having simple equation TargetCube = 1stCube - 2ndCube; but cannot get to the place where I could define whether it should be posted as DebitAmount or  CreditAmount.Thanks!

Doing a simple XFD load and getting a strange message "Cannot load data to 'UD6' member 'member name' because it is not assigned to workflow channel 'Standard' or because the UD member is invalid for the specified cube.1. I have checked the Import_Standard node and can't see a setting that ties to UD6 members. 2. I checked the cube and can see that the parent dimension is allowed for the cube. Any help is appreciated,  Scott 

Is there an easy way, to copy data from one cube to another (with different dimensionality)

I need to capture username, date, time, and status, for two processes via Event Handlerload data to cube using workflow profile koolwfforce consolidate ActualsCould someone please point me to sample code or literature? I have been able to gather that I may need to use the transformationEventHandler but can't really reference the data types needed to pull the information listed above. Any guidance is greatly appreciated.  

Hi,I have two sets of derivative source rules (see below). What I am looking for is to exclude the Accounts starting with 9203 from the second set of derivative source rules. Each derivative source rule loops through all source data rows, so it is not like in the mask rules, where placing the 9203* expression before the 92* expression would automatically exclude the first from the second set. What's the syntax to exclude something from a rule expression (in derivative rules)? Thank you

Hello communityI have quite a stupid question. We have two functiont types for Member Lists, MemberListHeaders, MemberList.I couldn't figure out what the purpose of MemberListHeaders is. If I define a list in "MemberList" without having it in "MemberListHeaders", everything works fine. And if I add a list to "MemberListHeaders", it's not popping up anywhere in the application, as far as I saw.I was expecting something like in HFM: the Headers was used to display the list in a dropdown from which the user was able to select it, while the "List" was the place where the list was defined.I'm sure there's a use for MemberListHeaders, but I haven't gotten yet.Marco

Hi, I am getting many metadata errors when loading a version 6.8 extract in a version 7.4 application. Are there differences in the xml structure between versions? Thanks

HelloWe have a set of cost recovery related accounts where the recoveries are calculated and captured centrally for budgeting purposes, but the actual recoveries are invoiced to the different entities and need to be captured at local source.I'm trying to find a way to restrict write access to the recovery accounts in our budgeting and forecasting scenarios but allow write access to everyone for the actual scenario. Does anyone have any easy solutions on how to accomplish this?Thanks

Hello, is there someone who knows how to get more information on this error?The next 2 messages refer to a scenario member, for which I run the calculation, but I don't see any "=" that has a wrong statement behind it, could of course be a small typo, but it's a large scenario formula. thanks in advanceBen

I have a Matrix data file with 36 Months of data. The header has the periods in MM/DD/YYYY format. Is it possible to convert this Format to OS Period format like 2023M1 and return in each of the 36-time source dimension in Data Source Setup?  

I have a data adapter with a query that lists all workflow profiles in the application. I need to exclude from that list all the inactive profiles (Profile Active=False)Where is this property in the database table?

Hi all, I'm trying to figure out if there is a dashboard, marketplace solution, or custom report where I can view security groups/users and references where they are assigned to objects. Preferably with the ability to sort.For example:Security Group Name:"Security Group" Object:Application -> Workflow -> Workflow Profiles -> "Cube" -> "WorkflowProfile" -> Profile Properties -> Security -> Access GroupApplication -> Tools -> Business Rules -> Connector -> "Business Rule" -> Properties -> Security -> Maintenance Group   Thank you!

Hi,sorry, first time trying to use derivative transformation rules..I have setup the following Derivative source transformation rule:My understanding or derivative rule is that the account created by the rule (eg. New_CR and New_DR above) must then be mapped using the standard transformation rule, so I have done so: However, I get the following error when running a Load and transform of the data file:What am I doing wrong? Thank you

Hi Team,Under UD4 I have an XFBR string, which returns Jurisdiction - the case is I can't include there hierarchy.Base, as it needs a single entity to work. Is there any parameter like |CurrentEntity| which I can include in XFBR or do you have any idea how to solve it? 

Hi Team,Maybe anybody knows where in the Database can I find table with Workflow statuses?I believe there should be such from default,Thanks! 

Hello,I'm trying to create a transformation rule for a specific entity that if it's a specific account (6189) it would go into a specific UD3. I'm not sure how to do this because there's 2 specific criteria needed, instead of being a 1:1. I'm new to OS, so all the tips and tricks help!Thanks,Will

I have used the FormsStausForWorkflowUnit method to check method of all forms. Unfortunately I'm not able to limit the amount of columns, is that possible? When I select 'Column Settings' it works only till the next refresh.Thanks a lot!