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

OBIEE Answers - Is Based on "Result of Another Analysis" - does not catch is prompted filters

Received Response
339
Views
3
Comments
3129453
3129453 Rank 2 - Community Beginner
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

Hi,

I have a client who does not have budget for any subject area changes, but wants an answers analysis where the results are based on a filter, with the filter values being fed in from another query.

i.e.

-- Result Analysis

Select various fields

from subject area A

where value equal / in (values returned by query as below)

-- Sub Analysis

select value

from subject area B

where VariousIsPromptedFilters

If I use the standard functionality and construct the two queries and join them together then provided I have explicit filter values on the sub analysis being used to provide the filter values then it works fine.

However, my requirement is that the results of the Sub Analysis 'catch' various Prompted Filters from the dashboard I am invoking the analysis from.

This does not work as I describe it.

I have thought of setting variables but there are a prohibitively large number and type of IsPrompted filters for this to be a viable option.

Has anyone got this to work using the standard functionality??

(I know I can capture the sub-analysis and hack the SQL to make it part of the where clause, but I am loath to leave behind a complex analysis if I can get this to work using standard functionality)

Thanks for any pointers,

Robert.

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    If you place the "Sub Analysis" to the same page where the "Result analysis" placed does it ["sub analysis"] work?

    My guess is that dashboard prompt and the "sub analysis" use different logical models.

  • 3129453
    3129453 Rank 2 - Community Beginner

    Hi,

    thanks for your input, a college spotted my problem, I had the sub-query answer filter protected, removing this one check box and all is well.

    For the record the two analyses were based on different subject areas, but the prompted dimension members are shared / common / conformed.

    Robert.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Andrew. Prompted/filtered columns and prompts talk to each other over a precise match between prompt column (in the prompt) and filter column (in the analysis) where the column formula MUST match.

    So "Geo":"Country" will be a match whereas the same prompt column used again a filtered column with a derived formula like LEFT("Geo"."Country", 6) will not work at all.

    Jumping between Subject Areas makes your life harder. You *can* trick things over presentation server aliases but it's not really something I'd suggest doing.