The same code bring in values for FY24, 23 etc. Dont understand why FY25's
values are 0.
On Thu, 8 Aug 2024 at 18:56, Adrian Klaver
wrote:
> On 8/8/24 09:35, Anthony Apollis wrote:
> > I need your assistance with an ETL process that runs every six months.
> > Currently, we
That very same code is picking up all the data in the Original Table. Which
only contains past data.
On Tue, 16 Jul 2024 at 17:39, Adrian Klaver
wrote:
> On 7/16/24 08:28, Anthony Apollis wrote:
> > Only data up until 2024 is picked up in Revised table, whic contains
> > 2025 da
(Tue)
On Tue, 16 Jul 2024 at 17:28, Anthony Apollis
wrote:
> Only data up until 2024 is picked up in Revised table, whic contains 2025
> data. THe Maxdate calculation seems to be the problem.
> -- Step 1: Define the Fiscal Calendar
> WITH FiscalCalendar AS (
> SELECT '
I am using Postgres and SQL Server.
Can you test the data pls.
On Tue, 16 Jul 2024 at 16:45, Adrian Klaver
wrote:
> On 7/16/24 05:53, Anthony Apollis wrote:
> > 1. The problem is the code below reads only data up until 2024,
> > although the table has been updated with l
1. The problem is the code below reads only data up until 2024, although
the table has been updated with latest data that contains 2025, for some
odd reason it is not pulling in or showing data when filtering for 2025 or
even 2024 and later, which should contain all the latest data.
Data in Excel
On Wed, 28 Feb 2024 at 22:22, Anthony Apollis
wrote:
> Please assist. I am using SSIS to read data from an Excel sheet into
> Postgres. I have increased the column size a few times, just cant seem to
> get the data in. Getting errors relating to destination column size.
&
*I am trying to convert a column from ZAR Column "
Amount_in_Company_Code_Currency" " to USD.*
Table:
CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW2"
(
"Company_Code" character varying(255) COLLATE pg_catalog."default",
"Posting_Period" integer,
"Fiscal_Year" integer,
Please assist me?
I am trying to calculate
Current Period Prior Period Movement from my data, the date columns
are:
[image: image.png]
Please check my code for any errors, code runs, i just want to make sure it
does what it's supposed to do.
-- View: model.IMETA_ZTRB_BRACS_Model_TA_BW_View
For sample data in Excel see
https://drive.google.com/file/d/17aOmG-Ynx-6U05wNNrHXJG7iywgCMiuy/view?usp=sharing
(1) The fact table is from SAP.
(2) Dimension Tables are named "B Masked". Please note that none of the
tables had primary keys, I had to bring them in myself. In the Bracs
Mapping tab
I cant get distinct data, im tying to break up the insert into chunks and
it does not help
On Mon, 13 Nov 2023 at 20:05, Adrian Klaver
wrote:
> On 11/13/23 09:54, Anthony Apollis wrote:
>
> Please reply to list also
> Ccing list
>
> > Hi Adrian
> >
> > Yes, the
Please advice. I brought in data from SAP and assigned unique primary key
to the table:
[image: unique]
CREATE TABLE IF NOT EXISTS fact."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
(
"ZTBR_TransactionCode" integer NOT NULL,
"Company_Code" character varying COLLATE pg_catalog."default",
"Posting_Perio
I have a table that needs to give me all data up until yesterday. This will
be part of an SSIS package that runs monthly, a day before the last day.
code is:
-- Create the new table if it doesn't exist and insert data
CREATE TABLE IF NOT EXISTS "model"."IMETA_ZTBR_BRACS_Model_TA_BW" AS
SELECT
I brought in the Primary/Secondary/Foreign keys because it does not exist
in the Fact/Dimension tables.
The Fact tables contain 6 million records and the dimension tables are
tiny. Because some columns don't exist in the Fact and Dimension table I
can not update the Foreign Keys in the Fact table
t;Entity_ID";
-- Step 4: Re-add foreign key constraint for Entity
ALTER TABLE system."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
ADD CONSTRAINT fk_entity FOREIGN KEY ("Entity_Secondary_Key") REFERENCES
dim."IMETA_Entity_Mapping"("Entity_ID");
"
Thank you!
On Mon, 11 Se
Fact Table:
-- DROP TABLE IF EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW";
CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
(
"ZTBR_TransactionCode" integer NOT NULL DEFAULT
nextval('system."IMETA_ZTRB_MP$F_ZTBR_TA_BW_ZTBR_TransactionCode_seq"'::regclass),
"Company_Code" charac
Please assist.
I am retrieving data from SAP BW using SSIS. The data is loaded into:
CREATE TABLE IF NOT EXISTS system."IMETA_ZTRB_MP$F_ZTBR_TA_BW"
(
"Company_Code" character varying(4) COLLATE pg_catalog."default",
"Posting_Period" character varying(7) COLLATE pg_catalog."default",
"
*Please review my code and make recommendations where needed. I have this code:
*```
NUMBER OF LOOPS FOR POSTGRESQL ETL:
SELECT
CASE
WHEN (((EXTRACT(DAY FROM
((CASE
WHEN
(SELECT D
le in SQLServer, but it does not have to be in
Postgres. Thanks
On Thu, 20 Jul 2023 at 16:51, Geoff Winkless wrote:
> On Thu, 20 Jul 2023 at 15:28, Anthony Apollis
> wrote:
> > I am attaching my TSQL and Postgres SQL:
>
> You're still missing some CREATEs, for example
-- Forwarded message -
From: Anthony Apollis
Date: Thu, 20 Jul 2023 at 16:07
Subject: Re: TSQL To Postgres - Unpivot/Union All
To: Geoff Winkless , David G. Johnston <
david.g.johns...@gmail.com>
I am attaching my TSQL and Postgres SQL:
On Thu, 20 Jul 2023 at 15:58,
Hi
What list can i post sql related errors etc?
20 matches
Mail list logo
