Abstract: A system, method and computer program product for linking multidimensional data sources in a relational database using database joins are disclosed. Attributes from a join query are filtered. The attributes include characteristics and restrictions of the join query. A subset of the attributes that are relevant to the multidimensional data source are extracted. A partial join query is generated from the extracted subset of the attributes. The partial join query includes characteristics and restrictions that are relevant to the multidimensional data source. It makes use of aggregated data defined for the multidimensional data source if appropriate.

Abstract: A method and system for linking the contents of two or more at least partially time-independent tables in a multidimensional data source are disclosed. A join operation is generated for the two or more at least partially time-independent tables. The join operation includes a query instruction that is executable on the multidimensional data source, and the query instruction has at least one time attribute. A pseudo time dependency between the two or more at least partially time-independent tables is determined. A time interval for the join operation is generated based on the pseudo time dependency. The join operation is then executed using the time interval as the at least one time attribute.

Abstract: A system, method and computer program product for linking multidimensional data sources in a relational database using database joins are disclosed. Attributes from a join query are filtered. The attributes include characteristics and restrictions of the join query. A subset of the attributes that are relevant to the multidimensional data source are extracted. A partial join query is generated from the extracted subset of the attributes. The partial join query includes characteristics and restrictions that are relevant to the multidimensional data source. It makes use of aggregated data defined for the multidimensional data source if appropriate.