Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: I attempted to write a query using CTEs and subqueries, similar to those involving temporary tables
@User_PWOBY , You mixed up a number of languages… Are you sure the field where you are entering the query expects SQL? If it does expect LSQL, that's a different language, and it doesn't ha…1 -
Re: Is there a LOOKUP like function in OAC for dynamic calculations inside a table visual?
Hi, There isn't a LOOKUP function (well, technically you could achieve something similar with FILTER(… USING …) if you really want something close to LOOKUP), but you don't need it. You hav…1 -
Re: Need listing of users from OAS
I don't have a 5.9 available, but let's assume that the "Users and Roles" page was already working the same as it is working now (it probably was very similar). The list of users …1 -
Re: Why would MAX( ... BY ... ) give different results for different users?
Hi, Did you look at the generated queries? And while there also at the LSQL query? If the LSQL queries between your test and her test are exactly the same, then the physical query should give you ans…1 -
Re: What does the 'Single Item Legend' feature do?
Hi, I don't know if there is a formal description somewhere. What that option does is a special flag to handle the case when the legend would contain a single item. When you have 2+ values in a …1
