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

Learning - OTBI or BIP tables that can be used to list all rulesets tied to Learning initiatives

mjime

Are there tables or subject area that can be used to list all OTBI-based rulesets tied to a learning initiative?

Find more posts tagged with

Learning

Accepted answers

All comments

Bhaskar Konar

Hi @mjime,

Please take a look into the following post which might be useful.

Report that shows what OBTI is attached to an Initiative — Cloud Customer Connect

Hope this help.

Thank you.

mjime

thank you! which of the tables in the post you shared have OTBI-based ruleset information? it seems like it contains learning initiative data only.

MandeepGupta

Hi,

Please check WLF_BI_ANALYSIS_DESTINATIONS table.

Below should be useful as well:

Can you Delete Analysis previously used in Learn to assign Courses — Cloud Customer Connect

Try the query from below link:

How to find out the name of "Analysis Report Criteria" used during Initiative creation? — Cloud Customer Connect

Thanks.

Brendan T

Have a look at WLP_ASSIGNMENT_RULES

and for learning initiatives and rulesets have a look at WLF_LEARNING_ITEMS_F and WLF_LEARNING_ITEMS_F_TL

mjime

Hello Mandeep - Is there a related table to WLF_BI_ANALYSIS_DESTINATIONS that can also give each filters or conditions used in the Ruleset?

MandeepGupta

You mean the criteria used in OTBI analysis?

Brendan T

You might need to get the admin to give you a copy of the XML in the catalog to search for the filter

mjime

yes. is there a table that holds that too?

MandeepGupta

Hi @mjime

No, its not possible. Only you can get the report path.

If this answers your query, please mark the relevant answers as accepted and close the thread.

Thanks.

mjime

and that report path can be mapped to the initiatives, correct?

MandeepGupta

Yes.