Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago
Solved

Budget (Target) Allocation, without relationship

Hi guys,   I've read several sources discussion about Budget allocation which there is no relation ship to the main data. Something like this -->   So I have this Target table with granular...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi  admin_xlsior ,

     

    Glad to hear the issue is resolved,  you can accept the right reply as solution, that way, other community members would benefit from the  solution.

     

    Best regards

    Amy Cai

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi admin_xlsior ,

 

Looks like an issue of relationship in the model.  I did the following

 

1. Deleted the relationship

      TimesheetTransaction --> Location

 

2. Changed the Resource --> Target to  Resource-->Location

 

Now when I select any row in table 1 , the values in table 2 relect only of resources belonging to that branch code.

 

Check it out.

 

Cheers

 

CheenuSing

 

 

admin_xlsior's avatar
admin_xlsior
Post Prodigy
7 years ago

Hi,

 

Many thanks for your help.

Actually I cannot delete the relationship between Timesheet since it is my FACT Table. However, I did make the relationship again between Location and Resources but make it inactive (to avoid ambiguity)

 

In the weirdest way, somehow it is works. 

 

Thanks again. Really appreciate this.

 

regards,

 

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi  admin_xlsior ,

     

    Glad to hear the issue is resolved,  you can accept the right reply as solution, that way, other community members would benefit from the  solution.

     

    Best regards

    Amy Cai