Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 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
Can we write select statements in rpd
Answers
-
flag from fact table
job dimension table
job_group dimension table
0 -
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.
0 -
You mean screenshots of
keys / dimension hierarchies on your dimensions, logical table source content levels from the keys, and the underlying physical table structure.?
0 -
Yes, exactly that.
0 -
and yes, the aggregation on flag is 'count distinct'
0 -
Will the keys affect my calculation? That is if I don't have the correct key on the fact table ?
0 -
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.
0 -
Are you familiar with Intergration id in BI APPS?
0 -
"Integration Id" defines the source system. Initially introduced 2002/2003 by Siebel System hence Siebel CRM being Integration Id = 1.
0 -
Are you available to answer a follow up question?
0
