The question is more why it was wrong in the DB? If somebody put its hands on the table changing the type of the column to collect more content .... simply avoid that! (I love to talk to myself ...) Gianni Ceresa wrote:Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the…

Actually few SampleApp I checked all use that column as a VARCHAR 1024 (matching the size I found in the DB). How come yours is 4000? Where does your S_NQ_ACCT table come from?

I don't have a running 11.1.1.9 (yours seems to be a 11.1.1.9) but in a 12.2.1.1 the QUERY_TEXT column of the usage tracking table is a lot smaller than 4000 (actually it's 1024 bytes). OBIEE varchar are limited at 4000 if I don't remember wrong, so you maybe have an error with encoding? As you use a system in Spanish (I…

Hi, Is it really OBIEE giving you the error? Because "ORA-01401" is a database error, and I found it quite strange that OBIEE use a ORA code for it's own errors. (Seeing an error in OBIEE doesn't mean the error is generated by OBIEE)

Hi, You missed a key element .... What version of OBIEE are you using? 12c deploy the RPD by script, so it will probably take you 45 seconds to automate that .... For 11g there are scripts around using WLST to deploy a new RPD. But it's all about your version ....

Actually there is a way to have a shared connection for OBIEE, it's all about an XML file you point to from SmartView. Some details: https://docs.oracle.com/cd/E38438_01/epm.111223/sv_user/frameset.htm?ch03s07.html @User13510650-Oracle : where does the shared connections info comes from? Did you set the XML file? If not…

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:…