Business objects - Combining 2 universes into one table

[Jagan1970]

Hello All,
I am new to Business objects development environment.
I wanted to know how I can access data from 2 different universes into 1 table for a single report.

 

[BruceBussell]

I have found that you can create a View or Stored Procedure that combines the two data sources, if they are similar enough to allow you to do it in an SQL statement.

Or I had a Crystal 8.5 / SQL 2000 report once that needed fields from two completely different SQL 2000 Data Sources, and we had to put the Primary Data Source in the Main Report, and the Secondary Data Source in a Subreport, and then link them from Main to Subreport on two fields that had a common format, like a SQL Date Time Field. The Link Fields can be converted into common formats using Crystal Formulas, and then the formulas can be used in the Main/Sub link process.

 

[Jagan1970]

Hi Bruce,
Here is the issue I am having...my basic query looks like this..

SELECT
SERVICECALLS.SER_ID As ServiceCallID
FROM
ITSM_SERVICECALLS SERVICECALLS
WHERE
(
dbo.GET_REP_DESCRIPTION(SERVICECALLS.SER_STA_OID,@Variable('RMLanguage')) IN ('Dispatched')
)

When I drag and drop the fields into the design mode, I get the a list if IDs which is what I want. But, when I create a free hand SQL and copy the same script, for some reason, it sums up all the IDs and give me one aggregate result.
The resultant is a measure instead of a dimension.
Any reason why it happens? Thanks for all the help.
Sincerely,
Jagan