Oracle Analytics Cloud and Server

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

LTS Priority Group

Accepted answer
61
Views
2
Comments
#Mayur
#Mayur Rank 5 - Community Champion

Hello All,

I was checking the properties of the Logical tables.

There I found an option called 'Priority Group' LTS properties.

Can anyone help me to know more about it, not able to collect any data.

Thank you in advance.

#Mayur

Best Answer

  • Gianni Ceresa
    edited July 2023 Answer ✓

    The priority group of a LTS is used to define which LTS should be used when more than one can satisfy the query being performed.

    It's a numeric value used to "sort" your LTS, 0 being highest priority. It's a way to give you control of how the tool does generate a query, very useful in some special cases with complex models providing many ways to answer queries.

    It isn't a number that must be unique, you can have multiple LTS with the same priority group.

    Just don't misunderstand the concept: it isn't meant to be used to give a different number to each LTS, that's why by default they all have the same. The tool will always try to select the most optimal LTS based on the model. The priority group is a way to "influence" the selection process when you really need it.

    Don't play with it if you don't explicitly need to say that LTS B should be used first instead of LTS A and that nothing else in your model allows the tool to make that decision.

Answers