Rules

I need to copy data, including adj data, from one fiscal year cube to another calendar-based cube.  The DM Job I tried to use does not work with ADJ data as the journals cross entities that don't exist in the target cube. The rule also needs to include variables for entity, account. and scenario remapping. Any sample provided is appreciated. 

Hi Everyone, I am trying to allocate forecast data to the gl's based on the last year actuals data. The allocation is not happening when the forecast scenario setting "clear calculated data during calc" is set to TRUE. If I set it as FALSE, the allocation is happening. This data is copied using the setdatacell from the allocated value to the target script in which origin member is O#forms.  It seems the value is not written to the origin member if I set the scenario setting to true. can someone explain me what is happening? Also, I tried adding the below calculate and clear code.  api.data.calculate($"{script} = 0 * {script}") api.data.clearcalculateddata(script) It worked until I did not change any data, once I changed the data, the allocation did not happen again.     Thanks, Jeevan  

Dear Community, I have a requirement to generate a pop-up or warning message during the Data import process based on a specific condition. If the condition is met, the pop-up should inform the user, but the import process should continue without causing a hard fail. Is this achievable ? Can anyone please suggest a method to achieve this. Thank you.      

Dear community, I currently have a Business Rule connector that works fine. However, I would like to pass a parameter from a dashboard into the SQL query of the connector. This is because the user should load a set of data but they can decide which "slice" of data to use. Hence, the connector should filter the data, and then I need to pass an input parameter to my SQL query within my connector. Any possible way to do that ? Regards,

Dear Team, I'm trying to understand what caused the low performance of my code. I see that it's because of many loops, but I'm wondering if there's any possible way to fix it: Dim ResultDataBuffer As DataBuffer = New DataBuffer() Dim sAccounts As List(Of String) = New List(Of String) From { "1711050", "2742020", "1712020", "2745060", "1346010", "2413010", "1742050", "2716050", "1745010", "2713010", "3221010", "3221020", "3221030", "4451010", "4451020", "4451030", "1722060", "2741030", "4541070", "4321020", "4541010", "4541020", "3222010", "4452010", "4541030", "4541040", "4541050", "4541060", "5111010", "5111020"} Dim mICFilter As List (Of Member) = api.Members.GetBaseMembers(api.Pov.EntityDim.DimPk,api.Members.GetMemberId(dimtype.

Hello, I am trying to adjust the code below to handle the following situation: The client loaded data for Test Rate and Test Count on UD1 "ID". The data buffers defined for prior month (TotDirCOGSDataBuffer and DirCOGSDataBuffer) do not have any values for UD1 "ID". The client wants to do the calculation for UD1 "ID" as follows: take the prior month data from another UD1 member, multiply with the Test Rate and Test Count for UD1 "ID" and place the results on UD1 "ID". How I can accommodate this change, considering this will happen also in the future when they need to perform a calculation on a UD1 member which does not have values in prior months? 'api.Data.ClearCalculatedData(True,True,True,True,"U7#DirCOGS_Calc") api.Data.ClearCalculatedData(True,True,True,True,,,,,,,,,,,"U7#DirCOGS_Calc",) 'Create a result data buffer and destination info to add the cells to later Dim resultDataBuffer6 As DataBuffer = New DataBuffer()

Dear community, When we execute an allocation in OneStream (the one when we right click on a Cube View cell), we can indeed execute an allocation. I was checking but I couldn't see any logs or audit information regarding this allocation. Does anybody know if there's an audit table, or any logs, that are related to this allocations ? On the other hand, are there any event handler related to the execution of this allocation ? Regards,  

I need to export the annotation and data for certain intersection to an external table. I am able to do that using FDX from cube view but can that be done without a cubeview? I am not sure if FDX of data unit would work and if does then how to? When I used that I get only the data. 

I am able to get some export using the FdxExecuteCubeView function but the exported data does not match with the Cube View. I add too many columns in the export and a lot of columns that are in the actual CV are missing. For instance the below two rows are same in terms of data, but the excel export from data explorer shows the entity ID, while it does not show that entity ID in the data table exported to external SQL table. Also, there are missing annotation columns in the data table export too.       Code: (I don't want to filter anything)  

Dear Community, I am trying to run an allocation finance rule. I believe I have set up everything for that in the business rule. However, upon running the BR I get the message "An internal method is not implemented" Please find below the business rule (currently set on a demo asset) :   Dim MyAllocationType As allocationtype = Allocationtype.EvenDistribution Dim MyAllocationOptions As New allocationoptions Dim MyAllocationResult As New AllocationResult MyAllocationOptions.AllocationType = MyAllocationType If MyAllocationType = AllocationType.EvenDistribution ' The value to allocate MyAllocationOptions.SourcePOVMemberScript = "Cb#Houston:E#[Houston Heights]:C#USD:S#BudgetV2:T#2022M12:V#Periodic:A#2000_100:F#None:O#Import:I#None:U1#None:U2#Mach5:U3#NA:U4#[Active Hub]:U5#None:U6#None:U7#None:U8#None" ' Any override to be done on source value MyAllocationOptions.SourceCalcScript = "A#SourcePOV * 0.1" ' Target POV, must be lowest level on all dim except the one being allocated MyAllo

I am trying to extract a static cube view data but getting an error. The CubeView has all static members except the time dimension |WFTime| but I made it static in my code just to be sure. To begin with I only need the data table. But I am getting below error  

I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should. SELECT EntityId, UD1Id, UD4Id, TimeId, ICId, Amount, FlowId, ConsId FROM DataEntryAuditCell WHERE ScenarioId = ( SELECT MemberId FROM Member WHERE Name = '|WFScenario|' ) AND CubeId = 4 AND ICId != -999 AND AccountId = 17826015 AND Amount != 0 AND FlowId IN (1048639,-999) AND UD1Id != -999 AND UD4Id != -999 The reason for using SQL is to facilitate user access to that specific information, as a QView wouldn't display everything according to the required permissions, which in this case doesn't apply as

Hello,  If anyone needs to sort a specific account group by ascending. This is the codes it worked. Sub RemoveandSortAccounts(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardExtenderArgs) Dim ParentGroup As String = args.NameValuePairs.XFGetValue("ParentGroup") Dim osAccountMember As Member = BRApi.Finance.Members.GetMember(si, dimtypeid.Account, ParentGroup) Dim actDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "ST_Accounts") Dim osBaseList As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) Dim osBaseList2 As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) osBaseList2.Sort(Function(x, y) x.Name.CompareTo(y.Name)) If osBaseList.Count > 0 Then For Each baseMember As Member In osBaseList 'osBaseList '===Remove first==== Dim PId As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId.Account, osAccountMember.Name) Dim myId

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample"  button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code after you created the block, just double-click on it. Ideally you'd also indent it first, either in an editor or with something like DotNetFiddle. Remember: the easier it is for others to read your code, the more likely that they'll be able to solve your problem! Cheers!Your friendly neighborhood Spider-Mod

