Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
What is the Analysis Criteria formula syntax for a corresponding attribute?
What is the correct syntax to use an attribute column from one subject area as a lookup key to return a corresponding attribute from a second subject area? Can this be done?
Example: Subject area “Employees” has attribute columns such as “Job” and “Organization”, etc. Each of these elements is defined in a ‘Company Level’ subject area with additional attributes, such as account numbers and rates. Can I effectively substitute a corresponding attribute in a [simple] listing of known employees?
I discovered the FILTER() function, but it seems to be restricted to ‘measures’(?) and I’m evidently dealing with ‘attributes’ in this situation.
Is this even the proper place to ask questions of this type? I’m brand new to using OBIEE and barely DB literate, so I’m sorry if my terminology is bogus. I don’t even know what the Analysis Criteria editor software is called.
Thanks,
Mike
Answers
-
Mike Wentz wrote:I don’t even know what the Analysis Criteria editor software is called.
"Answers" is the creation part for analysis but with "Analysis Criteria editor" you are already 100% soot-on and uber precise!
For your question: cross-Subject-Area demands are always tricky since in 99 out of 100 cases they point to a more fundamental issue of insufficient RPD design. I.e. you need model adjustments.
Taking a step back and not looking at the colunn formula but rather the analysis as a whole you can filter the whole analysis based on the results of another analysis.
In your case are the two SAs based on the same data or completely seperate? I.e. is it really sth distinct or sth you could combine easily in the RPD?
Apologies for not being very verbose this morning - @Gianni Ceresa will probably chip in and explain a bit more conceptually.
0 -
You might find a workaround by; -
creating an analysis which returns just the key values you want to filter based on; save as Analysis 'A'
creating another analysis and there using the filter based on the value on another analyses to use the values returned in 'A' to filter the corresponding area in your subject area.
Not ideal, as Christian says your problem might be indicative of wider issues with your subject areas, but depending on the scale of your need might be a way to get what you need in the short term.
See -> https://www.uc.edu/content/dam/uc/provost/docs/priorities/sis/Filtering%20Results%20Based%20on%20a%20Another%20Analysis.… if you struggle.
0 -
Hi,
I'm not sure to "see" what you try to get as final result ... (It's Monday)
You would like in an existing listing of employees coming from your "Employees" subject area display attributes like "Job" and "Organization" and that's fine as you have those attributes in the "Employees" SA. But now you would also like to show extra attributes related to "Job" and "Organization" which are coming from the "Company Level" SA? Extra attributes like "Account number" and "Rate" ?
So you try to get a listing like: Employee ID, Employee Name, Job, Organization, Account Number, Rate ?
0 -
Hi Mike,
sorry, think I was misreading your requirement, it is before my first coffee too....
If you have developer access to the rpd then you can set up a lookup table, I think this is more what you wanted; -
https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/
0
