Welcome to the Oracle Analytics Community

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

nandoo007 Rank 2 - Community Beginner

Comments

  • May be you should consider using "Analytics Classic" if you are on cloud, which is OBIEE 12c on Cloud. OR OBIEE 11 or 12c version on-premise. where you will have more flexibility on the exports Regards Mahesh
  • Hi Bhargav, Looks like there is no option to export the pivot table in to Excel format. You can only export in CSV, PDF , PPT , ODV package formats. The question is - what is that you want to do by exporting data to excel. The tool ODV is equipped with capabilities that allows users to analyse data with in the tool. What…
  • Hi, I am guessing your source is a file ie not connected to a database. If the data source is file - Oracle docs clearly mentions that you can only use .xlsx or CSV or Text files. In case of Excel files that data source should have - - content in data-oriented way, no pivot tables - must have a regular layout with no gaps…
  • I agree with Fernando, that there is not OOTB functionality available with in DVD. Other option is to use Data Flow and create a new data set and store it in the database and use it. Regards Mahesh
  • HI Suresh, ++Gianni, Christian. The steps you need to follow: Develop RPD Deploy RPD Enterprise Manager -> Business Intelligence -> Coreapplication -> Deployment tab Lock n Edit Config Chosse your RPD Apply Activate Changes Restart BI Server ( from Availability Tab) OBIEE Docmentation is very concise with all the required…
  • Thanks John. Did not look closely enough in that document earlier. Thanks for pointing me to that. Regards