Recent Discussions
Summary: The remote server returned an error: (502) Bad Gateway
Hello OS Community - We are running into below error while trying to load 1 + million records from SAP via connector business rule. Tried with all the options on Cache Page Size limit, at present it is set as below. We did not have any luck so far. Any recommendations or guidance is much appreciated. Summary: The remote server returned an error: (502) Bad Gateway Thanks.Service Factory - Data Management Step
We're moving most of the Business Rules to Workspaces Assemblies under PV 8.4. - We have several Extensibility Rules that are run by multiple Data Management (DM) Jobs like you. - Hence, we included separate DM Step Services (DMSS) in the same Service Factory (SF). - The result of this SF setup was chaos. - We saw that launching one DM Job by a given DMSS in the SF will also launch other DM Jobs by their DMSS in the SF. We couldn't find enough practical advice on the SF/DMSS setups in the Design Guide to overcome this chaos. Pls share how to set up Data Management Step Services in a Service Factory to launch one Extensibility Rule/DM Job at a time. TY.
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.External/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!
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, DeniseDynamically change the dashboard layout
Hello, I have a weird behaviour when defining dynamically the dashboard layout. If I define dynamically the dashboard layout to be either a vertical stack panel, horizontal stack panel, or uniform, then all of my components render as expected. However, if I want to define them as grid (3 rows, 2 columns), then nothing is rendered. I did use (in that order, if that has any consequences) : contant DashboardLayoutType.Grid property GridLayoutDefinition.RowDefinitions as a list of xfgridlayoutrowdefinition property GridLayoutDefinition.ColumnDefinitions as a list of xfgridlayoutcolumndefinition The logs are telling me that the dashboard indeed is now a grid with 3 rows and 2 columns, however all of my components are not rendered in the dashboard. Being a grid : Being a vertical stack panel, horizontal stack panel, or uniform : I do know that a grid is intepreted differently as a XAML grid class but I have no clue why it wouldn't be rendered with my components in it. Any help or insight on this is greatly appreciated, Regards,
FDXExecuteCubeView
Hi, I am working on extracting data from a Cube view to a flat file. I am using FDXExecuteCubeView query to extract. The extract file is executed to run for one year. I am seeing for each Entity, Scenario, Time (DU) a log entry is created in Task Activity. The Task Activity is getting flooded with cube view log entries. Is there a way to stop the Cube view entries for each Page (Entity, Scenario, Time).? On the Cube view I have the log setting set to False and also in the FDXExecuteCubeView setting I have the logStatistics setting set to False. Is there a way to not log the entry for each time cube view is run for (Entity, Scenario, Period)? Appreciate your inputs!
