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…

@EzequielC-Oracle , To be fair in this kind of situation, when the question is in the wrong category, the OP should not be told to post again the same question somewhere else (because that's double posting, which is one of the many rules of any forum: double posting is forbidden). And not only there is a double post, but a…

Please do not double post. You already asked the same: https://community.oracle.com/products/oracleanalytics/discussion/19750/pass-results-from-an-analysis-in-oac-to-filter-values-of-an-analysis-in-erp-otbi#latest Stick to that thread till it's completed.

Hi, Of course you can do it via script. You can look at calling Catalog Manager (the tool) by command line (runcat.cmd or runcat.sh) and you can do all you can do in the GUI and even more. Or you can look into the available webservice: https://docs.oracle.com/middleware/1221/biee/BIEIT/methods.htm#i1009936 (it's an OBIEE…

Hi, I don't have an OTBI to check what it looks like, but it generally behave a lot like OBIEE (11g or 12c, no idea but doesn't matter here). In OBIEE you can pass filters to an analysis by using the GO URL syntax. I don't have a 12c link handy, but it is (was?) documented in the official doc too (both 11g and 12c), I just…

Finally managed to open an OAS to just make sure there isn't an option for it. The dashboard options really only give that option of entire dashboard export with an Excel output format. PDF is available as single page printing. Once you created the idea, post the link back here, it could get it some more upvotes :)

As far as I know this feature doesn't exist for PDF, only Excel. You can always create an idea for it or an ER.