do you want to join two tables from the same data base or from different data bases?
Hi Abhisek ,
Use data blending technique ,you can blend a single cube with other data sources, and there are many other data sources that you can blend. To start, you can combine data from:
- two different databases (same or different servers),
- a database and an Excel file,
- a cube and a database or Excel file, or
- multiple files.
how do we do data blending?
writing the select statement with specifying the 2 database name and table name in custom sql will work?
yes it will work .
It actually depends on what database you are using, lets say if you are using mysql there schema and database is synonymous so you can use joins in custom sql.
In other database vendors such as oracle, database have a different distinction i.e either they will be on different instance residing on the same server or on different servers and so will be considered as different data sources and hence data blending would suit.