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
-
re: for example see ->
https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/obiee-obe-167892.html
0 -
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 would want in order to get a correct result.
0 -
Sincere thanks for providing company / moral support on this one...
0 -
Can you tell me where the 3 elements site i.e.
Flag (1 / 0) = fact
Employee = dimension
Job = dimension
Correct me if I am incorrect please as to the source of the three?
0 -
That's correct
0 -
re: grouping
If your attributes are on dimensions then they ALWAYS group - unless you are using a non-aggregating measure!!
So if your measure is count distinct 1, and you pull in Job and Job Group and you filter on the job then you get the equivalent of; -
select count distinct flag, job, job_group
from whatever
where job = 12345
Group by
job, job_group
This is true unless there is something badly wrong with your rpd - which is mine and @Gianni Ceresa suspicion.
Note the above assumes count distinct flag is measure in your fact table and everything else is in dimensions.
0 -
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.
0 -
It should happen automatically just by pulling the measure / dimension attributes into the analysis - IF you have the attributes in dimensions AND the measures in the FACT folder - if not then there is something badly wrong with your subject area and you really need to redevelop it, it is just plain wrong.
Not sure how else I can say this, or help you, as you continually do not answer my questions on the underlying structure of your subject area.
0 -
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
0 -
Which of; -
flag
job
job_group
Come from a fact table, which from a dimension?
0
