Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Financial Analyzer Link to Excel (2002)
Oracle Financial Analyzer Link to Excel [message #645081] Wed, 25 November 2015 20:08 Go to next message
Excel-Access
Messages: 3
Registered: November 2015
Junior Member
Not sure if you can provide your expert opinion on a similar change - please see below

In cell E9 I have X0671

Current the formula in G9 is =xpDimDESC("REPCOL",E9,1)

and this produces Period Quarter 3 Forecast

I would really like a way to instead call this Period Budget

I tried the following and it failed miserably giving me #VALUE!

=TEXT(--xpDimDESC("REPCOL",E9,1), "Period Budget")

I welcome any suggestion to modifying the formula
Re: Oracle Financial Analyzer Link to Excel [message #645082 is a reply to message #645081] Wed, 25 November 2015 23:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web
Senior Member
Hi,

Welcome to the forum!

Please read and follow the OraFAQ Forum Guide and How to use [code] tags.

Is your question related to SQL or PL/SQL? It seems you are asking Microsoft Excel related question.
Re: Oracle Financial Analyzer Link to Excel [message #645086 is a reply to message #645082] Thu, 26 November 2015 00:56 Go to previous messageGo to next message
Excel-Access
Messages: 3
Registered: November 2015
Junior Member
My question is relating to XSA - OFA linked to Excel to build custom reports
Re: Oracle Financial Analyzer Link to Excel [message #645087 is a reply to message #645086] Thu, 26 November 2015 00:57 Go to previous message
Excel-Access
Messages: 3
Registered: November 2015
Junior Member
Can you please advise which area I should post this then? Thanks
Previous Topic: Enable Enterprise Manager on EBS Database
Next Topic: Requisition Import Process- Release Approval
Goto Forum:
  


Current Time: Fri Jan 22 23:26:00 CST 2021