Is it possible to combine multiple data sources or use multiple data sources in one report? I need to create a report using data from 2 different data sources. Any help would be greatly appreciated.

Thanks

Btizz welcome to the Forum. Please go into your profile and add a signature with what version of WebFocus you are using. As for your question...as long as you have masters for the data and a common field..you can use JOIN to combine your data. Do some research on JOIN.

Thank you for your help, Prarie. I tired your solution but ran into this error when I executed the report.

(FOC11207) ERROR IN THE QUERY:
(FOC11237) MDX SEGMENT MUST BE THE ONLY SEGMENT IN FILE

Btizz
To give you some help on this it would be nice if you post something more than only the error message.

To answer your basic question, yes it is possible but it is sometimes not the right way to just join two or more tables from different platforms, since the performance will be awful.

what I try to do is get the required data from the various platforms and put them in a holdfile . Then create the join or match over these holdfiles and build the report.

In this case, can you run a simple report on the required data from only one platform?

Maybe show us the fex and/or the masters.

The Master files are too long to display on here. Both were created from 2 BW queries

Here is the fex file

JOIN
Q_BPO_DUMMORE_MMDOX_Q003B.Q_BPO_DUMMORE_MMDOX_Q003B.COMPANY_CODE_LEVEL_01 IN
Q_BPO_DUMMORE_MMDOX_Q003B TO MULTIPLE
Q_BPO_DUMDB2A_MMDOX_QS002B.Q_BPO_DUMDB2A_MMDOX_QS002B.COMPANY_CODE_LEVEL_01
IN Q_BPO_DUMDB2A_MMDOX_QS002B AS J0
END
TABLE FILE Q_BPO_DUMMORE_MMDOX_Q003B
SUM
OPEN_QTY04_2007
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
RIGHTGAP=0.125000,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

I think the problem lays before the join.

the master describes a multisegment file and that causes the problem in the join

BTW what is BW query?

Thanks for your help so far, Frank

A BW query is a query taken from Business Warehouse

FILENAME=Q_BPO_DUMDB2A_MMDOX_QS002B, SUFFIX=BWBAPI , $
SEGMENT=Q_BPO_DUMDB2A_MMDOX_QS002B, SEGTYPE=SO, $

FILENAME=Q_BPO_DUMMORE_MMDOX_Q003B, SUFFIX=BWBAPI , $
SEGMENT=Q_BPO_DUMMORE_MMDOX_Q003B, SEGTYPE=SO, $

I think the BW structure has already many dimensions in it and I think you can not just join two multidimensional cubes as if it is a normal database.
But this is something for the real specialists.
Did you contact your local support department?