1. User Guide
  2. Business Rules Administration
  3. Static Table Driver
  4. Working with Exported Static Table Driver Data

3.11.2 Working with Exported Static Table Driver Data

During the initial set up on the Definition tab, a Static Table Driver rule has a set of possible Key ' Target combinations equal to the cross product of each of the Key and Target leaves you have defined for your rule. For example, a Static Table Driver rule having one Key leaf dimension with 10 defined members and one Target leaf dimension with defined 100 members has a total of 1,000 possible Key ' Target combinations. Of these 1,000 possible combinations, you may have defined 75, or 125, or any number coefficient values up to 1,000.

The Excel Export feature exports "active" Key ' Target combinations, which are combinations where you have already established coefficients.

The structure of your exported Static Table Driver depends on how many Key dimensions and Target dimensions are used in your rule. The following example shows an exported data from a Static Table Driver having one Key leaf dimension and one Target leaf dimension with 11 defined coefficients.

Figure 3-71 Sample Illustration of Exported Static Table Driver Definitions


This is example shows an exported data a Static Table Driver having one Key leaf dimension and one Target leaf dimension with 11 defined coefficients.

In this example, the first two columns (F0_ID and F0_DESC) contain the leaf identifiers and descriptions for the Key leaf dimension. For a Static Table Driver having a 2nd and 3rd Key leaf dimension, the exported spreadsheet would include ID's and descriptions for each Key leaf dimension (F0, F1, and F2 represent "from" dimensions, such as Key leaf dimensions, while T1, T2, and T3 represent your first, second, and third Target leaf dimensions).