You don't have an option when archiving a dashboard to include "linked" objects, so it's something you have to manage yourself. You can make your life easier by adopting a clear and clean structure in the catalog, so each dashboard has its components not too far (like everything into a same parent folder and then separated…

A single DB account with SELECT permission on the 40 accounts and the schema name is set by the variable is an option. Set the same password for the 40 different schemas (or the 40 different accounts with access to these schemas so the only piece requiring a variable is the username (schema). Of course you can also import…

(for reference) double posting with Chained Prompt in OBIEE 12c doesn't work So now that both threads are in the same forum it makes it more obvious why it isn't a smart idea to double post ...

An init block is executed only once, so if you expect to call your init block every time the user want to switch country it will never work. You asked how to switch from country A to country B and as said the only way to send back to the RPD a value from the front-end is by using a session variable which can be set by…

Did you try the recording option in Console when doing it by hand and take that as base?

Hi, Is the "require fully qualified table names" checked in your 12c connection pool? Because that's the settings making sure to not confuse tables when working with objects from multiple schemas with same names.

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…