cancel
Showing results for 
Search instead for 
Did you mean: 

Removing # values from query output and make it single row

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Is fiscal variant assigned only from one cube.

Please check is it possible to assign fiscal var from IC1 & IC2. If not possible. Look into below doc to merge result in one line..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70dcd7b5-6a3d-2d10-c984-e835e3707...

Former Member
0 Kudos

Thanks Priya.

I was searching for this blog only...FV is forecast version.

It resolved the issue.

@Al11: Thanks for your help again. I tried to search this but could not. Will try to be more proactive in future

Thanks all for replying.

Help appreciated.

Regards,

Amandeep Sharma

Answers (2)

Answers (2)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

As mentioned by other use the option of constant selection.

Please also search the forum before posting,it has been discussed so many times.

Hope you understand it.

Regards,

A:L

former_member182470
Active Contributor
0 Kudos

Hi,

I agree with Priya's opinion. This can be acieved by Constant selection in Query designer.

http://help.sap.com/saphelp_nw70/helpdata/en/e7/5f983c1a356858e10000000a114084/content.htm

You can follow Priya's document as well.

Regards,

Suman