I am trying to solve the manual task of reporting in Excel.

The idea is to use Power BI to replace Excel. The calculations can be done in Power BI, but...

I am trying to solve the manual task of reporting in Excel.

The idea is to use Power BI to replace Excel. The calculations can be done in Power BI, but...

Only getting data for one of the dimension tables in Test table:

Thank you. Will you have a look at this , https://www.sqlservercentral.com/forums/topic/calculating-days-timeare-loops-neccessary, please

My Temp table:

-- CTE to handle duplicates
WITH deduplicated AS (
    SELECT DISTINCT ON ("ZTBR_TransactionCode")
        fact."ZTBR_TransactionCode",
  ...

Does the Temp table need to have all the columns from the Join, don't understand where you say "Do this for all the remaining queries."?

SELECT 
 ...

Does this solve the issue of the NULL columns and would i still need to do the UNION as described in the requirements/tasks?

Please give example of this code?

I have joined two dimension tables here:

SELECT 
    fact."ZTBR_TransactionCode",
    fact."Company_Code",
    fact."Posting_Period",
    fact."Fiscal_Year",
   ...

Is there a better way in doing this?

Here is the Fact Table:

-- Table: system.IMETA_ZTRB_MP$F_ZTBR_TA_BW

-- 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"
(
   ...

• This reply was modified 2 years ago by yrstruly.

This is what i have to work with.

• This reply was modified 2 years ago by yrstruly.
• This reply was modified 2 years ago by yrstruly.

Thank you for trying to assist. I did a left join and the data appeared, I filtered it out with NOT NULL, and then it gave me all the rows...

SELECT 
    S.*,  -- Select all columns from the system.IMETA_ZTRB_MP$F_ZTBR_TA_BW table
    D."CoCd" AS "Dim_CoCd",  -- Alias the CoCd from...

Not an error, but no data for joined columns.

The issue is, all of these tables dont have primary/secondary keys, which i brought in with sl code.

Because these keys dont correspond to one another it gives me these errors....