Forum Stats

  • 3,752,196 Users
  • 2,250,468 Discussions
  • 7,867,747 Comments

Discussions

Report Script in Essbase

revpree
revpree Member Posts: 89 Blue Ribbon
edited Sep 30, 2020 9:48AM in Planning and Budgeting

Hi all,

I have a Date type member in my BSO cube and i need to export it along with other other members.

Im able to do so using data export option in calc script whereas in reportscript it is getting exported as some random number instead of in date format.

Kindly assist on how it can be exported in dateformat using report script.

<PAGE(Scenario)

ACT

<COLUMN(Time)

&CurrMonth

<ROW (Entity, Product, Account)

<DESCENDANTS Entity

<CHILDREN Product

{ DECIMAL 1

WIDTH 9

SUPBRACKETS

SUPCOMMA

MISSINGTEXT " "

UNDERSCORECHAR " "

SUPHEADING 

NOINDENTGEN 

SUPFEED 

ROWREPEAT

}

<DESCENDANTS Account

{DATEFORMAT "FinalDate" }


"FinalDate" is member name in account dimension of type date.