Hi experts,
I have a scenario in my source system i have a table which contains two columns
Program ---Project
AAA1-------1
AAA1----
2
AAA1----
3
We can assign multiple projects to a single program and their is no standard datasource available for it in Cprojects in PLM so i have made a generic datasource on this table and pulling this data to a infoobject called ZPROJECT -(which is having program as an attribute) and in BI my cube has the Project so iam also including the zproject and send the data to it also from project and pulling the program in to cube.
till then its fine
but the problem is that project keep constantly change from one program to another and also some time they are unassigned from the program so automatically this record gets disappeared from the source table.
So in my next load i wont get this record but becoz i have already loaded this data its remaining in my ZPROJECT Infoobject and its comes whether the project is currently assigned or not.
How to solve this issue.
thanks and regards
Sreedhar