I would try to take an approach being not too tightly coupled with your current environment as you never know what the future looks like. Keep the unix scripting (with file system access to the OBIEE catalog objects) as plan B, and focus on using the OBIEE webservices for the catalog first. This way you could run your code…

I would say that the custom label being an optional information which can be different view by view in a unique analysis, you can't expect it as an option to select in the catalog report screen. You can get it from the XML of the analysis itself, you can easily parse it and extract the custom heading at the analysis level…

Can't help you not having an OAC available

Hi, You could easily find out the new CSS selector to hide the apply buttons by using your Chrome or Firefox: open the "Developer tools" extension and use the functionality to select an element in the current page to pick the buttons and see what kind of common and unique class they have. It isn't any black magic, just…

In SampleApp 607 (https://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html ) there is an example of that. I don't remember the details (did that some years ago), but it was either an "UPDATE" statement run against the cube or a calc script doing the job. Look there into the VM, there must be an…

As far as I know DVD doesn't update automatically, it notify about the existence of an update at the best. "it appears to be" : it is or it isn't And could be something to explore if you really uninstalled it fully or left things around and therefore the old version is using new files etc.

You are welcome. A last step: close the thread. For now it's still "This question is Not Answered." ...

Go on https://edelivery.oracle.com/ , search for "Oracle Data Visualization Desktop 12c", pick your version, add to cart and follow the steps (select OS etc.).

The lack of 100% certainty is just a fact: OBIEE is a web page in the end, which means that any piece of HTML / JS coming from anywhere can do things like a link. It depends how "bad" were/are the guys who worked on the system till now. Many people like to do random custom things when struggling with the out of the box…

Hi, So you are talking about analysis and dashboards, and not reports, right? A report would be a BI Publisher report. An analysis has a path, just like does a file in a file system as the catalog can be seen as similar to a file system. All the questions you are asking is what a proper auditing tool is supposed to answer.…

You asked for the catalog and the list of things you look for is catalog, therefore stick to it and forget the repository. If you don't know how to access the repository and don't ask for anything coming from there, no need to look into the repository (or you will never do any work as you will spend the next months…

partycrane wrote:The dollar sign must be left-aligned, while the numbers must be right-aligned, as shown below: You must know that this will be not doable or at least not easily. In HTML you can't easily align a piece of text on the left and one of the right from the same element. It would require some "exotic" CSS to add…

#Mayur wrote:And for the total we don't have the option for the formatting. For this I have added Union with the same columns set in the analysis and added again the same Conditional Formatting. Just a thing to try ... Why don't you set the $-sign format as the default format of the column, which is then also used by the…

For licensing ... what Robert said: it's the only way to be sure to not be (for now) in troubles I would assume only a single license would be required (the webservice will need to authenticate before to get anything out, so need a login/password). Once the data is extracted you use that file to display things to people…

I will join Christian on this. Based on the info you posted, I would definitely look more into a webservice call. Your website can do the visualization using javascript and a map provider (can either be Google or any other or even just javascript high level (country borders) maps. You schedule a call via webservice once or…

Jerry S. wrote:...for anyone to look at. You will need to figure out licensing as well if you mean anyone as random people visiting a public website etc. To extend Christian's first point, I would highly consider a proxy in front of your OBI to allows you to implement a first layer of security by limiting the available…

KashSidd wrote:To save time... Hire a consultant. And reading a document related to 11.1.1.3 without reading about the functionality itself, understanding what it does, and be able to think a bit outside of the box to turn it into what you need, will not save you any time. Good luck ! PS: a screenshot of a Presentation…

Well ... by using it I can get a CSV file with the place to put my own description and populate them all at once. This CSV could easily be generated by any kind of tool or language. If that's not what you look for, you maybe want to express a proper use case with all the details.

Hi, The thing going in that direction could be the "Externalize Strings" utility. You find it in Tools > Utilities. Read the doc of that utility to find out if it's useful for your need (and if it doesn't cause more issues than what it solves).

So there is the first place to look into, standard debugging: - what roles do a user not supposed to get in have? - why those roles are assigned to that user? - why those roles are allowed to login and do things? Sounds like you aren't in control of your security model now, look into the model you setup, look into…