view the POV of the datacell executing BusinessRule.DashboardStringFunction XFBR business rule?
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)Solved5.6KViews0likes10CommentsAccessing predefined substitution variables in Business Rules
Hi, I can't seem to find a method in the api that accepts a substitutionvariable object and returns the string value of that substitution variable. Or just get a dictionary of all predefined substitution variables and their values. Is this or something similar available?Solved4.1KViews0likes7CommentsRunning DM package from the BR and completing the workflow step
I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package. The last step in the DM sequence runs the Extensibility BR that completes the workflow step. Everything seems to work except that the workflow step window does not refresh after the sequence completion. The workflow step appears incomplete even though it is. The click on the "refresh Application" icon is required. Is there a way to address it? My Extensible BR is below:Solved3.8KViews2likes15CommentsCube Views - Calling XFBR Rules w/in a XFBR Rule
Hi All, I'm trying to call out a XFBR string w/in a XFBR string in the column set of my CV (snip below). Our consultant initially setup the first XFBR so that we could report on completed weeks of the month while rendering zero for the future weeks. The logic works great but is dependent on manually entered parameters. This is when I tried to introduce the second XFBR string to dynamically determine the prior week so that we can automate distribution of this output. After pushing in the second XFBR string I get an error when running the CV of, 'Input string was not in a correct format' (see second snip). I've tried to pass in the week value as an integer, a string, and as an Int32 value but nothing has worked yet. I've also tried with and without the brackets [ ] on the CV column set, but no luck. Any suggestions out there? Help would be greatly appreciated. Thanks, Bryan3.6KViews0likes3CommentsHow to loop through all Import steps within the node of the workflow hierarchy?
Within the Extender business rule used to integrate with our ERP system I would like to loop through all the "Import" steps within a specific node of workflow hierarchy and to read the values of the "TextX" properties. I've heard that this is possible but have no idea where to start. Any guidance would be greatly appreciated. YanSolved3.6KViews0likes7Commentsget data value from BRApi.Finance.Data.GetDataCellUsingMemberScript
Hi, I'm trying to get the amount of an objDataCellInfoUsingMemberScript but I couldn't get the data, I'm trying this: objDataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,"KemetFinRptg", "E#LEGAL_Y:C#Local:S#Actual_YAGEO_Fx:T#2022M1:V#MTD:A#702006:F#Top:O#Top:I #Top:UD1#0021:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None" ) 'String to convert Dim stringToConvert As String = objDataCellInfoUsingMemberScript.DataCellEx '<-- Update string to be converted 'Convert to double. Set to 0 if string if not able to be converted Dim dblValue As Double = stringToConvert.XFConvertToDouble(0)Solved3.5KViews0likes8Comments