Skip to Content
0

Populating values for Drop down in Financial Year format

Sep 22, 2017 at 03:05 AM

44

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?

0
Former Member

Dear Mustafa,

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

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

1 Answer

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

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

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded