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…

Add a text block to your dashboard and just print out the value of the variable with @{variable-name} . To see it in a log you would need to pass it to an analysis as parameter etc. would be longer and more complex than just display it. The same work if you add a text view in your analysis itself.

3822729 wrote:Currently, anyone who is authenticated is able to get in . How is that possible? If a user isn't member of a group, it doesn't get any valid application role and therefore it must not be able to access. Did you cut the inheritance to "authenticated users", did you? Because any user with a valid login/password…

There are many ways to get there, one is what Robert posted above. You can also look in the dashboard properties and check the checkbox "Prompt before opening" for that page (as posted in the thread linked above).

Hi, If this is a table view, the order or columns isn't dynamic, it's fixed based on the order the columns are places into the table view. Only the rows could be sorted in a different way. More in general you seem to be wanting to sort based on the value of a total row, if that's the total OBIEE does calculate…

Double post with DAC - stopping Queued or Runnable Execution Plans already in the Current Runs You maybe want to close this thread and only keep open the one in the right space (the other one), and remember double posting is against this forum rules.

I'm totally with you on the fact that a move back to 11g isn't a solution to a failed move to 12c. He said he has "certain reasons", not giving a single one. This sounds like somebody somewhere decided that, and we can't do much against "smart people" knowing better. Of course they better try to solve the "certain reasons"…

Of course you could try by copying the XML around between the versions, but you could have unsupported XML not allowed by the 11g XSD or things which are allowed but not working in that way. So any automated approach could take you long to compare and debug. Being such a small environment in 1-2 days you must be done by…

1877648 wrote:Can you please suggest the best approach to execute this task? Take a workstation with 2 screens, open the 12c OBIEE on one screen, open the 11g OBIEE in the second screen. Start recreating every single object by hand, one by one. 5 dashboard, 40 analysis (a report is a BI Publisher report, I doubt you have…