Hi, You can get the current date in the title (or a text box) by using @{system.currentTime}[DD-MM-YYYY] For the 6 months calculation it's a bit different as you aren't looking for a variable but you want to execute a calculation (a LSQL piece of code). Why not write something like "Data for…

The link for what? As I talked about 3 possible links and you ask for just one. PS: Google is awesome for searching things...

Just keep in mind there isn't a unique rule on how to model the physical layer: even if your tables come from the same database but 2 or more different schemas doesn't mean you must create a single physical database with a single connection pool in OBIEE. You maybe don't want to have a single database user having access to…

Hi, the reason of this behaviour is because you forgot (or ignored) how the tool work. Where did you see that "orcl" identify the database and so you can just add as many connection pools pointing to various accounts? Where did you saw a link between a physical table and a connection pool? Nowhere .... Going back to the…

You look for known 11.1.1.9 issues? Check on MOS the notes related to the last bundle patch for 11.1.1.9 and you see the known issues at that point. Of course it doesn't mean there aren't other things not working. If you look for issues during the upgrade again the doc tell you some things, then it depends too much on your…

Did you try by protecting your filters? You are affected by what is supposed to be (and actually is) a feature: if you have a prompt based on a column by default OBIEE will use that value for any filter on the same exact formula (column) in the analysis contained in the page. To avoid this "feature" which override your…

PavankDatti wrote:Finally I got resolved the issue which i was asked. So you can maybe contribute to this community forum by posting how you solved the issue so that others with the same problem will find your contribution and maybe solve their issue as well. (It's all about sharing)

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.