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.
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.
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 ?
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; -