Recent Discussions
How to include Member IDs in data export
We are using an extender business rule to run FdxExecuteDataUnit and write the data (with dimensionality) to a file. The file generated seems to be a standard format with a column for each dimension. Does anyone have any ideas on how to include the Member IDs in the file export? Thank you, Denise
Write an amount
I am having difficulty writing an amount to a prior month via a Finance business rule. Specifically, for forecasting purposes in the last month of a quarter we calculate an excess amount and then want to spread that amount to the last two months in the quarter. I can successfully calculate and write to the last month but cannot seem to write to the prior month. For example, in Q2 as of June calculate the excess amount and then write 50% in May and 50% in June. Has anyone been able to accomplish something like this? Thanks in advance.
Member expansion on the "Remove" Function Alternative
Hello Community, I'm writing a rule to copy data from one scenario to another using api.data.calculate. However, I would like to exclude some accounts from being copied. Something like the following: api.Data.Calculate("V#YTD:S#ACTUAL=RemoveZeros(V#YTD:S#ACTUAL_TEST)","A#Root.Base.remove(A#CAPEX_ACCOUNTS.Base)") I understand that the Remove function will not accept a member expansion. Members to be removed must be listed in the function as specified in this post: "What is the best approach to “subtract” members in a hierarchy, the following member filter is not returning the expected results. E#Tot_Mgmt.Remove(Houston) | OneStream Community" But is there any alternative to do it without listing accounts to remove one by one ? Any help is appreciated! Thank youExternal/Internal Gross Profit Calc
Hello, I'm trying to calculate an External and Internal Gross Profit calculation based off a few conditions. To calculate External/Internal GP, I need to allocate the ExtCGSOther group + OpExp using our UD1 MFGResale between External/Internal using an allocation basis of ExtMLBS and IntMLBS (with the exception of account 6123 which is 100% External). I need this calculation to be on a dept by dept basis. I'm not really sure where to start and I tried looking at Golfstream but couldn't find anything that fits what my company is asking me to build. Thanks, Will
Corrupt file issue with BRApi.Utilities.SaveFileBytesToUserTempFolder
Hello We are using the BRApi.Utilities.SaveFileBytesToUserTempFolder command in a dashboard extender rule to open a file generated by IFS. It will create PDF or Excel files based on the extension of the file. When the user tries to open either file type they get one of the following errors. I am able to locate the generated file in my Temp folder but it won't let me open from there either. Has anyone see this or know of a solution? I am aware it is a MS issue probably not OS, but was just thinking there may be a new way to generate these files so MS doesn't think they are corrupted. The client is currently on 7.4.2. They had previously been on 6.8.1 but apparently have not used this dashboard since then. Thank you CR
Read Source Data for Summary Function
Hello, I'm working on a rule that drills back into source stage data from the target summary table. I'm receiving an error on the ReadSourceDataForSummaryRow line that the method or operation is not implemented. I've verified that the parameters I'm passing are correct and in the correct format. Dim importTable As List(Of TargetDataInfo) = BRApi.Import.Data.ReadSummaryTargetData(si, si.WorkflowClusterPk, Nothing) If importTable.Count > 0 For Each importLine As TargetDataInfo In importTable Dim summaryRowID As Guid = importLine.SummaryRowID api.LogMessage("before, summaryRowID: " & summaryRowID.ToString) Dim sourceLinesForSummaryID As List(Of SourceDataInfo) = BRApi.Import.Data.ReadSourceDataForSummaryRow(si, summaryRowId) api.LogMessage("after") Next End If Has anyone else encountered this issue before? I'm working in OS version 8.2.3, but didn't see anything relevant in subsequent release notes. Thank you!
