Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Business objects - Combining 2 universes into one table

Status
Not open for further replies.

Jagan1970

Programmer
Aug 24, 2005
2
CA
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.
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top