Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

We need an option to remove charts from pivot tables

Jerry CaseySep 13 2019 — edited Sep 24 2019

There doesn't seem to be a place to post ideas in the OBIEE MOSC (please correct me if that's wrong), so I'm throwing this in here.

I frequently use pivot table charts because they offer more formatting flexibility. (e.g. using hidden columns to influence sorting)

However, once you have created the view, you may want to remove the chart. The only way to do that is to go into the XML and delete the nested view - not a big deal, but the less time spent fiddling in the XML the better.

I'd like to see a "Remove chart" option in the Position drop-down:

pastedImage_0.png
This post has been answered by Shane.S on Sep 24 2019
Jump to Answer

Comments

Mike Kutz

Did you check to see if the syntax is valid already?

select
   trim( '01234567890', '0') x
from dual,
iwis

Of course I checked it. Both Oracle 19c on https://livesql.oracle.com/ and Oracle 18c on https://dbfiddle.uk/?rdbms=oracle_18&fiddle=5294d7089cb5552ca2fdf89c62e9bab4 raises the ORA-00907: missing right parenthesis error.

iwis

I have added this proposal in the "ideas" section: https://community.oracle.com/tech/developers/discussion/4479151/add-an-optional-argument-c-after-a-comma-in-the-trim-s-function/p1?new=1

Solomon Yakobson

You said you compared different database engines:
Oracle trim('0' from '01234567890')
SQL Server trim('0' from '01234567890')
MySQL trim('0' from '01234567890')
Postgres trim('0' from '01234567890')
All the above database engines have same TRIM syntax allowing leading, trailing or both (default):
TRIM([LEADING | TRAILING | BOTH] [characters] FROM string)
SY.

iwis

All the above database engines have same TRIM syntax allowing leading, trailing or both (default):
TRIM([LEADING | TRAILING | BOTH] [characters] FROM string)
Unfortunately, this syntax doesn't work in SQL Server. The select TRIM(LEADING '0' FROM '01230') query raises:

Msg 102 Level 15 State 1 Line 1
Incorrect syntax near '0'.

See: https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=9f1441351df23937f8866eb4edb32bd9

Solomon Yakobson

Right, SQL Server TRIM trims on both sides only (we must use LTRIM/RTRIM to trim on one side). But what this has to do with your proposal? Neither of database engines you listed except SQLite supports TRIM('string','characters') syntax so it should be SQLite where TRIM([LEADING | TRAILING | BOTH] [characters] FROM string) syntax should be proposed.
SY.

iwis

Neither of database engines you listed except SQLite supports TRIM('string','characters') syntax
PostgreSQL also supports it (db<>fiddle). Additionally, as I said, it looks strange that Oracle database supports LTRIM(s, c) and RTRIM(s, c), but doesn't support: TRIM(s, c).
it should be SQLite where TRIM([LEADING | TRAILING | BOTH] [characters] FROM string) syntax should be proposed.
It should be proposed in SQLite and SQL Server. I have done it here and here.

Solomon Yakobson

It should be proposed in SQLite and SQL Server. I have done it here and here.
Good, so when SQL Server & SQLite will implement it then TRIM([LEADING | TRAILING | BOTH] [characters] FROM string) will be fully portable.
SY.

1 person found this helpful
1 - 8

Post Details

Added on Sep 13 2019
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
295 views