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 12 c with datasource Essbase 11

Received Response
1
Views
8
Comments
User_SOR8N
User_SOR8N Rank 2 - Community Beginner
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

Hi!

I have a problem, When a column in the excluded section column appears the following error:

pastedImage_0.png

This happens when the column is a filter

pastedImage_1.png

When placing the column in the view works correctly without filter:

pastedImage_3.png

¿it is possible to filter columns in a view with Essbase?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Of course it's possible to have filters when building an analysis on top of Essbase.

    It seems you are testing 2 completely opposite cases: does not work when you have a filter on a column and you add it to the exclude part of a view, works fine when you do not filter the column and keep it in the visible columns of your view?

    Isn't the issue just the filter?

    Did you check the generated MDX to see what it looks like?

    What is the value of your @paisab variable? Single value or multiple values? What kind of values are they?

  • User_SOR8N
    User_SOR8N Rank 2 - Community Beginner

    Hi,

    I have a Dashboard with the next filters, I assigned a presentation variable to each filter País : @paisab

    pastedImage_0.png

    My report is grouped by period:

    pastedImage_2.png

    When I select Pais, syntax error:

    pastedImage_3.png

    When I select Pais:

    pastedImage_4.png

    In my reports Test with variable filter and Is prompt:

    pastedImage_5.png

    pastedImage_6.png

    In the two  cases the error is generated. Only works having the field in the graph:

    pastedImage_7.png

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    Not exactly like this but I have seen similar issue with 12c where the same report works in 11.1.1.7. I did work around by hiding the column in column properties. 

    pastedImage_0.png

  • User_SOR8N
    User_SOR8N Rank 2 - Community Beginner

    when are various values:

    pastedImage_0.png

    hide:

    pastedImage_1.png

    This is not functional

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    What is not working, Can you please little more specific? I can see with hide and without hide it worked same way.

  • User_SOR8N
    User_SOR8N Rank 2 - Community Beginner

    My graph is by Periodo , i dont want see Entidad, but i want filter by Entidad

  • User_SOR8N
    User_SOR8N Rank 2 - Community Beginner

    Solved!

    Thanks.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3416402 wrote:Solved!Thanks.

    Sorry but .... No, that's not how it works.

    A community forum is a place where people share things, so great for you that you got a solution, but you don't just come back with a "solved". You share you solution so that if somebody else has the same issue he will find it. The concept being give and take, not just take.