How to hide fields while exporting to excel from WEBI 4.0

[former_member211235]

Hi Guys,

I need to export the report to excel but only few fields should be exported and the rest of the fields should be in hidden mode. Is there any option to hide fields while exporting to excel??To make it clear, if there are 15 fields, only 8 fields shoould be exported and the rest should be in hidden mode.

Any help appreciated.

Thanks & Regards,

Anila.

[sateesh_kumar1]

Hi Anila ,

We can try by placing 8 input controls one for one measure .

Create 8 variables with the required object names .Variable holds only Yes as value.

Idea here is we can provide user Yes/No to display / Not to display the value in the table.

Ask user to select yes/no values from the Input control.

Write formulas in columns , if Input control value is Yes then display column else hide it.

It would be good idea if your hiding columns are measures.

Remove option to select All values in input controls .

[former_member211235]

They need to "Export the Document" not the" Export Current Report As". It should be done dynamically without we hiding it or creating a duplicate report . Any workaround?? Any help appreciated.

Grtz

Anila.

[former_member226862]

Another option is to have a one WEBI document with two tabs:

- Develop 'Report 1' where Block1 contains grid containing 15 columns;

- Duplicate 'Report 1' and rename the tab as desired but for in this example let's assume name of the second tab is 'Report 2'

- Delete columns that you do not want to display in Excel from 'Report 2'

Both tabs render data from the same data source therefore performance impact will be minimal for having two report tabs.

To export 8 columns into Excel - switch to tab 'Report 8' and use 'Export Current Report As'.

In case you need to schedule this report and send it out as an Email attachment - create a Publication and it will allow to Email user one tab out of WEBI report that contains two tabs. If you schedule WEBI report by itself BO will always export entire document and in this case - it will include both tabs. One with 15 columns and second with 8 columns

[gleo_SRAM]

Hi Anila,

The simplest thing would be to jump into Design mode and just delete the columns you don't want exported. In doing this you are not making any permanent changes to your document, just temporary ones that you will not save (and you may not even have access rights to save any changes bar saving them to your favorites folder).

With regards

Gill

[CdnConnection]

Anita,

     You can only hide columns within WebI and when this exported to Excel, it will also be hidden.   Keep in mind if the users decides to export to CSV then they will ALL the RAW data.

Bottom line you can NOT choose to show a field in WebI and have that same field NOT export to Excel.

Regards,

Ajay

[former_member201488]

It's drastic, but you could always prevent exporting to CSV via permission.

NMG