Some extra Performancy knowhows

[kohesco]

Some lessons learned I wanted to share with you...

Design Studio 1.3

Sap Hana 1.0 SP7

• Adding the same Datasouce or copying the first one makes no difference.
• Both scenarios  have the same runtime

Initialsetupquery(Column:Measure,Rows:Dimension) DS_1.loaddatasource(); DS_1.setFilter   (Dimension,Value); Measure=DS_1.getDataAsString("Ordered", {});	Initialsetupquery:(Column:Measure,Rows:/) DS_1.loaddatasource(); DS_1.setFilter (Dimension,Value); Measure=DS_1.getDataAsString("Ordered", {}); DS_1.MoveDimensionToRows(Dimension);
DS_1.setFilterExt("Year",var_end);	If (var_end != ””){ DS_1.setFilterExt("Year",var_end); }

• Make use of the Global Script Variables, set the value for the GSV once and reuse them

var_end = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat, 0,4);

DS_1.setFilterExt("Year",var_end);

TILE_1_SUBTITLE.setText(var_end);

• Get Data once and filter in later stages.

var var_range = var_start + " - " + var_prev;

DS_6.loadDataSource();

Get Data from DS_6 over Multiple years

DS_6.setFilterExt(("Year", var_range);

DS_6.setFilterExt("Vendor", var_vendor);

DS_6.setFilterExt("VendorName",var_name);

DS_6.setFilterExt("VATRegistration",var_vat);

Filter DS_6 in a later stage for one year

g_vim=(DS_6.getDataAsString("Counter", {"Year": var_prev}));

TILE_6_VALUE.setText(g_vim);

TILE_DETAILS_6_VALUE.setText(g_vim);

• Set Dynamic variables on startup

var_end = Convert.subString(APPLICATION.getInfo().dateNowInternalFormat,0,4);

var_prev = Convert.floatToString((Convert.stringToFloat(var_end)) - 1);

var_prev = Convert.subString(var_prev,0,4);

var_start=Convert.subString(Convert.floatToString((Convert.stringToFloat(var_prev)) - 4),0,4);

var var_range = var_start + " - " + var_prev;

• Merged variables does not work on hana when coping with different views.  Workaround =

        Global script varibale

             var_vendor string false false

        on startup

             var_vendor=DS_1.getVariableValueExt("HANA_VARIABLE_VENDOR");

             APPLICATION.doBackgroundProcessing();

        on background

             DS_3.setFilterExt("Vendor", var_vendor);