For 2 the idea is to reduce the variable part to just 1 value (so setting same username and password and keeping the host dynamic). In this way you can use the variable set by the prompt to point to the right host. For 3 you import in the RPD and map in the physical and logical layers all the 40 schemas. You then setup row…

Do not think I'm playing with wording but a column without any aggregation isn't a measure from a dimensional modelling point of view. It would work fine without multiple facts and conformed dimensions, but because you have these 4 facts and conformed dimension it must be moved into a dimension so you can set the…

3357027 wrote:2) Pulled a numeric value(no aggregation logic applied in rpd), Is that one coming for the logical fact table? If you answer yes it means you modeled things wrong. In a dimensional model a fact table only contains aggregated measures, anything not aggregated and being an attribute must be modelled as a…

Of course you will need to know the password, and I can see that as being a issue ... I would say BVT was probably developed focusing highly on the /shared content as that's the most important one when doing a migration and trying to speed up regression testing. Content into the user folder is under the responsibility of…

Hi, AnalyticsURL must have the format http://<servername>:<port>/analytics and you can't add other parameters there. As you have the username and password define them as a new Deployment using the UserName and Password fields and with this new deployment you run tests only on the content you need to test in /users. Because…

So the 2nd (if 40 hosts) and 3rd still match

If I can add just a note to your solution: do it into your own custom style instead of editing default Skyros (Alta inherit from Skyros) files. So the change will survive updates/upgrades and you will not lose it if for any reason the analytics deployment is redeployed on Weblogic.

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?