Skip to main content

DW PH/Cloud Info: Business Rules

Peter Forsberg
  • Created

  • Updated

Summary

Attached in this article are the business rules for Data Warehouse Manager v4.0+.

Article Sections

More Information

The below rules require the SolverDW database to be SQL2008+

 

Rule Name Description 4.x

PrivateHost 

Cloud
CopyVersion Allows the user to move data from one set of parameters to another. Typically this is used to move data from one scenario to another. ✅ ✅ ✅
CopyVersion_MultiYear use this rule when you want to copy data based on a Scenario and not Period(s). This rule is typically used by customers on a Fiscal Calendar that does not begin at the beginning of the year. ✅ ✅ ✅
Rules_CurrencyTranslation_Rlng This rule assumes that the source data contains monthly activity for all accounts within General Ledger.  The Value2 field is used for YTD balances.  This rule includes Rolling Periods in a Job.     ✅
Rules_Currency_Translation_US_Flexible Similar to prior but has destination Scenario ✅ ✅ ✅
Rules_Currency_Translation Similar to prior but not rolling enabled ✅ ✅ ✅

Consolidations

  1. Minority Interest: Create minority interest transactions based on user defined percent ownership
  2. Intercompany: Create inter company transaction based on user defined percent ownership
   ✅ ✅ ✅
GenerateGLSummaryDataRlling
  1. this business rule creates summary data off of GL_Detail data. It has the following assumptions. 
    1. The Source Data is the GL_Detail module
    2. The Destination is the GL
    3. The Transactional Amount is found in Value1 and the Summed value for GL can go into Value 1.
    4. All other attribute data is null at the GL level.

NOTE: This does not work for selecting sequential periods

     ✅
DeleteData

Delete data for a selected 

  • Module
  • Scenario 
  • PeriodStart & Period End Range
 ✅ ✅ ✅
DeleteData - With Entity

Delete data rule + a selected Entity

 ✅ ✅ ✅
DeleteAll - CurrentPeriodMonthsBack Delete data from N months back to current period where N is the number of months back as defined by the user, limited to 24 months back.  ✅ ✅ ✅
DeleteData - Uploaded by Integration Delete data uploaded by a selected integration for a range of periods.  ✅ ✅ ✅
D365 DimUpdater

Business Central specific:

Parse the dimension codes from the staging dimension to other dimensions.

  • Not needed if Task Filtering is being used in integrations.
   ✅ ✅
DimensionSets

Business Central specific:

this rule is for D365BC customers to populate dimension codes based on DimensionSetID.

  

✅

✅
Calc_OBA

This rule populates into Value 3 the Opening Balance Amount for the beginning of the Period Chosen.

 

Edits may be necessary if you need it to be more granular such as by department, location, etc.

 ✅

✅

✅

Properties:

SolverDW version 4.0+ and Cloud


Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk