Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How you are linking that ABC table? I mean on which field?
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);
which is the table in which you are facing issue while loading?
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
Anyone please look here..............
I don't see a year or month field in your code. Could you post your sample qvw (with reduced/sample data)?
Can't open your qvw; getting 'access denied'.
PFA
Your Target value is from Div_Code - 2180 and there is no entry for this division in the transaction table.