Column with Constant values at WEBi not coming in CSV file while downloading

[abhimanyu_sharma]

Hi Team,

When we download and save the WEBI report file as CSV format, it does not displays the columns with constant values, etc which are created at the WEBI level and which does not come directly from the query / data provider.

Is there any workaround to show the constant column in the CSV file?

Thanks,

Abhimanyu.

[sateesh_kumar1 · Accepted solution]

Hi Abhimanyu ,

Export as CSV only takes data that is from Backend only.

You can use Export as CSV Archive for your requirement.

[abhimanyu_sharma · Accepted solution]

I am not getting the option of CSV archive.

Please advise which version are you using.

[abhimanyu_sharma · Accepted solution]

is there any other workaround ?

[abhimanyu_sharma · Accepted solution]

can it be done in SAP Crystal report Enterprise ?

[Former Member · Accepted solution]

Hi Abhimanyu,

Yes, this is WEBI 4.0 constraint as of now which are likely to eb resolved from WEBI 4.1 powered by SAP HANA.

But in this situation, you can use Crystal Report for Enterprise where it can be done easily.

Simple download the report after saving in CSV format and you will get the constant columns as required.

Thanks,

Shyam Alok