Rules

I'm looking for an option to mass delete members marked as ORPHANS in a dimension, I tried few options but if there is any data in the application for any of these ORPHAN members the delete fails Wanted to know if there is a work around or another way to achieve this & also to know if we can delete member without clearing the data

For Entity transformation rule, we want to build logic so that Source entity looks at its parent entity in one of our entity hierarchy in OS dimension, read and then map to the parent entity text8 assignment, then map to that entity the text8 assignment. How can we setup logic for that? 

I can drill from a Confirmation rule. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi there, I wonder if anybody knows how to access dashboard combo box selection from SaveDataEventHandler? I was able - through BRApi - to get the parameter assigned to the combo box (with the entire member list in it), but not the actual selection. I think this is possible from Dashboard Extender BR, but not Extensibility. I would appreciate any tips & advises. Best,Karol

Looking to start using the View txt fields (Annotation, Assumptions…) and understand that there is no natural way to have that information aggregated/consolidated up. I am told that a BR is needed to do this. Just checking to see if this is correct and if anybody has had success in this getting it to work. Ideal use would be for our regional leaders to be able to see summary comments on specific line items that we report on.

Hi I'm trying to get the current pov - cube and entity - within a member list (i'm using for selection as drop-down). Unfortunately the api.pov.entity.name is in this case not returning the wf pov, but the cube pov. The args.SubstVarSourceInfo.WFCubeRoot doesn't work as well. Any ideas? Thanks Jana

Hi, I have a process that would be run at the month end to lock the workflow. Once the workflow is locked, you need to refresh the application to see the lock icon on the period in the workflow. The icon doesn't change until you hit the refresh button. Is there a utility in the business rule to refresh the application (I would need to include this utility in the business rule) ? Ragav.

Hi everyone, I am trying to add records to a table via an Excel Table View. Using the example in the Table Views documentation, I am able to update existing records; however, any new records added are cleared once I submit the sheet. Is there additional code I can add to allow the Table View to write new records to the table? Thanks! Molly

Hi, I have a u8#memberformula that I am trying to use for the first time - to format the background color of a cell. I know that setting  BackgroundColor = pink will cause the cell to turn pink. BackgroundColor = u8#memberfomula my u8#memberformula has only one line: Return "pink"  For unknown reason, 1S is not formating my cells pink ??(I assume the text "pink" is returned by u8#formula) I know my formula is executed by 1S because I put a debug statement in there and it is showing in Error Log that my formula is executed .  

I am trying to clear entered data from the particular Cube but unable to do so using "Clear Data" Rule. Can anyone suggest me the process to clear data from any cube without disturbing other cubes' dataset.

I can use substitution variables across multiple OneStream applications on the same server. Question Credit: Gabriela Columna   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi All, I'm hoping someone can help. I'm trying to create a formula for a planning solution that calculates an average over a dynamic number of time periods but for hundreds of intersections. So essentially I somehow need a data buffer covering multiple time periods that I can then use in my over arching planning formula. The main thought was to loop through the time periods, which is fine, but I can't use an api.data.getdatacell because of the volume of intersections I want to calculate the average for. Is it possible to build up a data buffer in a loop? If only i could create a V#TrailingXmonthavg  formula where I can replace the X with a dynamic value. Any thoughts would be greatly appreciated. Many thanks in advance.

How do I view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?I think I can run this statement:Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & viewMember.tostring) Is there a faster way to view all 10 dimesions in POV of the datacell ? These do not work: Dim POV As POV = ViewMember.GetItem(api.Pov.MemberPk.MemberId) BRapi.ErrorLog.LogMessage(si, "view = "  & POV.tostring)    

Happy Labor Day!!How can I use BusinessRule.DashboardStringFunction, i.e. XFBR string business rules to extract text out of a datacell in cubeview that has users' text stored in V#Annotations?We have successfully used XFBR string business rules to extract amounts from datacell in cubeview. However, when I tried similar lines of XFBR code in my cubeview – I am not able to pull users’ text.It is returning zero. Users are putting text into CV cell that has this combination - A#Explaination:U8#Comment:V#Annotations . Here are a few lines the don’t seem to work1)Dim Explain As DataCell Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cube,"A#Explaination:U8#Comment:V#Annotations" ).DataCellEx.DataCell2) I tried the next line:Explain = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"A#Explaination:U8#Comment:V#Annotations" ).DataCellAnnotationbut I get the error message : " Does not recognize .DataCellAnnotation. 1) Error at line 71: 'DataCellAnnotation' is not a member of '

