@SteveF-Oracle , well ... not sure what the mention is for: I'm not part of this thread. I will need some extra hints to guess how to read that...

Going back to the linked blog, they say this: The first argument is often based on the value of a session variable or a Case statement in reference to variables. This means that INDEXCOL generally work with a constant number as first argument, a number that is constant for the whole execution of the query. The error…

No, the syntax "Homme"."Femme"."NR" will definitely not work because it will try to find the presentation column NR in the presentation table Femme of the subject area Homme. And that's definitely not a thing that exist. @User_9YNXK , in your example, what benefits do you expect from the usage of the INDEXCOL? Because you…

Using the Semantic Modeler doesn't forbid you from download the RPD and checking if everything inside is fine by using the Admin tool. Also, usage tracking should not be "real time" by default, it's asynchronous to not slow down the process. For the normal usage tracking (I imagine it is the one about LSQL and physical SQL…

You should upgrade your OAS, 5.9 is not supported anymore because it is more than 2 years old (6.4 was the 2022 release, and for 2023 we have 7.0). No configuration exists other than what your screen shows, therefore plan an OAS upgrade (it should be a yearly task to upgrade OAS, because it is a yearly release and previous…

Edit the page, remove old objects and add them again selecting the correct object in the correct location. Or just edit the XML of the dashboard page with a search & replace if everything has been moved from folder A to folder B and there are many. Whatever is faster (and you feel more confident with).

In the RPD you generally set a sort column on the logical column you need. It's for example what you do with a column being just the month name to not sort it A-Z, you do set a sort column being the month number and this make the months to take their correct order. In your case you can do the same, because a fiscal…

@User_ZXR5B , What product (name and version) are you using? The forum mixes a very large number of different versions of two (different) products in the same category, therefore there are chances you are working with something that is behind compared to the latest set of features that OAC has. Keeping it simple: if you…

Hi, Seeing the mention "OBIEE", what version are you currently working with? 12.2.1.4, 12.2.1.3, or older than that? And also another question: by "security", what do you mean exactly? Do you want the application roles? The users, groups, application roles mapped to an application role? Do you want the policies of the…

Branden, How "big" are some of these workbooks taking time? There definitely isn't a universal scale to measure them, but as Michal pointed out, the workbook itself being a huge JSON and the DV page being "empty" and fully dynamically generated by javascript, there is clearly a possible correlation between size of the…

Looks like you can not remove the permission from permession set. I would say you shouldn't try to edit the permission set, mainly because it's a default permission set and you could need it for other things... You can create a new permission set with only the subset of policies you need, or just attach the policies…

@User_LKJ3J , At this point in time, the individual policies contained inside the va.author permission sets aren't documented. I did ask the Oracle Analytics PM for a documentation of the various policies and they did reply it didn't exist and the policies weren't even used in the code right now (which is false, the…

Hi @User_R9RRP , Taking a step back, what product (name and version) are you using? Are you working on a "classic" analysis or on DV workbook? Where does your data come from? RPD/semantic model? A dataset? All these influence the answer to your question, because there are ways to get there, but ... it depends :)

It's doable via the GUI, but it does look "less clean" and it's a bit less intuitive to achieve: These are just all equivalent from a functional point of view. Click on the first 2 (on top) "and" to make them "or", the same on the last (bottom) "and". Then click on the last "and". Finally click on the 3 "or" that should…

Hi, What version are you on? I would randomly guess some 12c version, but always better to ask (because in the past the rendering of charts changed at some point). For your 2nd approach, do not waste EVALUATE, just use CHAR(10) in the column formula directly. You will still get the same result. The logic generating the SVG…

(a piece disappeared from my post, and the forum is weirdly configured to only allow editing for 1h, because obviously one spot something needed an edit in the next 60 minutes only...) When I say: Duplicate this block, remove the conditions D and E from the first, and the conditions A, B and C from the second. You then…

Scott, The UI is a bit "strange", because it guess what you are trying to do and 99% of the time it just does something else. In your case, because the filter you look for is quite simple, (A and B and C) or (D and E) , Just do it in the XML of your analysis. Add your 5 conditions all at once to your analysis, and then go…

There can be many reasons for EVALUATE to not work... I would say that you shouldn't abuse EVALUATE, you do have some usages that could be written with native LSQL functions, for example these: EVALUATE('trunc(last_day(add_months(sysdate, -1)) +1)') EVALUATE('last_day(add_months(sysdate, -1))') Then the rest of your query…

Hi, You will get many more chances to have some useful answers if you start a new thread asking a new question. This one is an abandoned 7 years old thread migrated across a number of forums... Start a new question in https://community.oracle.com/products/oracleanalytics/categories/oac-oas and give the context (including…

Hi, The links have actually 3 places where you can define them and it's a kind of "cascading" concept. You can define them at the dashboard level, at the page level and then at the analysis level. And you can override in a lower place a setting defined in a higher place. The order is: dashboard -> page -> analysis . Check…