Rules
Discuss Formulas and Business rules for your application

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

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...

tmp.png 1c_code.gif
JackLacava by Community Manager
  • 1387 Views
  • 6 replies
  • 3 kudos

Fetch Workflow Information inside Transformation Event handler

Dear Community, I'm currently working with event handlers and need to retrieve workflow-related information within the FinalizeValidateIntersect operation. I'm using si.WorkflowClusterPk to access this data, but I'm exploring alternative approaches t...

Shivangi by New Contributor II
  • 102 Views
  • 5 replies
  • 0 kudos

Resolved! Parameter for SQL

When I have a BR, and need to pull in a parameter, I use the following statement or one similar, I create the parameter in a Dashboard. 'Dim scenario As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "Forecast_Scenario") How...

Tom by New Contributor II
  • 210 Views
  • 8 replies
  • 0 kudos

Resolved! SQL Query to External Table

I tested the following SQL in a data adapter, accessing a external table Select * FROM Table WHERE "Cost Center" = 'CC_11111111' ; Data returned here, data adapter worked fine. I am using a Business Rule, and can’t seem to get the BR to work if there...

Tom_0-1713446755671.png
Tom by New Contributor II
  • 299 Views
  • 10 replies
  • 0 kudos

Pass Results from Business Rule into UD8 Formula

Hi - I have a dashboard XFBR business rule that calculates totals for members with a specific text value in a cube view. The rule is working as designed, and I have a couple GetDataCell functions in separate columns that reference these totals. Howev...

benmac360 by New Contributor III
  • 141 Views
  • 6 replies
  • 0 kudos

Business rule

Hello Community, From the above image, you can see TM (dynamic calc), TMStored (stored calc).Here, If my current period is 2023M5,then it should skip current period and take further 12 periods( 2023m6,2023m7,2023m8,2023m9,2023m10,2023m11,2023m12,2024...

Akalya_N_0-1713356859054.png Akalya_N_0-1713357368098.png
Akalya_N by New Contributor
  • 102 Views
  • 1 replies
  • 0 kudos