ENum values in BYOD

While exporting data in BYOD ENUMS are exporting with values (numerical) than its string values. 

All ENUMS are sitting in this table with their values and IDs, 

SRSANALYSISENUMS 

Sometimes this table doesn't update automatically you can write a small job to populate all EUMs in this table, below is the code

 public static void generateEnum(Args _args)

    {

        BIHelper::populateSRSAnalysisEnums();

    }

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

Color code the cell in Excel export

Hi Folks, 

Below is a sample code to color code your Excel cell while exporting. In this code, we will be using two assemblies as below

using OfficeOpenXml;

using OfficeOpenXml.Style; 

and standard Excel export code with a bit of creativity, 

You can be more creative by writing separate methods for major colors and calling them based on cell values. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta