Extraction of TM1 DATA TO SQL DW
Posted: Fri Jul 29, 2022 10:26 am
Team,
I am new to TM1, we are trying to extract some important finance KPI'S info to SQL DW, from DW point of view i am ok,
since i don't have any exposure in TM1 i am feeling difficulty in preparing documenattion
Ex: I need to extract gross margin KPI numbers, below report(income statement) is developed in excel ad in
and my requirement is to extract Gross margin (277603) to DW. Last line
This is very basic question, since i don't have exposure, kindly help me by providing the steps.
May_YTD Actuals
Upstream Downstream TOTAL Description
Total Upstream Production Volumes
281,437 - 281,437 Export Gas (MMCF)
274,319,474 - 274,319,474 Export Gas (MMBTU)
26,633 - 26,633 Liquids (MBOE)
73,539 - 73,539 TOTAL (MBOE)
Share of Upstream Sales
Sales Volumes
63,054 - 63,054 Gas (MMCF)
61,459,860 - 61,459,860 Gas (MMBTU)
5,882 - 5,882 Liquids (MBOE)
16,391 - 16,391 TOTAL (MBOE)
Downstream Sales Volume Statistics
- 274,689,355 274,689,355 Produced N.Field Gas (MMBTU)
- - - (MMBTU)
- 274,689,355 274,689,355 TOTAL (MMBTU)
Revenues
83,155 - 83,155 Export Gas
19 - 19 Re-injected Ethane
- - (83,174) Elimination on Consolidation
- 665,660 665,660 Sale of Gas
- - - Sale
387,528 - 387,528 Liquids
470,702 665,660 1,053,187 Total Revenues
- 371,655 371,655 Gas Purchases
- (740) (740) Delivery Failure - Gas Supply
- 637 637 Buy Back Tarrif
- - - Service charges on gas storage
- - (83,174) Elimination on Consolidation
- 16,506 16,506 Lease Rent
470,702 277,603 748,305 Gross Margin
I am new to TM1, we are trying to extract some important finance KPI'S info to SQL DW, from DW point of view i am ok,
since i don't have any exposure in TM1 i am feeling difficulty in preparing documenattion
Ex: I need to extract gross margin KPI numbers, below report(income statement) is developed in excel ad in
and my requirement is to extract Gross margin (277603) to DW. Last line
This is very basic question, since i don't have exposure, kindly help me by providing the steps.
May_YTD Actuals
Upstream Downstream TOTAL Description
Total Upstream Production Volumes
281,437 - 281,437 Export Gas (MMCF)
274,319,474 - 274,319,474 Export Gas (MMBTU)
26,633 - 26,633 Liquids (MBOE)
73,539 - 73,539 TOTAL (MBOE)
Share of Upstream Sales
Sales Volumes
63,054 - 63,054 Gas (MMCF)
61,459,860 - 61,459,860 Gas (MMBTU)
5,882 - 5,882 Liquids (MBOE)
16,391 - 16,391 TOTAL (MBOE)
Downstream Sales Volume Statistics
- 274,689,355 274,689,355 Produced N.Field Gas (MMBTU)
- - - (MMBTU)
- 274,689,355 274,689,355 TOTAL (MMBTU)
Revenues
83,155 - 83,155 Export Gas
19 - 19 Re-injected Ethane
- - (83,174) Elimination on Consolidation
- 665,660 665,660 Sale of Gas
- - - Sale
387,528 - 387,528 Liquids
470,702 665,660 1,053,187 Total Revenues
- 371,655 371,655 Gas Purchases
- (740) (740) Delivery Failure - Gas Supply
- 637 637 Buy Back Tarrif
- - - Service charges on gas storage
- - (83,174) Elimination on Consolidation
- 16,506 16,506 Lease Rent
470,702 277,603 748,305 Gross Margin