Using Smartlist In Business Rules

Using Smartlist In Business Rules. Create a smart list in epbcs; For bso, the user must set “data type” to “smartlist” for the associated member.

How to Add Flexibility to Your Business Rules in Oracle PBCS & Hyperion from www.schgroup.com

In calculation manager, create a rule, using the variable == to planning expression for the smartlist. Use smart list values in member formulas and business rules. On the tools menu, select setup, select system, and then select smartlist security.

Source: docs.marketo.com

Rename a column header in gp, many times the field display names are different than our business language. Check the box next to the table name to select all fields in the table, or expand the node to select individual fields.

Source: www.schgroup.com

Check the box next to the table name to select all fields in the table, or expand the node to select individual fields. Name the smartlist, choose a product, and select the series the smartlist will display in.

The Rule Will Cycle Through 2 Dimensions (I.e.

Smartlist is a quick, easy to use, customizable ad hoc reporting tool that comes with dynamics gp. This will be opened in smartlist designer by default but will open smartlist builder if that has been installed. So while they may not be documented this is coming from code released from oracle and code that they support.

An Example Script Is As Follows:

The smart list creation documented in the blog is a feature of the software and that is well documented. Go to microsoft dynamics gp >> tools >> smartlist builder >> smartlist builder. When clicking into data form cells, users select items from.

Contact, Company, And Deal Properties — You Can Filter Your Contacts Based On The Information In Their Contact, Company, Or Deal Properties.

Create custom queries with predefined data that gives you just the information you want, when you want it. My smartlist sl_month has 12 members jul to jun (in that order). It turns out they had really not utilized smartlists at all in their day to day work yet, despite using dynamics gp for a few years.

The Business Rule Looks Like This:

I have a member, “start month” defined as data type smartlist linked to sl_month. While in aso, the user must set “type” to “smartlist”. Product channel is the account with type smart list, channel is the smart list name, and retail is a smart list entry.

The Xref Is From Rules That Oracle Is Releasing As Part Of Epbcs.

To select more than one table, simply check the boxes next to all desired tables or. I have tried with smartlist created from members or defined separately, with and without auto generate id. This allows you to restrict the data returned to the smartlist report.