Welcome to the Oracle Analytics Community

Home› FPonte› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FPonte Rank 6 - Analytics Lead

Comments

  • Hi Donald. No worries. It was an interesting learning. Never thought about using Function on WITH clause in BIP. An old workmate once told me while running SQL on different tools. "We have two pieces of software talking with the database. They make not talk the same way all the time" Cheers Fernando.
    in Java.sql.SQLException: Invalid column index Comment by FPonte November 2019
  • Hi Donald. The only weird thing I found in the engine log was. [dv id:1293682950]Validation code:DM08_COLUMN_ALIAS_LENGTH[dv id:1293682950]Error Type:WARNING[dv id:1293682950]Description:Selected column length name exceeds the limit of 15. Length of the column name must not be more than 15 chars. Use short alias for column…
    in Java.sql.SQLException: Invalid column index Comment by FPonte November 2019
  • I'm in NZ so I change my Timezone to Sydney. The first image is the result I got.
    in User Time-Zone in BI Publisher Excel Template Comment by FPonte June 2020
  • Hi Alberto. This is always tricky to setup. I used this kind of report to check the proper configuration that worked for my users. You my try on your setup. Also check the DM column configuration and play with User Preferences. I think you need to logoff and logon again for each time you change the User Preferences. Hope…
    in User Time-Zone in BI Publisher Excel Template Comment by FPonte June 2020
  • Hi Jonathan. As far as I know that is not possible. https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-AF9605D4-56E5-4EEF-AEC2-559A103091C0.htm#BIPRD2211 Cheers Fernando.
    in How to pick mulitple fields into table box when buidling report using data model? Comment by FPonte May 2020
  • Hi Niketa. Thanks for your reply. Based on your previous comments that the process works fine when you don't zip, I think you have a bug in your hands (unless someone else has another view). It will be good to open a SR for Oracle Support. Cheers Fernando
    in BIP compress output prior delivery Comment by FPonte April 2020
  • I'm really sorry Niketa. I asked about the wrong parameter in the bursting definition. I mean to ask PARAMETER5 (Remote File Name) as you are sending the data to FTP right? Cheers Fernando
    in BIP compress output prior delivery Comment by FPonte April 2020
  • Hi Niketa. On your bursting query. How is PARAMETER2 (File Name) defined? Cheers Fernando
    in BIP compress output prior delivery Comment by FPonte April 2020
  • Hi Jonathan. Any chances to ask for that permission (enable EVALUATE)? Here another example with Regular Expression. https://gerardnico.com/dat/obiee/obis/regexp_evaluate Or another way would be to sort this in the database (or in the repository) creating a new attribute there.Not sure if possible as I don't know how are…
    in Extract first sets of integer from entries Comment by FPonte March 2020
  • Hi Jonathan. Try Evaluate. Something like this but you will need to work out how to build it to fit your purpose. EVALUATE('REGEXP_REPLACE(%1,''^[A-Z]+'',''*'')' as char ,<you Dimension Level here>) Gerardnico still useful on this case as you are on 11g. https://gerardnico.com/dat/obiee/obis/logical_sql/evaluate Regards.…
    in Extract first sets of integer from entries Comment by FPonte March 2020