How to say ... the reason? Well, there isn't any. It isn't something you configure, so it would be more everything or nothing. Interesting that only conditions end up in the UT table, in the end they are an object like another doing a query and getting something or nothing back.

Next time we have to put our answers together: words + link with images

Hi, If you set the session variable containing the connection details as a request variable (by checking the "enable any user to set the value" checkbox) you can then use a prompt in your dashboard to change the value and point to a different source on the fly. Users with just one country will see a single (default…

@Sory : what's the point in replying if you then open a new thread (double posting !!) and do not follow up? OBIEE 12c chained prompts doesn't work

I guess I saw example of something really close to the one you did, so definitely a resource to have available to take ideas (or just copy the code directly )

Why don't you let OBIEE make the work by using the "limit values by" checkbox? As long as your model is correct OBIEE will automatically limit values of your second prompt based on the first one.

My bad I didn't read it as the "privilege" (was thinking something else probably) ... So your not-admin users can do all they need (edit column add their HTML) except defining the column as containing HTML as the format. If you add a narrative to the analysis can you check the checkbox for HTML there?

Hi, Did you try with this one? I would hope it's enough ...

Hi, It's not that developers didn't wanted an outer join in the physical join, it's just that the physical layer must not think about inner or outer join but just about "how to connect object A with object B" technically. And you outer joins or inner joins you set them, as you said, in the business model. But actually your…

Did you check your log files to see if there isn't at some point a reference to this table with a message giving you a reason? PS: when you have a question keep it flagged as a question

John305 wrote:when i do the SAME report in the report editor Do you mean Publisher, right? And not Answers?

Get in touch with your Oracle account manager (or Oracle contact person you have). He will be the only able to give you a price based on your current license and your new needs and will also be able to answer your questions about changing the kind of license etc.

Ahahaha Yeah, but the "issues" introduced by the union, as you say, can be too much (losing drill, actions etc.) without forgetting the performance side. I would still suggest to challenge the requirement in this case, remembering the user OBIEE <> Excel (and that Excel is extremely cheaper if that's what they want).

You understood right (at least that's what I also understood...) Good workaround, didn't cross my mind ... So you have a new attribute column with provide the label, and a single measure column which you exclude the header and visually your newly created attribute column with the CASE WHEN looks like if it's the header of…

Didn't you get a warning on the checks before the install that this lib was missing? In general it cover everything needed ... (good you solved your case, but curious to see if the checks before the install were all fine or you got a warning at least)

@John305 : what tool are you exactly talking about? Your screenshot is about VA/DV, and things are quite different between a VA/DV project and a "classic" Answers dashboard.

Just a detail: instead of TIMESTAMPADD(SQL_TSI_DAY, 0, CURRENT_DATE) use directly CURRENT_DATE . It returns the exact same value but simpler to parse and totally avoid any date calculation by mistake (keep it simple).

Inside the same pivot view, when the measure is repeated for the various values of your "quarter" column not out of the box. This doesn't mean you can't do it ... OBIEE is a web page, a web page content can be changed by using languages the browser can understand and execute, for example javascript. But the point is: is it…

3429857 wrote:We have installed obiee12c on windows server 2008 R2.We tired to do the migration from obiee 11g to 12c by following oracle docs only even though still facing the same issue. You maybe followed Oracle docs only, but you didn't took 5 minutes before the install to look at the certification matrix: OBIEE 12c is…

So for the same measure in a pivot view you want the header of that measure to be different based on the attributes (quarter) ? Simple: you can't The header of the measure is repeated for every value of the attribute columns selected, and the same name will be used. So you can use a static name (written by hand) or a…