Welcome to the Oracle Analytics Community

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

Geraud Andreux Rank 3 - Community Apprentice

Comments

  • Hello, I suspect that the only reason this idea doesn't have a 1000 upvotes is that it's not been seen by many, and it's a pity. I would upvote it 1000 times if I could :-) We asked this question also, and received the answer that: 1 - you can access in read only by making a SQL query in BIP. Well, technically true, but…
  • Ho, and little update: following the approach I detailed above: 1 - you don't have to use the rtf auto-generate layout, you can also use the "guide me" approach and put the columns where you want. 2 - if you want delimiters others than the comma, in the properties of the data model be sure to NOT tick the box "Enable CSV…
  • Hello, 100% agreed! We found that you don't need to create an eText, which is horrendous, but that using the default RTF template works as well. The rtf layout is created, then you can go in the "view as a list" mode, and select only CSV as an output option. That nullifies the RTF, as then the system will ignore the RTF…
  • Hello, definitely! If it could at least indicate the line number of the issue, that would help. Personally I've found a partial workaround by using a local "Oracle SQL Developer" installation (free from oracle), that I use as a SQL editor. It cannot connect to the database, but at least it will underline some of the most…