Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OAC Filter Formatting and Loading Performance issues

Received Response
22
Views
1
Comments
Kirk Li
Kirk Li Rank 5 - Community Champion
in Oracle Analytics Forum

Hi Group,

we have 2 questions for the OAC workbook Filters:

1.Is there any formatting setting for Dashboard Filters in OAC workbook,

for example, can we set different segments in a Dashboard Filter Block?

Our purpose is like below picture:

To split Year / Quarter / Month in the same Block but in different segment, and can arrange the location as we want.

image.png

2.Also,there will be a long loading time since we open the workbook if we have many predefined filters,

any way or work-around that can save loading time?

image.png

Thanks for your guide and help!

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    You can add many dashboard filters visualizations as you want, and those blocks will give you some control on the layout.

    Inside a single dashboard filter visualization you don't have lot of controls on where to display things, they are one after the other.

    As for your performance concern, everything is based on queries. If your filter values take a while to load, it's because the queries to find them also take a while. If you look at those queries you will also find what can be done to improve them. Depending on where the data come from, you can enable some cache, or you can prepare some datasets optimized just for that, to give you the best performance on displaying the filters.