Removing # values from query output and make it single row

Hi All,

I have 2 cubes in Multiprovider. Data is as below:

Actuals Cube : IC1

GLAccount      ActualAmount

GL1                  1000

Forecast Cube : IC2

GLAccount      ForecastlAmount  ForcastVersion

GL1                2000           01

When I write a query on this MP which FV also in the drill down, it displays data as below:

GLAccount           FV           ForecastAmount    ActualsAmount

GL1                 01                  2000            ...
GL1                  #                  .....            1000

Which is correct, but users don't want to see data in this way. They want to see everything in one record as below:

GLAccount           FV            ForecastAmount    ActualsAmount

GL1                 01                  2000            1000

I am not using Bex ( Excel version), so cannot use formulas etc.

Is there any setting to do this at query level? or any other way-out?

I read how to do this in one blog in SDN sometimes ago, but unfortunately cannot find that blog now.

Please help me.

Regards

Amandeep Sharma