Using multiple Datasources in a dataset

Hot Topic

Simple Textbox question
Frequently update and select Table Locking Problem
Foreach endless loop
TOP 2 in a Cross Join (Matrix)
SQL Server 2005 JDBC Driver Output Parameter/Result Set issue
Programmatically Data Conversion component creation
Issue with Ascii 7 files
Seek in a SQL table from Access
Saved SQL Queries
convert getdate() to string dd-mm-yyyy

SQL Server

TRANSFORM Query
Synchronising SQL CE database with SQL 2000 using Active Sync in 2003
return value of empty list
unable to send multiple persons notifications after completing one job
Caching and Dynamic Security
importacion de datos
how to create an copy of a certain record except one specific column that must be different & insert the new record in the table
Virtual Labs - Resources available?
SharePoint Add In Install Problem
Problem with Query

Using multiple Datasources in a dataset

Hi,

I have to design a tabular report where the data in all the columns of the table comes from the cube, but for one column where the data comes from the ODS table.

Could anyone please let me know if it is possible to combine the results of the query from a cube with query from an ODS table and display together in a single report

Any thoughts on this would be greatly appreciated

Thanks.

Answer this question

Using multiple Datasources in a dataset

  • Cem Uney

    No, you probably would have to write your own data extension or let the database server do this for you.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Using multiple Datasources in a dataset
Answer this question