BEx Layout Issue

[Former Member]

Hi everyone,

I have a BEx Query which has Quantity Keyfigure and the user does not want to see the Keyfigure together with Unit of MEasure in the same Column. So , I used NODIM function in the Report and Added 0BASE_UOM as a seperate Characteristic in the Report.

But the thing is by default all the Keyfigures are displayed to the Right Corner of the Report and hence the Unit of measure comes up along with the characteristics and Quantity as Keyfigures in the right.

But My User wants to change the Layout to Quantity follwed by unit of measure in the Next Column. I tried to change the layout and save it as a workbook.

But as it is, the Workbook when refreshed or when we change the Variable Values , it goes back to the Query Format Layout.

I hope i am clear.Please suggest .

Regards,

Samir

[Former Member]

closed as no answer is available

[Former Member]

Hi,

By default the KFigs would be coming at the right side corner. For your requirement create a workbook by introducing the Bex item of a table and then assign the query as a data provider then adjust the columns as required and save the workbook.

By doing this your layout would be retained just as you modified.

Regards,

Mani

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Thanks Manikandan.

I was waiting for this Reply. SO, Once if I follow your Steps, then My Workbook Format will be saved permanently. I haven't worked much with WOrkbooks . SO , I am new to this.

Can you please provider me the ExactSteps. Or else let me try this on Monday and I will get back to you.

Also, i hope, when the workbook is refeshed or when the user changes the variable, the Workbook Format is retained and only the data changes.

Because right now, the workbook which I created when refreshed shows the Query Output. SO , I was just thinking how Workbooks are useful then if the Format changes once the user refreshes.

Regards,

Samir

[Former Member]

Hi Manikandan,,

I assigned my query as a DataProvider to the Workbook and then changed the layout and saved th workbook. But , once i close the Workbook and Open it again , the Format remains the same as it was. But the issue is when the User enters new variable values for the current dataa or Refreshes, the Layout changes back to Query Format.

But the Requirement is th euser wants to have the Keyfigures in the middle of the Report permanently rather than to the Right side.

Regards,

Samir

[Former Member]

Any updates

[Former Member]

Any Updates ont his issue?

Thanks and Regards,

Samir

[Former Member]

You can try making a selection in your rows, which uses a text variable to look up unit of measure. The unit of measure can then be hidden in your column.

Br,

Sonni