dimension members

14
ID EVDESCRIPTION PARENTH1 410000 Revenue G4_GM 510000 Cost of Goods Sold G4_GM 520000 Selling Expense G5_OPEX 530000 General Expense G5_OPEX 540000 Admin Expense G5_OPEX 550000 Depreciation Expense G5_OPEX 560000 Tax Expense G4_NI G4_GM Gross Margin G4_PTI G4_NI Net Income G4_PTI Pretax Income G4_NI G5_OPEX Operating Expense G4_PTI

Upload: mahesh-reddy-m

Post on 30-Nov-2015

27 views

Category:

Documents


0 download

DESCRIPTION

Dimension Members for SAP BPC Practice

TRANSCRIPT

Page 1: Dimension Members

ID EVDESCRIPTION PARENTH1 ACCTYPE SCALING410000 Revenue G4_GM INC510000 Cost of Goods Sold G4_GM EXP520000 Selling Expense G5_OPEX EXP530000 General Expense G5_OPEX EXP540000 Admin Expense G5_OPEX EXP550000 Depreciation Expense G5_OPEX EXP560000 Tax Expense G4_NI EXPG4_GM Gross Margin G4_PTI INCG4_NI Net Income INCG4_PTI Pretax Income G4_NI INCG5_OPEX Operating Expense G4_PTI EXP

Page 2: Dimension Members

RATETYPEAVGAVGAVGAVGAVGAVGAVGAVGAVGAVGAVG

Page 3: Dimension Members

ID EVDESCRIPTION PARENTH1 CURRENCY20 Rich Bloom, Inc, San Diego, CA, USA US USD22 Rich Bloom Corporate Inc, Philadelphia, PA, USA US USD23 Rich Bloom New Markets Inc, Houston, TX USA US USD25 Rich Bloom Ltd., London, UK TOT_ENT GBP30 Rich Bloom AG, Frankfurt, Germany TOT_ENT EUR

US USA TOT_ENTTOT_ENT All entities

Page 4: Dimension Members

ID EVDESCRIPTION PARENTH1CK2000 T-Shirts ALL_PRDCK2001 Shirts ALL_PRDCK2002 Jackets ALL_PRDCK2003 Apollo Shirts ALL_PRDCY7000 Jeans ALL_PRDPRN None ALL_PRDALL_PRD All Products

Page 5: Dimension Members

ID EVDESCRIPTION PARENTH1USE US Southeast US_SGUNE US Northeast US_SGUMW US Midwest US_SGUSW US Southwest US_SGUWS US West US_SGDE Germany ALL_SGUK United Kingdom ALL_SGSGN None ALL_SGUS_SG US Sales Groups ALL_SGALL_SG All Sales Groups

Page 6: Dimension Members

ID EVDESCRIPTIONPlan PlanActual ActualForecast Forecast

Page 7: Dimension Members

ID EVDESCRIPTION PARENTH1 SCALING CONSO_TYPETOTALADJ TOTALADJ NCONTRIB Contribution TOTALADJ NT_INPUT Total Input PREADJUST NT_LOAD Data load source PREADJUST NInput Input T_INPUT NBWLOAD Load from BW system T_LOAD NMAN_AJE Manual Journals T_INPUT NT_ELIM Consolidation Eliminations CONTRIB NAJ_ELIM Eliminations T_ELIM NT_AUTO Total Automatic CONTRIB NAJ_ACCTRAN Account Transformation T_AUTO NSAPGL Data from SAP FIGL T_LOAD NSAPCOPA Data from SAP COPA T_LOAD NLEGACY Data from Legacy loaded to SAP BW T_LOAD NPREADJUST Pre-adjustment CONTRIBTOTAL1 Total 1 TOTALTOTAL2 Total 2 TOTALDEBIT1 My Asset/Income TOTAL1CREDIT1 Their Liability/Expense TOTAL1DEBIT2 Their Asset/Income TOTAL2CREDIT2 My Liability/Expense TOTAL2TOTAL Total

Page 8: Dimension Members

COPYOPENING DATASRC_DATASRC_TYPE IS_CONSOL IS_CONVE OPENING_STORED_CSTYLE

Y I Y YY I Y YY M Y Y

N A Y Y

Y I Y YY I Y YY I Y Y

NNNN

Page 9: Dimension Members

