And the physical query is? That one is the logical query. By the way: the Oracle database is telling you that you have another issue: ORA-01017: invalid username/password; logon denied

You have a popup message in VA with a link to a thread in the forum? Would be easier if you write all the details in this thread, otherwise there is no way somebody could guess all the possible things happening. Info like exact versions etc.

Still, did you check the query the BI Server is sending to the database? (that feeling of repeating myself ) Run an analysis giving you the error and find the physical query the BI Server sent to the database generating the error (either in the manage session page or the log files). What is this query like? Why do I…

Did you check in the logs what exact query the BI Server is sending to the database? Maybe it isn't using the fully qualified name and therefore there is a wrong or missing schema in the query or things like that.

3698127 wrote:Hi,Did you understand my requirements.Each brand is shown only once and corredponding years are repeated as shown in latest attachment. Look at what I wrote just before this reply, that's the final answer.

It isn't me who developed OBIEE, it works like that for more than 10 years. So the reply is the same: buy a different tool or code the visualization yourself. Do a D3js or any other JS library visualization in your OBIEE analysis or develop a custom visualization plugin if you consider moving to DV. There is nothing else…

Buy a different tool ... OBIEE does this by concatenating values, so you will have "BizTech 2012" on the first column, "BizTech 2013" on the second etc. Just like the first screenshot I posted above. DV will have the same approach, but adding a comma to separate values (so something like "BizTech, 2012" etc.). You could do…

Sorry but you are either not doing it right or not saying everything about the analysis. OBIEE always worked as @Shane.S said. The order of the columns in the horizontal axis box matter: Brand, Year generate this chart with first a group by brand and for each brand every year as bar. If you want to have first a group by…

3698127 wrote:Hi,Already tried this but this does not work. What does "this does not work" mean? Because the order of the columns define the order of the bars in the chart. Now if what you expect to get is exactly the picture you posted, sorry but the tool doesn't do it. OBIEE does many things, but you can't expect any…

Any chance you can make your request a bit more explicit? What tool/version you are dealing with and what are you exactly looking for, because I'm really not sure of what you could be looking for ....

What Jerry said ! Right now you never assign a value to your variable, therefore the default value is always used.

Good to hear. So could you close the thread and mark if required? This will help others having similar questions to find useful information. Right now it's still This question is Not Answered.

Isn't that the description of the presentation column? 5th column of the "Repository Documentation" CSV file.

Sorry but what are you looking for exactly? Because the question keep changing. If you know exactly what you look for, just ask that directly.

The RPD isn't in a database, so if by "query" you expected a SQL query the answer is simple: not doable. You can still get things by querying the BI server and running the following query: call NQSQueryMetadataObjects('objectId', '', '', '', 'false', '', ''); replace objectId with: 4004 for subject areas 4008 for…

You open your RPD with the Administration Tool, you go in Tools > Utilities... and select "Repository Documentation". In the CSV you get the first 3 columns are: Subject Area, Presentation Table, Presentation Column Just take those and remove duplicates and you have your list.

An added point for the proxy option: you can get rid of the port as well. No need to have it in the URL as you could use the default 443 with SSL. And the proxy could also forward / to /analytics by default if you forget it. So your nicer url would only be: https://company-obiee-dev

The proxy can be on the OBIEE server itself. For example OAC (at least the "Classic" one) came with a proxy setup on the OBIEE server itself doing the redirect and the SSL offloading: so you connect over SSL till the proxy, and the traffic between the proxy and OBIEE isn't SSL as it's on the same server and therefore it's…

What will be in charge of making the URL "user friendly" ? Are you going to install OBIEE on servers having nicer hostnames instead of more "random" ones? Are you going to have a proxy in front of OBIEE to translate the random one into a nicer one? The documentation covers how to setup SSL in OBIEE, the url is generally…

Hi, As far as I know they don't look for ideas about the product from this forum (never saw an OBIEE/OAC product manager here in the last 2-3 years). Your best chance is to raise an enhancement request (a type of SR). For OAC there is a place where they listen to ideas in the other CCC forum (I just don't remember the…