How can link table with master calendar

[prma7799]

Hi All,

I have one data model created based on using link table i want to add one more extra table(table:ABC) in that so

How can I link that table .

I already link (table:ABC) to one of fact table but when i am selecting any master calendar field then values are getting wrong.

Please help

[Kushal_Chawda]

How you are linking that ABC table? I mean on which field?

[prma7799]

On div_code...

Please see below

FACT_GL_Entry1:

LOAD [Entry No_] AS EntryNo,

Div_Code &'-'&  num (month(([Posting Date]))) as TKye,

AUTONUMBER(/*[G_L Account No_] & '_' & */date([Posting Date],'DD/MM/YYYY')
& '_' & BusSeg_Code & '_' & AccLoc_Code & '_' & [Gen_ Bus_ Posting Group]
& '_' & [Gen_ Prod_ Posting Group] & '_' & [Location Code]
& '_' & [Document No_]) AS %GLKey,

     Div_Code,
Dept_Code,
[Document Type],
[G_L Account No_] AS GLAcc_Code,
      Amount AS GL_Amount,
//BusSeg_Code,
     //AccLoc_Code,
     Quantity AS GL_Qty,

date([Document Date],'DD/MM/YYYY') AS GL_DocDate,

[Source Code]

FROM D:\Production\Qvds\NAVQVDS\FACTQVGLE.qvd (qvd);

Left join (FACT_GL_Entry1)
Load  GLAcc_Code,
GLAcc_name,
GL_Market_Seg,
GL_Buss_Seg,
GL_Buss_Seg1,
Type1,
TYPE,
[Note No],
[Note Name],
Subsch1,
Subsch2,
GLAcc_Code1,
MISFLAG
FROM
[..\Excels\PNO\GL Account Master_Customized_NEW.xlsx]
(ooxml, embedded labels, table is Sales);

join (FACT_GL_Entry1)
//DIM_Division_Region:
LOAD HOD,
[Business Segment],
Region as Div_Region,
[Country / Division] as Div_Name ,
[Division Code] as Div_Code
FROM
[..\Excels\PNO\Master File - Region Division 09.03.16.xls]
(biff, embedded labels, table is Final$);

join (FACT_GL_Entry1)
//DIM_Division_Master:

LOAD

Div_Code,
Div_Name

FROM
[..\Qvds\NAVQVDS\DIMQVDivision.qvd]
(qvd);

FACT_GL_Entry:
load * ,
IF(Div_Code>2010 AND Div_Code < 2999,'Regulated',
IF(Div_Code>3000 AND Div_Code < 3999,'Semi Regulated','Others')) AS GL_Market,
IF(Div_Code>2010 AND Div_Code < 3999,'Export',
IF(Div_Code=5020 ,'Export',
IF(Div_Code>3000 AND Div_Code < 3999,'Export','Domestic'))) AS Division_Class

resident FACT_GL_Entry1;

DROP Table FACT_GL_Entry1;


Targets:
LOAD  //Div_Code &'-'&  num (month(([Posting Date]))) as TKye,
       //[Business Segment],
     // Region,
      Div_Code ,
Country,
// [Posting Date] as DAte,
      Target
FROM
[..\Qvds\NAVQVDS\Target.qvd]
(qvd);

[Kushal_Chawda]

which is the table in which you are facing issue while loading?

[prma7799]

am not facing any issue but in Targets: table when I select financial year, monthname or quarter then Targets are not shown right figure.

Thanks

[prma7799]

Anyone please look here..............

[tresB]

I don't see a year or month field in your code. Could you post your sample qvw (with reduced/sample data)?

[tresB]

Can't open your qvw; getting 'access denied'.

[prma7799]

tresesco‌

PFA

[tresB]

Your Target value is from Div_Code - 2180 and there is no entry for this division in the transaction table.