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
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!