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

automatically exclude a new column from a pivot table

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

Hi,

I have some reports that have several pivot tables. If I add a new column to one of these reports it gets automatically included in the pivot table. This can cause an error as too much data may be returned for the pivot table to be created.  I cant exclude the column using drag and drop because the results screen hasn't been created due to the error. Sometimes this means re-creating the entire report just because someone wanted a new column to appear only in the CSV export.

So my question is - how can I exclude a column before the results are generated, so that I don't get an error  ?

John

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    If you have reports with tables already created and you just want to make sure that new columns are not added to the existing views, you can do that in the analysis properties (see image below).

    analysis properties.png

  • 3163118
    3163118 Rank 1 - Community Starter

    Thank you very much - that has worked fine - I wish I had known about it before :-)

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    It would be great if you can close the thread as answered. Will help future users of this forum..