ENABLEJRN IC_ORGINEIC_ORIGINE

I II I

Y I I

I II II I

D DC CD2 D2C2 C2

Page 10: Dimension Members

ID EVDESCRIPTION REPORTING CURRENCY_TYPELC Local Currency LUSD USD Y REUR EUR Y RGBP GBP R

Page 11: Dimension Members

ID EVDESCRIPTION PARENTH1 LEVEL YEAR PERIOD2011.Q1 Q1.2011 2011.TOTAL QUARTER 2011 Q12011.Q2 Q2.2011 2011.TOTAL QUARTER 2011 Q22011.Q3 Q3.2011 2011.TOTAL QUARTER 2011 Q32011.Q4 Q4.2011 2011.TOTAL QUARTER 2011 Q42011.TOTAL 2011 YEAR 2011 TOTAL2011.01 Jan 2011 2011.Q1 MONTH 2011 JAN2011.02 Feb 2011 2011.Q1 MONTH 2011 FEB2011.02 Mar 2011 2011.Q1 MONTH 2011 MAR2011.04 Apr 2011 2011.Q2 MONTH 2011 APR2011.05 May 2011 2011.Q2 MONTH 2011 MAY2011.06 Jun 2011 2011.Q2 MONTH 2011 JUN2011.07 Jul 2011 2011.Q3 MONTH 2011 JUL2011.08 Aug 2011 2011.Q3 MONTH 2011 AUG2011.09 Sep2011 2011.Q3 MONTH 2011 SEP2011.10 Oct 2011 2011.Q4 MONTH 2011 OCT2011.11 Nov 2011 2011.Q4 MONTH 2011 NOV2011.12 Dec 2011 2011.Q4 MONTH 2011 DEC2012.Q1 Q1.2012 2012.TOTAL QUARTER 2012 Q12012.Q2 Q2.2012 2012.TOTAL QUARTER 2012 Q22012.Q3 Q3.2012 2012.TOTAL QUARTER 2012 Q32012.Q4 Q4.2012 2012.TOTAL QUARTER 2012 Q42012.TOTAL 2012 YEAR 2012 TOTAL2012.01 Jan 2012 2012.Q1 MONTH 2012 JAN2012.02 Feb 2012 2012.Q1 MONTH 2012 FEB2012.03 Mar 2012 2012.Q1 MONTH 2012 MAR2012.04 Apr 2012 2012.Q2 MONTH 2012 APR2012.05 May 2012 2012.Q2 MONTH 2012 MAY2012.06 Jun 2012 2012.Q2 MONTH 2012 JUN2012.07 Jul 2012 2012.Q3 MONTH 2012 JUL2012.08 Aug 2012 2012.Q3 MONTH 2012 AUG2012.09 Sep2012 2012.Q3 MONTH 2012 SEP2012.10 Oct 2012 2012.Q4 MONTH 2012 OCT2012.11 Nov 2012 2012.Q4 MONTH 2012 NOV2012.12 Dec 2012 2012.Q4 MONTH 2012 DEC

Page 12: Dimension Members

TIMEID MONTHNUM3 201100016 201100029 2011000312 2011000412 201100051 201101002 201102003 201103004 201104005 201105006 201106007 201107008 201108009 2011090010 2011100011 2011110012 201112003 201200016 201200029 2012000312 2012000412 201200051 201201002 201202003 201203004 201204005 201205006 201206007 201207008 201208009 2012090010 2012100011 2012110012 20121200

Page 13: Dimension Members

ID EVDESCRIPTION REPORTING MD SCALE ENTITYAED United Arab Emirates MAUD Australia Dollars MBRL Brazilian Real MCAD Canada Dollars MCHF Switzerland Francs MCNY China Yuan Renminbi MDZD Algeria Dinars MESP Spain Pesetas MEUR Euro Y MGBP United Kingdom Pounds MINR Indian Rupee MJPY Japan Yen MNZD New Zealand Dollar MSGD Singapore Dollars MTHB Thailand Baht MTRL Turkey Liras MTTD Trinidad and Tobago Dollars MTWD Taiwan New Dollars MUSD United States Dollars Y MVEB Venezuela Bolivares MZAR South African Rand MZMK Zambia Kwacha MARS Argentine Peso MRON Romanian Leu M

Page 14: Dimension Members

STORED_CALC