case when "AAA - "." Name" IN('SelectION' ,' Hired') and "BBB"."Pattern" ="BBB"."Pattern" then 1 end. I have modified it is that clear enough to get reponse? what did you mean by this (string are written with ', not " .)

How can I use the BIN logic to achieve my results?

Yes I have rpd access.

Good suggestion only problem is I didn't know how to implement that at the database level hence opted for analysis side and it appears as though I cant get it to pull the correct results

Hi Robert, Sorry was off for a week or so. Are still available to answer my question if I supplied the above info?

I actually already posted it on a new thread , its the one with attachment

Fortunately or unfortunately depending on how you look at it, we did not use OBI rpd that comes with the package but rather created own rpd and used the ODI tool that comes with the OBIA for ETL, so really I am not using the rpd that comes with OBIA does that make it easy then ?

I will supply all of the info, please tell me how you want the logical tables / mappings be captured and uploaded up here? also will it help if I shared the starting point of the view that I am using to create the final table?

That was not the case, I liked your suggestion only part is how will I get the DDL 's for all the tables involved? please tell me and I will supply all of that information right now

Are you available to answer a follow up question?

Are you familiar with Intergration id in BI APPS?

Will the keys affect my calculation? That is if I don't have the correct key on the fact table ?

and yes, the aggregation on flag is 'count distinct'

You mean screenshots of keys / dimension hierarchies on your dimensions, logical table source content levels from the keys, and the underlying physical table structure.?

flag from fact table job dimension table job_group dimension table

What question I didn't answer ? I will be more than happy to answer any question that can potentially point me in the right direction

This is correct (select count distinct flag, job, job_group from whatever where job = 12345 Group by job, job_group) and basically I am wanting or trying to figure out how I can get my counts in the rpd / analysis by using something like this.

That's correct

Yes, my rpd is modeled as per business requirements. and my query is on the database is "SELECT count distinct A_FLAG, Number FROM B_FACT" I am using distinct to eliminate extra rows / duplicates. in the rpd I just set aggregation rule for A_FLAG as count distinct but I don't have an option or a way to group it by what I…

unless I am missing something you can aggregate the count of 1 based on say employee or job right?