Is there any way to edit Transformation Rules in Bulk?When I try loading a trx file or xml code into the system it doesn't overwrite the rules which causes issues in someplace.Is there a way or a template where with direct upload I can delete that transformation group and create a new one with the same name. (Example- Dimension delete template where uploading a certain xml file directly deletes some dimension members)Thanks.

Can we use an aggregated UD1 with a dynamic calc member in the Flow dimension across two cubes?  We have dynamically calculated members called ‘AggDetail’ in Flow Dimension with a rule on member formulas which aggregate base UD1 by entity dynamically.  All our base cost centers (UD1) are in the Financial Detail cube in the dimension library and this ‘FinancialDetail’ cube is called out in the dynamic calc rule. However, we have recently added a new sub parent in flow dimension under the “Financial” cube and it seems like this dynamically calculated flow member “AggDetail” is not aggregating the result for this new sub parent from the Financial cube. This is kind of close critical and see if anyone knows how to solve this in OneStream. If you know the solution, please reply to me here as quickly as possible. Thank you

Was the OneStream product itself built using VB.Net? If so, I'm pretty impressed!! If it was built using C#, I'm wondering why customers are then forced to use VB.Net for business rules?  It seems like a double standard.  Is there a licensing reason why VB.Net is redistributed to customers while C# is not?  If it isn't about licensing then maybe onestream has internal BR tooling that is incompatible with C#, or third party tooling that is incompatible?  Any info would be appreciated.  Obviously the selection of either .net language it is a matter of choice ... but if OneStream picked C# for development of the product, then they should allow customers to pick C# as well for our business rules.      

It is important to gather reporting requirements after the initial build stage of the project. Question Credit: Becca Speese   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

I am trying to push some data from a sql table back to the cube. I tried to use SetDataCellsUsingUsingCsvFile and SetDataCellsUsingMemberScript. Unfortunately, both function works for the Origin Forms but not Import. Could anyone kindly provide me with a working example? Thank you   Kai

Hello OneStream Community, I am posting this to gather some knowledge on what others are doing today in regards to managing APIs for your internal customers (primarily focused on Outbound integrations).  Feel free to use the topics below for this forum (not mandatory).  All ideas are welcome. Topics: - Best Practices - Api Management Software - Environment Considerations - Security  Thank you in advance for sharing.  - Clifton

Hi,   I am working with WorkflowClusterPk objects and I know I can get the ScenarioKey, which is an integer, like this: Dim scenarioKey As Integer = si.WorkflowClusterPk.ScenarioKey   How do I get the scenario name (as a string) from the ScenarioKey? Is it possible? Alternatively, which function could I use to get the current workflow scenario name?   Thank you

Happy inflation and recession (aka layoffs) everyone <silly grin> How do you handle a sale of a division in your company to other corporations? For example:  We have a Division1 selling widgets. It is under a consolidation roll-up for external reporting purposes. After we sold it, we want to stop tracking its history of transactions, so we create another member in Entity dimension called Division1_sold, put it under a different 2nd roll-up in Entity dimension.  We need it to track and wrap up any costs/ revenue pertaining to Division1 that is no longer ours, and so we don't want to report nor consolidate it under the first roll-up.Is there a more elegant way to solve this problem?  I see that OneStream allows us to set up for each member (such as Division1) that has  a date when 100% consolidation begins and ends.Thank you for your advice. I'm in SLO California. If anyone lives near me, let's meet up for lunch - my treat!!

Hello, I am trying to have a member rule dynamically calculate and not consolidate to parent entities, which is working.  However, it also needs the member rule to override the summation of MTD to YTD.  I need the account to recalculate always.   i have a simple api.data.GetDataCell ("A#Account1 / A#Account2) I have the settings: account type: dynamically calculate formula type: dynamically calculate Is consolidated: Conditional is there something else i need to do?  thank you

Hi OneStreamers,   I am trying to build an XFBR which I will link to a CV Column, that will either "True" or "False" Depending on the value of a parameter.   However I am finding trouble returning the value. I came up with this but it seems tor eturn the Default Value of the parameter and not the Selected Value :  "If args.FunctionName.XFEqualsIgnoreCase("CheckScnForVisibleColumn") ThenDim ScnParamName As String = "3_cm_param_S_SelectFC"Dim ScnParamValue As String = ""ScnParamValue = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, ScnParamName)brapi.ErrorLog.LogMessage(si,ScnParamValue)" Appreciate your help 🙂    Regards, Adam    

Happy start of recession and layoffs, everyone !!  😋 We need to import flat file that has a row of header followed by rows of data like this: |R|Year|AA|BB|Account  |cc|dd|ee|      |0|2022|  99,953,899.56-|      | account123   |          |     ||| Do you have a sample BR that reads this text file and  return the Column Number of unique header AA?  BR should return the number 3.