Can we write select statements in rpd

ForSly

flag from fact table

job dimension table

job_group  dimension table

Robert Angel

Okay, assuming the aggregation on flag is 'count distinct' (tell me if not) then your only other problem could the keys / dimension hierarchies on your dimensions, logical table source content levels from the keys, and the underlying physical table structure.

Can you show screenshots of these elements and I can assist further from there, but as I am alluding to there must be something inherently wrong, what you are trying to do is a straight forward requirement for OBIEE IF you have the modelling correct.

ForSly

You mean screenshots of

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

Robert Angel

Yes, exactly that.

ForSly

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

ForSly

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

Robert Angel

Yes.

Your keys tell OBIEE the granularity of all attributes in a dimensìon hierarchy level. The content levels tell OBIEE the granularity of how fact joins to dimensions, as controlled by the content levels set on both sides logical table sources.

The current selection of keys and setting of content levels is of critical importance.

ForSly

Are you familiar with Intergration id in BI APPS?

[Deleted User]

"Integration Id" defines the source system. Initially introduced 2002/2003 by Siebel System hence Siebel CRM being Integration Id = 1.

ForSly

Are you available to answer a follow up question?