Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
@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.
-
@User_5M8FN , Please open a new question, providing all the details (exact versions, context, environment, log messages etc.). This is more than 3 years old and has been abandoned by the OP. By starting a new question it will be focused on your case and not mixed with the issue of somebody else...
-
What is bug ID ?
-
To make sure I understand your situation... You are working on OAC (therefore let's assume latest version, July I believe) and creating an analysis in "classic". In your analysis you define an action link on a column. All good, everything works in all browsers (Firefox, Chrome, Edge). You then enable the translation for…
-
Since OBIEE 12c the whole interface is mainly javascript, you will not see a thing in OAS/OAC (classic and even less DV).
-
What is the exact name of the product (and its version)? You should contact the people in charge of the platform in your company, there should be developers there knowing how to do the job.