Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to use filter function with group by
I am trying to create a metric using filter function with a group by. I am not sure whether the filter function even works with group by in OBIEE answers. I need something like this ( Filter (#ex.XYZ Fatct group by a,b,c). my expected results is a count of all cases of yyFatct grouped by a,b,c
Answers
-
Hi,
Sorry but not sure to understand what you are after as your example isn't really OBIEE: you talk about the FILTER(.... USING ....) function?
Or you mean "filter" as a WHERE clause in a query?
0 -
Is this what you are looking for ->
0 -
yes I am talking about FILTER(.... USING ....) function? can we use group by with this function? if so do you have an example?
0 -
No, I am looking for something like this FILTER(.... USING ....)
0 -
You're not providing much usable context, so here's gerard's wiki on FILTER:
https://gerardnico.com/dat/obiee/obips/filter_function
And the official documentation:
https://docs.oracle.com/cd/E23943_01/bi.1111/e10544/appuir.htm#BIEUG847
0 -
So you want to filter a measure by some values and in the same time group the result at a different level than the one of the analysis itself? Did you try it?
Can't the same be achieved with normal analysis filtering? (sometime FILTER USING is abused for no real reason)
0 -
I finally figured it out. using this (sum(count (distinct "Fact - XXY"."# Applicants" by "XXY"."Job ")) )
0 -
What does that have to do with filtering?!
0 -
Sum if versus filter by aside; if you have access to the rpd then you can duplicate your existing count of applicants measure, call it Count of Applicants by Job, pin (copy and paste) it to the job level (detail probably) of your associated dimension Job, then the number will be invariant for each job and you will have a measure that all of your users can use with simple logic, rather than a complex once over piece of logic that only you understand...
0 -
My thought process about using filtering was not going any where so I tried a different logic. sorry if I caused any confusion
0
