Creating Cube using Databases on Different DB Servers :
We can create a DB remote link (or Linked Server) to access DB from one database server to another DB server.
We have two different DB Servers as shown below :
We can create New Linked Server under Server Objects as shown in above screen shot.
Click on New Linked Server below pop up window will open. We need to kid in the server name.
Under security section we need to configure the login for which access is to be provided. Give credentials in Remote User and Password fields. Rest keep default settings.
Now using this we can access any DB on 10.0.0.51 from 10.0.0.121 as :
select * from [10.0.0.51].[MCEXCEL].dbo.skat
This query can be used to to create cube. We can even join any databases available on two servers for it and create the cube. This is very performance centric point with respect to EJBI.
Data Source Created with 10.0.0.121
Creating cube using 10.0.0.51 DB Link.
Using this, usage of linked cubes can be avoided to enhance the performance.
Note: This article is based on ElegantJ BI Version 4.1. This may or may not be relevant to the ElegantJ BI version you may be using.