How to add empty columns between dimensions which are in Row axis report

[former_member398742]

Hi Everyone,

Just want to know is there any possible to add empty column between two dimensions which are in ROW Axis report.

Please see below report in SS and I am looking to have empty column between G and H.

Please let me know if this can possible? Thanks

Regards,

Vishu

[former_member186338 · Accepted solution]

You can't add empty column between dimensions of row axis. But you can use local members to show same dimensions members and also an empty column local member. Then you can hide original row axis.

[former_member398742 · Accepted solution]

Thanks vadim and Cecillia for clearing my doubt.

[cecilia_petersson2]

Or insert a blank member at the beginning of the column axis..

/Cecilia

[former_member252217]

Hi,

You can add Blank member from the report editor :

1. Edit Report

2. Select the row/or/axis dimension

3. Select "Blank Member" from the list (at the bottom left)

4. select the Arrow (from left to right)

5. Click ok.

The blank member should be displayed.

Other wy is to enable the "Enable member recognition" from the sheet option, then write "Blank", EPM addin should recognize the member and update it to :

= EPMOlapMemberO("[Blank Member]";"";"";"";"000;001")

There you go ... good luck