Hi @User_EA38B , Could you please create a new question where you provide your context (product name, version, situation) and the issue/question you have? This is a 7 years old thread, I like to believe you don't have the same (unspecified) versions. And you will also be able to explain in more details with your own…

Hi, The delete has its own "delete" permission, the rename needs the "write" (and I believe maybe also "delete") permission. Also, permissions are cumulated across all the permissions the user has (directly or through the inheritance of application roles) and the more permissive win: if a role says "read" and nother…

Hi @dilek , Did you enable the deprecated feature first? https://support.oracle.com/epmos/faces/DocContentDisplay?id=2622528.1 Because it is deprecated and disabled by default, you need to change a thing first (if you look the above documented it covers the process to enable a few disabled options, the PORTALPATH is…

@BASWANTH , Do not re-post your question for now: that would be double posting, something that should be avoided in forums (generally against the rules). I'm sure your question is extremely clear for you because you are working on that issue, but it would be helpful if you could provide a product name and version and some…

(Assuming you are using OBIEE based on the category you posted in, and not having opened your attached file because I don't randomly download "Word" files from a public forum...) Did you try with using the "Limit values by" option in your prompt?

There is an API, because that's what DV does use: an API. It simply isn't documented... Therefore it depends how badly you need/want it ;-) Open your browser developer tool, looks at the network calls the UI generate and you easily see how you can automate and script things. Documented? No. Supported? Not officially, but…

Note that runcat.sh utility is only available for on-line mode starting in OAS Let say that offline mode is still fully there, it's just the catalog that isn't anymore on the filesystem and therefore it could sound like offline mode is pointless. However, there are "documented" ways to extract a copy of the catalog offline…

Daniel, Aren't you having this? https://community.oracle.com/products/oracleanalytics/discussion/19917/has-anyone-had-a-issue-in-dv-workbook-after-update-sep-2023#latest Known issue, a fix apparently exist. Do as Tetyana mentioned and go through a SR to get it fixed. Oh, my bad, you are actually already in that thread and…

Hi, It isn't because you see all the columns of a subject area on your screen that they can be designed together. The tool is telling you that it doesn't know how to handle what you are requesting: the columns you selected can't work together. You should go back in your RPD and check if all these pieces are modeled…

@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…