You do realise that integer values don't have decimal precision? That's the definition of an integer.

to_number is a function that takes either a DATE datatype or a VARCHAR2 datatype and returns a number from it. By supplying a numeric datatype it will first implicitly convert it to a string (varchar2) and then to a NUMBER. To avoid implicit conversion, you would be better to use the cast function e.g. CAST(columnname AS…

So which part do you not understand? http://www.oracle.com/webfolder/technetwork/OracleAnalyticStore/index.html We are currently down for maintenance! Sorry for the inconvenience but we’re performing some maintenance at the moment. Please contact Oracle PM with any questionsOracle employees click here — Oracle Analytics…

Moderator Note: Do NOT start duplicate threads for the same question - Closing this thread.

Moderator Note: Question moved to the OBIEE space as it's not related to SQL or PL/SQL where you posted.

*Moderator Note: Moved to OBIEE forum for better question alignment

Please do not duplicate your posts on the community - locking this thread.

*Moderator Note: Closing this thread.

*** Moderator Note: The "Community Feedback (No Product Questions)" space is, as the title suggests, for feedback and issues about this community platform itself, and is NOT for product related questions. OBIEE is a product, so your question does not belong in that space. I've now moved your question over to the OBIEE…

*** Moderator Note: Question now moved to the OBIEE product space. The Getting Started space, where you originally posted this questions, is a great place to introduce yourself and learn about using the Developer Community platform, but is not a suitable place to ask product specific questions, as you are unlikely to find…

Thanks Gianni, I've reinstated the thread title and content as a copy of the duplicate thread, and will now lock this one as it's a duplicate.

*** Moderator Note: In addition to Christian correctly pointing out that it is bad etiquette to essentially destroy the content and context of a thread, the admin consider this type of behaviour an abuse of the community. Do NOT do this in future. If you do, your account may be terminated. ***

*** Moderator Note @user652652 As others have indicated, it's good community etiquette to respond to, and reward, people who have answered your question threads. Please see the FAQ: Respond appropriately when your question has been addressedProper etiquette is that the poster should provide feedback to those who provide…

*** Moderator Note: As others have mentioned, this is not the "official" oracle help channel, so the problem appears to be that you don't know where to post for official help. Official support can be done through support.oracle.com which is the My Oracle Support (MOS) platform rather than the OTN platform. There you can…

*** Moderator Note: As already indicated by previous responses, saying you want something as early as possible is considered rude on the public community where members give their own time to volunteer to help, whilst doing their own jobs. If you need urgent assistance, you should contact Oracle Support (MOS) via…

*** Moderator note: I've now moved your question over to the OBIEE space so that people who are experts in that product can help you - the Getting Started space (where you originally posted) is for learning about using the OTN community. 

@3027402 *** moderator note *** Please do not remove the contents of your question when people have been good enough to respond to you. It makes the thread meaningless and disrupts the content of the community. Members who continually do this type of thing are considered to be abusing the community and may have their…

*Moderator Note* - Now moved 😉

As mentioned on your other thread: DMR 7.9.6.4 data model in excel please. List of all tables of financials source ebs in excel MOS Content cannot be shared on the public community. Christian has given you the link to the MOS content you require. *locking this thread*

As Christian indicates, sharing of such content is not permissible on the public community. Please seek the information you require from My Oracle Support (MOS), for which you should have a support contract for such products/content through your company. *Locking this thread*