Oracle Analytics Forum

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

Filter using in expression and go to detail analyzes

Question
1
Views
0
Comments
Alex Sharkov
Alex Sharkov Rank 5 - Community Champion
edited Aug 13, 2024 7:12PM in Oracle Analytics Forum

Hi all

I have some detail table ex.  <MyAction>

There is some ActionType - is attr of <MyAction>

When i create AgregatedAnaliz i do:

<month> <count of ActionType 2 and 3> <count of ActionType 3 and 4>

Just using filter i do:

someMeasure1:  filter(<some measure> using ActionType   in (2,3))

someMeasure2:  filter(<some measure> using ActionType   in (3,4))

..

and so on

Work nice

I whant to go by Action from agregated analiz to  Detail table of  <MyAction> with automaticaly filter:  ActionType   in (2,3)

Is it possible?

Of course i set  filter on DetailedAnaliz -  ActionType 

But it not working