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…

5.) APEX like the example in SampleApp 6.) Hangout/skype/slack or any other communication tool

Hi, Depends on your license. If you have named users license you must have a license for every single user you have. The easiest is to get in touch with your Oracle account manager to make a point about your current licensing and define your new needs or the limitations you have now to fix to not exceed the license you…

True when you use the analysis, but the single object is the analysis which has 1 LSQL globally (if you translate custom filters into generic filters). Real query generated at the time of executing the report with the context is available in the UT tables, as Christian said. But all these possible queries always come from…

Hi 3269182 wrote:Urgent requirement pls....! That's why consultants exist: hire one and he will be pleased to answer as fast as possible. Did you try searching? This topic as been covered here at least 10 times and on Google at least 100 times. Out of the box not a single one of these things is possible. There are external…

I agree but in this case the OP posted "Weblogic Server : 11gR1", so definitely not a 12c

Did you really googled? Because just writing few words I got this as first result: https://docs.oracle.com/cd/E12839_01/apirefs.1111/e14397/LogMgmt.html#BEA-170011 You must check in the various logs for other pieces of information, the warning you are seeing isn't the cause but just a consequence of your real issue. And I…

As extension: you can also define and setup UT on another kind of DB, as long as it's a standard kind of database talking SQL and that can be defined as a physical source in the RPD, so not really only limited to the 3 kind of DB but 98% of people just use the table in the RCU schema.