Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove decimal places in OBI Dynamic Repository Variable

Ebin CherianJan 16 2018 — edited Feb 22 2018

Hi All,

Oracle Business Intelligence 12.2.1.1.0

We have created repository variables for Fiscal Year, Previous fiscal year etc. Query to populate this variables return the correct result in database without decimal place. But when I execute the same in OBI RPD initblock, it appends a decimal place to the result. Also When we try to call this repository variable in the column heading in answers, it has a decimal place appended to it.

How can I format the variable to remove decimal places ? Also is it possible to do subtract an year from this variable in the column header... I would like to do Previous Fiscal Year -1 ?

Thanks

Ebin

pastedImage_4.png
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2018
Added on Jan 16 2018
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
7 comments
420 views