ESSBASE——重新整理以前的report脚本代码2

指标(变量) 预算级次 注册类型 时间 税务机关 登记行业(第一产业,非监管重点)

预算级次(YSJC):10

注册类型(ZCLX):110

时间(SJ):2004

指标(ACCOUNTS):SJRKSE

20041

20042

20043

20044

登记行业(DJHY)(THI_01):农,林,牧,渔业

农业

DATA

林业

畜牧业

渔业

农林牧渔服务

示例1:

<PAGE (Measures, Market) Illinois Sales <SYM {WIDTH 7} {WIDTH 20 0}      <COLUMN (Scenario, Year)      Actual Budget Scenario      Jan Feb Mar <DESCENDANTS "100"      !

Messures,Market

Sales Illinois

Actual

Budget

Scenario

Jan

Feb

Mar

Jan

Feb

Mar

Jan

Feb

Mar

100-10

100-20

100-30

示例2:

<PAGE (Product, Market)                           <COLUMN (Scenario, Year)   //列的层次取决与COLUMN                           Actual   Budget Budget Budget                             Jan    Jan    Feb    Mar <ROW (Accounts) { RENAME "Revenue" } Sales { RENAME "Cost of Goods" } Cost_of_Goods_Sold { RENAME "Gross Margin" } Margin { SKIP UNDERSCORECHAR " " } <ICHILD Total_Expenses { SKIP } Profit     !

Product Market

Product,Market

Actual

Budget

Budget

Budget

Jan

Jan

Feb

Mar

Revenue

Cost of Goods

Gross Margin

Marketing

Payroll

Miscellaneous

Total Expenses

Profit

SWJG:244000000 ACCOUNTS:SJRKSE

SJ:20041

200401

200402

200403

ZCLX:100

110

120

130

140

150

160

170

190