Hi, No tool available to do that (or to manage the DB schemas in general...). What is your target? Because if they are just dev instances I don't really see what kind of info you want to merge ...

No need of any path, it's on your web interface, in the "Home" of OBIEE.

You can concatenate the output of both adding a space in between : MonthName(...) || ' ' || CAST(Year(....) as VARCHAR2(4)) You just have to cast the output of Year to a varchar to avoid OBIEE complaining you are concatenating incompatible types.

Hi Asim, The Admintool exe file is already into SampleApp as it is in every OBIEE. You can find it from the home page. The Admintool is windows only, so you have to install it on a window machine (your host one or another vm). This is also the reason why it isn't into SampleApp which is a Linux machine. You can connect to…

Hi, Not really sure what you expect as answer but did you try looking at the available functions when editing a column of an analysis? There is a full block of functions for dates. There you find CURRENT_DATE which is, like the name says, the current date. You can then format it the way you need or also use some extra…

Federico told you where to use it... For your question about "is there a way to add this to the prompt itself" it depends ... Do your users write the value of the variable in a text field? If yes you can't really do anything there .... If the users enter the values by selecting in a drop down list you can of course trim…

asim cholas: look by command line what is the real name of your files or make sure your Windows isn't hiding extensions...

Hi, The repository (the RPD file) is unique for a given OBIEE instance, so you can't have 2 RPD. You can perfectly use the same RPD and also the same subject area / business model for your ad-hoc analysis if the data and structure are the same. In the RPD you can model as many business models as you want, and for each…

Well, it's not going to help you but apparently you did everything fine... Just to be sure: files extensions are visible in your folder, right? (as they all are recognised as winrar archive I'm guessing if there isn't a zip extension hidden there...

Are all your checksum correct? Are you using 7-zip?

Not really .... It would be UI hacking with JS in all directions and it will be a lot worse than some logic in your filters.

It's all about boolean conditions ... '@{your_variable}{zz##zz} like 'zz##zz' OR <your original condition> If you planned to join all the conditions by OR with that kind of logic the blank will return TRUE and so all blank fields = all data. Work around that

Yes, but that's the obvious answer (it will not assign you all the approles because you are good looking )

What Christian said is a clean way of doing things. If for any reason you can't do that there are other options, EVALUATE and a stored procedure is a bit ... too much .... If the separator of your values in the variable is a comma and your values are numbers (without the comma) you can easily do it by doing something like:…

Hi, In your screenshot I see authenticated-role is member of your HR_SAL_ROLE, is it the same for your other "consumer" roles? Because "authenticated-role" represent every single user with a values login/password, so if your other "consumer" roles are similar to your HR_SAL_ROLE having authenticated-role as member ...…

ae6888f0-bbbc-49f3-ba0b-8a06d5f6301f wrote: should be able to find "Hudson square 5", if they enter "hudson 5" or "5 hudson".For this I would need to take the value from the STREET variable, split it into several parts, and then run several OR filters with the various combinations, I think. Hi, This one isn't really…

If you read the answers to the thread you find it! An OBIEE formula giving you the fiscal year start from any given date is posted on the 6th answer... And again: it's all about math how to get it, not really an OBIEE issue as the tool gives you the functions to add/subtract periods to a date etc.

Well, I'm sure the Oracle doc (or even just Google) have the answer for that... In any case there are many Database forums next to this one focused on OBIEE where you can for sure have all the answers on how to upgrade your database. For the relation with OBIEE as said it's all about how do you plan your upgrade...

So, summarizing what Thomas And Joel are saying : adapt your time dimensions by adding the fiscal year informations and then model an alternate hierarchy in your OBIEE for the fiscal year and ... done ! Just use the standard OBIEE aggregations and time series functions

OBIEE 11g to 12c is an out of place upgrade, so you have to install OBIEE 12c from scratch and at some point you will be able to migrate your content. The documentation cover that. For your DB upgrade you can decide when you do it: upgrade the DB on your current OBIEE 11g and once done start the OBIEE 12c upgrade? Keep…