I hope for your it's already the right subject area as it would just take 2 minutes The "UNION" is still a front end thing, but I really would suggest to avoid it as you end up with many more issues in the end (losing things like drills etc.). If it isn't in the subject area but in the business model (inside the RPD) on…

Hi, As columns can't be added to a dashboard or a page I guess you mean that you want to display them in the analysis you have on that page? If they are part of the subject area used by the analysis no problem, just add them. If they aren't you would end up doing UNIONs to add these columns from another subject area and it…

In addition to what Robert posted (which is the right answer) : you bought OBIEE, so at some point you do things in a OBIEE way and not what somebody put on a paper with no idea of the available tool. You can the same functionality but it is a drop down menu and not a radio button ... If you really need a radio button…

A blank page is often not so blank ... Is the page really blank? What's the URL of the page? If you analyze with the developer tool the various redirect of the login process where does it stop? That's just few things you can look at and give you a better view of what you have in front of you

Must be a statement as there isn't any " ? " in the post And if it was a question I'm sure @3463828 knows and would ask it accordingly

Ok, so your question is different: not the maximum size of a name, but the maximum visible size. And the answer is : there isn't an answer as it depends on the user ! Depends on the size of the browser, depends on how many other things needs to be displayed on the same row. If there is enough space OBIEE will display…

I'm not really sure there is a hard limit which you are supposed to hit if you want your system to be usable ... Writing a 2000 words dashboard name just make it unusable. Did you hit a limitation? What "size" are you looking for?

Dumb question but ... The connection pool allowing you to see data does really use a TNSNAME? Because it maybe has the full connection string defined, which explain why it works

Catalog Manager and archive the catalog. Then you can still zip the file if you want but at least that's the easiest way to get part (or full) catalog and move it around.

SasDutta wrote:I am using 12.2.1.1.0 version of Admin tool. SasDutta wrote:Yes, my admin tool version is 12.2.1.0.0. So you have 2 installs or just one and it's the 12.2.1.0.0 ? Your Admintool version must always match the server version, so yes, you need 12.2.1.1.0 Admintool to work on a 12.2.1.1.0 server. You can have…

Do you have the folder at least? What does it contains? Are you really using 12.2.1.1.0 of Admintool? Because "data-model-cmd.cmd" is the old name of the script as used in 12.2.1.0.0, and the file also was in a different folder. It has been renamed and moved to be consistent from 12.2.1.1.0, so it looks like you are using…

SasDutta wrote:I am using Sample app V6. What is V6? Looking at OBIEE Samples the numbering of SampleApp VM is 3 digits (first one for the year in general and the other 2 for the month of release). So you are using v607 ? It would be 12.2.1.1.0, so at least it matchs your Admintool SasDutta wrote:I am using just…

Post more details: what's the version of your Admintool? Does it exactly match the OBIEE version of your SampleApp 607 VM? What's the full command you used?

You have SYS access to the DB, connect and look at the existing schema and you will be fixed in 3 seconds with the answer. If they aren't there you can install them yourself: https://github.com/oracle/db-sample-schemas

SasDutta wrote:In my host machine host file I mapped the ip address with demo.us.oracle.com Apparently you don't really care about replies, but stop doing that, it's a useless step ! Your VM get an IP by your network DHCP, which means it can potentially change IP at every start. So you end up editing your host file all the…

In addition to what Christian posted (which is actually how you can get the IP to use), forget "demo.us.oracle.com" as that thing doesn't exist anywhere else than inside the virtual machine itself. So only IP works to access the VM (replace "demo.us.oracle.com" by the IP you get from the "What Is My IP" tool).

Hi, If you see the different queries you can maybe at least post more details on what you are doing, what your model is like and what the 2 queries are. If you select col1, col2 and a sum(measure col) and nothing else it will probably be the same, so to get different queries you must have something a bit more complex than…

You don't have to do anything, the "at each execution" is OBIEE doing the job. Looking at this screenshot you see the 2 possible values for "Run As". If you agent is "Specified user" it means OBIEE execute the dashboard page only once as the specified user and then will send the result it got to all the recipients. If your…

Well, in general things are the other way round: users come from the company LDAP and so they also already have a "business" link with the office. If you don't have that then you need a table with just "username", "office" and then you session variable will select "office" where "username" is equal the login of the user.…

Hi, How to relate users to offices is something only you can answer, as it's strictly related on your business. The idea is to set a session variable for each user defining the office(s) he can see, and then you use that variable to filter the dashboard.