Skip to Content

Populating values for Drop down in Financial Year format

Sep 22, 2017 at 03:05 AM


avatar image
Former Member

I need to display financial Year in the drop down I,e (2017-18) format. for the backend we are using as BW.we are having Year and year month dimensions maintained in the backend.I tried several option but didn't get desired result set

10 |10000 characters needed characters left characters exceeded

Does the Year dimension in your BW system represent the Calendar Year or the Financial Year?

Former Member

Dear Mustafa,

Thanks for updates.In the back end bex query Year column is present i,e 2017, 2016,205.....etc

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mustafa Bensan Sep 25, 2017 at 12:14 PM

Hi Afzal,

You can try the following code to achieve the desired result:

var myYears = DS_1.getMembers(<Year Dimension>, 10);
var yearText = "";
var yearNum = 0;

myYears.forEach(function(year, index) {

  yearNum = Convert.stringToInt(year.internalKey);  
  yearText = (yearNum - 1) + "-" + year.internalKey.substring(2);   
  DROPDOWN_1.addItem(yearNum + "", yearText); 



10 |10000 characters needed characters left characters exceeded