nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Advanced Tab - Disable Logical Table Source (LTS) for a given analysis

PeakIndicators_Alastair

Hello - Can anyone advise if you can exclude a given LTS in the advanced tab in a given analysis - Im sure i've seen some secret undocumented reference to it in the past.

Thanks!

Find more posts tagged with

Accepted answers

PeakIndicators_Alastair

just to close this off, I managed to accomplish what I needed , fortunately LTS was tied to a specific database so this worked :

SET VARIABLE DISABLE_CACHE_HIT=1, INACTIVE_SCHEMAS='"<RPD Phy DB Name>".."<RPD Phys Schema Name"';

All comments

Federico Venturin - Oracle

Hi @PeakIndicators_Alastair,

I don't know how to do it using the Advanced tab. But you can achieve the desired result by adding a dummy column to the Criteria tab, which is not present in the LTS that you want to exclude. Of course, you have to define the dummy columns for each LTS that you want to keep in the RPD, and eventually hide them from the visualizations.

PeakIndicators_Alastair

just to close this off, I managed to accomplish what I needed , fortunately LTS was tied to a specific database so this worked :

SET VARIABLE DISABLE_CACHE_HIT=1, INACTIVE_SCHEMAS='"<RPD Phy DB Name>".."<RPD Phys Schema Name"';

PeakIndicators_Alastair

Thanks for the comment, I was limited to the Presentation services only in this case