It is definitely possible in BI Publisher. And I've forgotten about a Narrative view in Analysis. It allows you to directly code view using HTML.

I don't like word "impossible", that's why I'd say that I don't know how to do that [in Analysis].

Main steps are: 1. Create a pivot table. 2. Move "candiate name" field to sections. 3. All other fields ("fname", "lname", "age", and "city") to rows. -- Some tweaks: 4. Make measure column hidden (this column is not necessary if your report base on a single dimension). 5. Change section properties to display labels. As…

Do you want something like this?

Pivot table layout

Do you want something like this?

One more voice for browser zoom. And one more addition: flash graphs react strangely on zoom, HTML5 handle it correctly.

I'd recommend you to start with hierarchy keys check. From my experience, incorrectly defined keys are the most often cause of the strange behaviour like this.

Aggregate(... by ...) and aggregate(... at ...) don't work the same. Aggregate AT ignores LOB filter, Aggregate BY - not. It is possible that I don't understand what is the problem. Try to reproduce it with the default sample model so it's possible to discuss it more precisely.

This is an expected behaviour: Logical SQL Reference - 11g Release 1 (11.1.1) AGGREGATE AT This function aggregates columns based on the level or levels you specify. Using AGGREGATE AT guarantees that the aggregate for the measure always occurs at the levels specified after the keyword AT, regardless of the WHERE clause.…

Right. If there is no default value for a variable, '"Products"."LOB" in (@{p_lob}['@'])' becomes SQL like '"Products"."LOB" in () when 'All column values' was selected, which is not well-formed SQL. 'na' prevents it and makes statement correct - '"Products"."LOB" in ('na')'. This statement is always false while I want it…

Take a look at this topic: how to pass values to a presentation variable including All Column Values

It looks like you've tried to install OBIEE before, but the configuration was interrupted. And now you are trying to configure OBIEE with the same path. If it was the first installation and you have nothing to loose, simply delete instances/instance1 directory and try configuration again. If it is not the first instance…

What error did you get? Passing multiple values to presentation variable function itself works. There should be some error message that explains the problem.

'The Network Adapter could not establish the connection' makes me think about some network issue. Maybe a firewall. Another guess: are you sure that service name is orcl, not orcl.some.domain?

If understand what you want, here is the answer (screens from 12c, but works for 11g as well).

Try to look at this. The first link is a text guide and the second one is video. OBIEE 11.1.1.9 First Look - Customize Graphs and Charts in OBIEE 11.1.1.9 - artofbi Blog Customizing Charts and Graphs in OBIEE 11.1.1.9 - Quickstart Video - artofbi Blog

My guess is that your date field has time. So you are comparing something like '02/20/2016' and '02/20/2016 10:15:18'. To find out what is really going on, you need to get the exact SQL which goes to the database and then understand why it does not work as intended. 1. Turn logging on and cache off: open the report, go to…

It looks like you are right. Just checked this on 11.1.1.9. No luck.

Let me guess. You forgot to define aggregation schemes for measures.