How to hard code a label name above column name in OBIEE?

Two changes are required to hard code a label above the column name in the report:

1) Edit the column properties in the criteria and select the custom headings option, and provide the folder name ( label in your case that you want to hardcode and show up above the column name ) and column name.
2) After creating your analysis, go to the table properties, and make sure you select the option ( As Seperate Rows ) for Display Folder & Column Headings.

P.S: This is only possible in the table view of the reports.

Until Next Post... :)