8/11/2019 CustomizeSupportRefDim RPD

1/3

Summary

This document explains how to confgure the supporting reerence dimension based

on customers business setting.

How to fnd Supporting Reerence Dimension Setup in DAC

In DAC, Go to container !racle "#$, %a&igate to Design->Source System

Parameters. 'ind the &alue or the ollowing parameters(

))*+!"T-"'#))*+!"T-"'$))*+!"T-"'/))*+!"T-"'0

))*+!"T-"'1))*+!"T-"'2))*+!"T-"'3))*+!"T-"'4))*+!"T-"'5))*+!"T-"'#6

This parameter should be set based on customers 7* data. 8e use $$SUPPORT_REF3as an example to explain how to confgure Dim - SLA SupportingReference3 in "D. Customer can ollow the same procedure to confgure othersupport reerence dimensions. 7asicall9 $$SUPPORT_REF(n) is mapped toDim -SLA Supporting Reference(n).

How to Confgure Supporting Reerence Dimension in RPD

:ets sa9, in DAC

))*+!"T-"'/ ;

8/11/2019 CustomizeSupportRefDim RPD

2/3

/ !pen :ogical *ource Table Dim__SLA_SUPPORT_REF_D_Reference3, clic

Content, set the 8here Clause as below(

B!racle Data

8arehouseB.BCatalogB.BdboB.BDim-8-*:A-*+!"T-"'-D-"eerence/B.B*+!"T-

"'-C!DB ;

8/11/2019 CustomizeSupportRefDim RPD

3/3

0. Change the logical table and columns name accordingl9. Customer can choosethe name that ser&es them best.

In this example, we mae the ollowing change(Dim % SLA Supporting Reference3is changed to Dim % Proect Supporting ReferenceSupporting Reference Attri"ute& is changed to Proect !'me

Supporting Reference Attri"ute is changed to Proect T#pe

1. At resentation la9er, the attributes name has been changed to reect the new

logical column name. ?owe&er, 9ou need to manuall9 change the presentation

tables name and remo&e the unused columns.

The new presentation table will loo lie below.

2. *a&e the change.

%ote( +nlie *:A Transactions, the *:A balance subEect area onl9 allows users to

report balances or a single supporting reerence at a time Fas in 7* "#$. 8hen

9ou expose multiple supporting reerence dimensions, the *:A balance report ma9

not return all rows. 'or a gi&en row in the *:A balances, onl9 one supporting

reerence column is populated. To add multiple supporting reerences to a report,

9ou need to change the :T* flter or the *upporting "eerence dimensions to

extract unspecifed rows F*+!"T-"'-C!D is %+:: and to appl9 flters in

reports so that each report returns balances or a single supporting reerence F9oucan combine multiple reports in Answers i necessar9.