Bex Query Add Empty columns

[Former Member]

Hi,

Im new creating query's in Bex and I need to create an accounts report and the use it in Excel, the problem is that they want me to leave empty columns between the date columns. Is there a way to do this?

Thanks in advance.

[former_member207028 · Accepted solution]

Hi,

Create no. of Keyfigures need to have as empty coloumns.

for ex: two empty columns need to be in between date columns

create 2 keyfigures with integer data type.

add these two keyfigure in cube / Multiprovider. do not map these keyfigures in routines / Transformations.

use these feyfigures in between date keyfigures in columns of Query designer.

hope this helps

Regards

Daya Sagar

[Former Member · Accepted solution]

Thanks Daya, I will check it and let you know.

[Former Member]

sure u can do this at query design level

lets say ur keyfigures are in columns

click on keyfigure structure

select new formulae

in that formulae just create a junk formulae so that result is 0 or not displayed

that way u can copy that in between columns.

let s say ur keyfigures are in rows and chars in columns.

then in columns click new structure

similarly create formulaes, twice

so uhave 2 options.

u can do that without going to backend.

[Former Member]

Thanks kartikey , I created the formula, how can I set to display nothing instead of 0?

[Former Member]

This can be done using the properties of the formula.

Set in calculate results, show single value as nothing and the result as well the same way.

Naveen.A

[former_member205352]

Go to Query properties in Query Designer.

There you have option Display zero as choose dont display.

Hope this helps.

[Former Member]

Thanks, your are the great!