Multiple installs? Sure, all independent and not sharing anything, no problem for that.

As the idea of the attribute is to be unique (based on the logical keys you defined), if you add the logical key to your analysis you will get the correct level of granularity. The distinct will still be there as that's how things are supposed to work (when using measures there is a group by, when only attributes it use…

Did you read what I wrote above? Because I actually gave you inputs on your original post (in the middle of the reply to your second one...). Aren't you in the described case? All the cache things ("checkbox" , prefix box etc.) are in the analysis using the value of your 2 prompts. But the prompt itself doesn't have these…

Hi, Your first case has an issue where OBIEE will not really help you a lot: you have a "dynamic" list of people. Having prompts allowing you to enter values, store these values in variables and use them in formulas in the analysis is fine. But your first example is typically somewhere where you would want a Qtr and FY…

Different reports, different columns ... Master-detail to not care as long as the column "driving" the logic (customer) is the same one, and it's your case ! Master-detail is often used inside the same analysis to drive different views, but can always perfectly works between different analysis in the same dashboard page.…

Good it works for you, as it has been suggested as solution ... Can you please close the thread? This question is Not Answered.

Hi, What do you mean by: Selva Pandiyan wrote:OBIEE reports by default generates the physical query with DiSTINCT CLAUSE. You mean when you make a query on attributes only? What's your use case? Because you can definitely avoid the effects of a "DISTINCT", depends on what you try to do exactly ...

Hi, Not sure to get exactly how your thing work. Report 2 and 3 always display data of a single customer, the one you click on report 1? If that's the case you better use master-detail instead of navigation. Master-detail will only change report 2 & 3 (both details) by selecting the customer you click on report 1 (master).

Hi, In the chart the legend has no option : it's there or it isn't. Names are names of columns. If you need a kind of custom legend you can add a "legend" view to your analysis. The legend view is built by hand, so is static but allow you to put what you want inside the way you want it.

There is a way you can check the value and change it ... The PORTALPATH is a variable and you see it in the RPD if it is set or not. The value of "My Account" is stored in the catalog. I don't have a 11.1.1.9 available right now but I'm kind of sure it didn't change that part. 2 ways to see / change the value: first one is…

Hi, Apparently it's the DB not accepting connection using an old JDBC driver (what the installer does). There is a setting you can set on the DB server (in the sqlnet.ora file) to allow older clients too. Have a look at https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016 and ORA-28040: No matching…

Hi, You probably linked the wrong Document ID ... The 11.1.1.7 Admin tool isn't certified for Windows 8, 8.1 or 10. Just because they didn't existed when the tool has been developed. The 11.1.1.7 just doesn't work on Windows 10. If you search the forum you will see that many tried to make it, all failed. Some managed to…

Hi, Based on what Oracle says: Oracle Database Vault implements powerful security controls within Oracle Database 12c. So in the end it's a Database 12c, which is supported. Vault apparently it's a kind of "layer on top" to give you extra control on security etc., but from a "SELECT ...." point of view, which is what OBIEE…

Well ... that's no luck "a general error" and nothing saying what kind of error it was ! Anything else useful if you look into the logs?

Making it short: if you go in the way of a piece of javascript be ready to spend few weeks on it and end up with something not working. The prompt in OBIEE aren't just simple input HTML object, there is a ton of JS all around, many event handlers etc. @Thomas Dodds gave you the best idea and @Manoj Dixit extended the same…

If the error come right after the login (so you don't see anything) check the "My Account" to see if you aren't pointing to that dashboard which doesn't exist anymore. Also double check PORTALPATH as suggest by Sherry George, even if I can't imagine why the hell you would set a sample dashboard as the default one for your…

Hi, Start by opening the "Odbc driver returned and error" message and get the full message and post that one Things working yesterday and not working today generally means something changed: you or somebody else maybe changed the analysis or something else in the system, yesterday you had a cache effect and didn't see if…

Ok, but ... does the file exist? Why do you still try to access the Sample Lite content if you promoted your own? Is the "Quickstart" your default dashboard? So if you switch to another one problem solved (in "My Account").

Is the file there in that folder? (it's hidden) Do you have permission to open it? Without access to this file (or without it) you dashboard can't be opened... The support document you found is for BIApps, you have an issue on Sample Lite, the default deployed content. Actually you don't even need that content as you are…

Christian already gave you the links, read that and you find answers to all your questions 1) depends on your needs, from none to all, nothing mandatory 2) for year if no gaps you can use it, for others of course you will be required to create extra columns 3) the impact is fairly limited in a normal situation If you don't…