Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

I need help on data conversion and expression

Received Response
1
Views
3
Comments
3349877
3349877 Rank 1 - Community Starter
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

there are $ and decimal values coming in the OBIEE Analysis report. Hence would like to correct data format at OBIEE RPD level. can anyone please guide how to achieve this.

Answers

  • moniquevdb-Oracle
    moniquevdb-Oracle Rank 1 - Community Starter

    Moving to !

  • Joel
    Joel Rank 8 - Analytics Strategist

    You'll need to provide a bit more detail if you require any assistance.

    Can an you provide some screenshots as a starting point?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    OBIEE is not really the place where to do data cleansing because OBIEE doesn't store data ... So the cleansing process is done again and again each time to run an analysis.

    As Joel said would also help if you give some extra pieces of information ... I assume you maybe means you get data that are received as varchar because containing the $ sign or a comma to separate decimals instead of dot and things like that and you want to translate them back to numbers?

    Post some examples of what you have and what you would like to have, but really try to move that task on the DB / sources side as at least you do it once and it's done.