Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one application based on link table concept I want to add new table called "New Table"
I tried to add this table but I totally struct.
Please refer below post
How to link new excel file to existing data model
Thanks
Please check Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry.
-Sathish
Try this
Create a keyfield
Div_Code &'_'& date([Posting Date],'DD/MM/YYYY') as Key_Budget, in
FACT_GL_Entry table and
Targets:
LOAD Region,
Div_Code as Div_Code_Target,
MONTHSs,
Date,
Targets,
Div_Code &'_'& date(Date,'DD/MM/YYYY') as Key_Budget
FROM
[..\Qvds\NAVQVDS\Target.qvd]
(qvd);
-Sathish
Hi Satish,
Your code is not working I have use below code to create key
Div_Code &'-'& num (month(([Posting Date]))) as TKye
when I select region America it should show me two div_code but when I select month april it display only one div_code against america.
see the attached ...
But when I select month nov then it will display proper two div_code against america...
Why this is happening can you please help me out.
Thanks
Hi,
I think you can need to consider Month or Date field in addition to div_code as a key to join the tables.
Hope this helps you.
Regards,
jagan.
Did you checked Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry for the month Apr?
-Sathish