SOURCE: ONESTREAM CHAMPIONS Company has a hard carriage return in their file for a couple of description fields. They are struggling to fix it on their side. Is there code that can be written for the data source to remove this hard return and get everything on one line? Appreciate any guidance or snippet of cod

Spoiler (Highlight to read)   Summary: Error processing Data Management Step 'App2App_Parallel_Step'.Unable to execute Business Rule 'App2App_Parallel'. An item with the same key has already been added.

Hai everyone,             I am trying to access the data from excel through business rule and use it in the business rule.If anyone know the VB.net code,please share with me. 

We’re looking for some kind of way to reference dates in the transaction matching custom filter. For instance I need to be able to reference an attribute (like A9 = ‘ABC’) and also only pull items for D1 = yesterday and then pull another attribute (like A9 = ‘XYZ’) and also only pull items for D1 = two days ago. So the filter would look something like: (A9 = ‘ABC’ and D1 = yesterday) or (A9 = ‘XYZ’ and D1 = two days ago)

Hi everyone! I'm currently building a linked cube view that will inherit the Entity and IC members from the original cube view from which it is called. The IC member, though, will need to go through a transformation (remove the last 3 digits) so I created a XFBR rule to do so. For example, if the Entity member will be 1010TRW, the IC will be 1010. I tried to call the XFBR rule in the POV but when I launch it it returns the following error: "Index and length must refer to a location within the string."   Am I missing something? Below you can find a screenshot of the POV of the linked CV Thank you in advance!

Hi  I create OneStream parameters for the fields that I want to bring in from OneStream into an extensible document in order not to mess up the formatting of the document as the formula is very long to pull the data into OneStream.  Now I want to create a parameter that uses a business rule to check if the amounts for one line of the two year's  income statement (This year and last year) lines are both positive, then put "Profit" in the text of the account or "Profit/Loss" if the one amount is positive and the other is negative or "Loss" if both amounts are negative.   How do i do that ?     

Hi OS Community, I am just wondering if any of you had a chance to build dynamic member list or some similar functionality which allows you to have a specified member list which will be used in a parameter (XFBR). I am having trouble to achieve that... What I created is parameter supported by simple business rule which also use information coming from another parameter. This is working well but only if second parameter which i am using is not part of POV parameters. Looks like I can not use parameter inside used parameter. where this second is also used in CubeView POV... Let me try to describe you on example what is my problem, maybe some of you will be able to help.  What i would like to achieve is to have some connection between entity selected in the cubeview POV and UD1 list of members which then will be presented as a list of members to choose inside parameter and CubeView POV. Example: I have a CubeView with POV where parameters are used for below dimensions :EntityUD1UD2UD

Hey all, Pretty new to programming but have manage to get a file moving rule to work that basically moves a file from FileShareBatchHarvest to Application /Public structure for users to pickup.  However, the rule currently needs the exact name of file. I have tried using wildcard symbols like "* #" for the date with no success.  Does anyone have a recommended solution to get the variable dynamic on the date section?  

Hi All, does anyone built a Smart Integration Function and compressed the datatable with CompressJsonObject and then, in the extensibility rule, inflate it with InflateJsonObject using the variable bulkRemoteResults.resultDataCompressed ? I'm getting the error: "Object reference not set to an instance of an object". If I compress itand inflate it in function worked and in the extensibility rule worked. But, compress in the function and inflate in the extensibility rule didnt work. This is an example in the guide, so I'm not sure if I'm missing something. Thx in advance

Hello Community - Looking for guidance on options to calculate data at QTD to overwrite the number generated from periodic values. This intersection has an option for users to enter periodic values, so I cannot make a member dynamic calc. I am using UD8 dimension member for the calc. Please share your thoughts. Thanks!  

Hello Community, Is there any functions in Business Rule which is related to T#QuarterPrior1...?I'm getting only this following function, Dim timeMemberIdPrQua As Integer = TimeDimHelper.GetLastPeriodInPriorQuarter(timeMemberId) So can you please help me to get this...!