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…

I guess I saw something similar in MOS, there are a bunch of docs about export to Excel, worth having a look.

3003431 wrote:is there any permanent solution to this? Filter your dataset Ok, more seriously, you aren't having an OBIEE issue. ORA-01652: unable to extend temp segment by 128 in tablespace TEMP This is a database message, you are short in tablespace in your DB, you need to ask your DBA to look into it to either extend…

Actually a quick correction: the custom number format (https://docs.oracle.com/cd/E29542_01/bi.1111/e10544/format.htm#BIEUG13084 ) use the 3rd parameter for NULLs, not 0. Therefore you need to adapt the formula to translate 0 into NULLs first if you want it to match the 3rd parameter of the custom number format.

If you look at the help in the column properties where you can set the formal, you see the syntax to be used. It's a typical <positive number format>;<negative number format>;<zero/null format> You can't set a custom format for a not existing value, so if your cell is empty and not NULL, the format will not apply.

Everything Christian said ... If you don't care more than that in finding why and fixing things, you can set limits at the user / application role in the RPD: Manage > Identity, pick who you want to set limits Permissions > Query Limits.