• Print |
• E-mail  |
• Bookmark

When performing a calculation that uses division in an analytic, a
percent (%) format is applied automatically.

With HCM hot fix 31HR02, a format= attribute can been added to the
simple division formulas.  You can now specify PERCENT.d or COMMA.d,
where d is the number of decimal places to show. PERCENT.2 is the
default format.

To implement this change at your site, your system administrator can
edit the \spec\table\hdsmmddb.xml file in your metaserver location. Edit
the mddbformula tags that contain the type="simpledivision" attribute.

SAMPLE xml file with format= changes:

<?xml version="1.0" encoding="UTF-8"?>

<table tbltype="MDDB" master="H" bldorder="300"
  desc="Headcount Summary Multidim Table" subject="TC000004"
  wh_refresh="YES" program="hdsmmddb" image="mddb" rundate=""
  runtime="9" startbkmk="" startbkmk_A="">
 .
 .  (text deleted)
 .
<mddbformulas>
  <mddbformula type="simpledivision" format="PERCENT.3"
    numerator="TERMS" denominator="HEADCNT" stat="SUM"
    visible="YES">turnover</mddbformula>
  <mddbformula type="simpledivision" format="COMMA.1"
    numerator="TERMS" denominator="HEADCNT" stat="SUM"
    visible="NO" rolling="YES">avgturn</mddbformula>
 .
 .
 .



A Technical Support hot fix for HR Vision 3.1 for this problem is
available at:

http://www.sas.com/techsup/download/hotfix/hr_vision31.html#011568

Operating System and Release Information

A fix for this issue for HR Vision 3.1 is available at: