Link new table with existing data model

[prma7799]

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

[sathishkumar_go]

Please check Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry.

-Sathish

[sathishkumar_go]

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

[prma7799]

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

[jagan]

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.

[sathishkumar_go]

Did you checked Division code 2050 is available in the Dim_DivisionMaster and Fact_GL_Entry for the month Apr?

-Sathish