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

Best way to pass cube view data into a business rule data table?

Dear community, I am currently using FDXExecuteCubeView in order to get only data coming from a cube view that the user is selecting into a business rule data table. However, FDXExecuteCubeView need to specify the entity & scenario member filters whi...

Sergey by Contributor III
  • 999 Views
  • 1 replies
  • 0 kudos

Loop through Account for Confirmation Rules

Hello, I am looking to write a confirmation rule which pulls a value for a flow member across each account. An example would be we have a calculated opening balance and a loaded opening balance. There is a flow members which calculates the variance b...

Reading current month in XFBR

Hello, I have a requirement where I'll have to read the current month in XFBR rule and return a string based on a few conditions. The time filter in the columns is set to |WFYear|.Base. I've tried a few different variables, but they're all only passi...

Manasa by New Contributor III
  • 1806 Views
  • 5 replies
  • 1 kudos

Resolved! FdxExecuteCubeView but just with rows & columns headers ?

Dear Community, For one of my project I need to get the values of a given cube view as a data table within my business rule. I can fairly use the FdxExecuteCubeView which will give me this kind of output : Cube Entity Local Scenario Time YTD Account ...

Sergey by Contributor III
  • 935 Views
  • 1 replies
  • 0 kudos