greeting to u,

I have 2 cube in a same analysis database, they are:-
1) weekly cube
2) monthly cube

I need to create different cubes because they are 2 different SQL datasource which is
1) [database_week]
2) [database_month]
previously both of the cube are using same SQL database which is [database].

when i split the SQL database into 2 (i.e week and month), the weekly cube work properly but the monthly cube can't find the fact table. when i try to add new datasource, it do not allow me to do so.

May i know what is the correct way to solve the problem. thanks!