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);

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply