Based on what you wrote I would say you look for the wrong thing in the wrong tool .... Your requirement isn't an OBIEE job, so let's get OBIEE out of the equation (it will only be a webpage hosting your button). Javascript is a client side language, so it's execute by your browser, therefor can't create a file somewhere…

Hi, The message "5.7.1 Client was not authenticated" is something your smtp server is telling you. Did it ever worked before? If yes and nobody changed the config get in touch with your SMTP admin to debug that. If you google that message you find many results related to Exchange. If you never used it before or it never…

ADB wrote:on my dashboard page i would like to create a button that triggers a javascript which is going to create a file in a certain folder. You maybe need to define a bit better your requirement ... Is the folder a folder on the OBIEE server or is the folder a folder on the workstation of the user using OBIEE ? In…

ORA-01722 is an Oracle error, not OBIEE, but your database. So without looking into details the message is about "invalid number" I would say you maybe have a mismatch between the Oracle database column type and the OBIEE definition in the RPD. A different type has been set by OBIEE or something around that. Take the…

Hi, Didn't you forgot to write most of your thread content? PS: the original thread was a lot less than now ...

Hi, Seem to be related to the java version. If you google "Unsupported major.minor version 52.0" you find many references explaining the case. Making it short you are trying to run a piece of java compiled with a version (1.8 I would say) but you run it with a lower java version.

Hi, Did you try "Tools" > "Utilities" > "Repository Documentation" and save as CSV ? You then open your file, delete the columns you don't need (ideally you are only interested in the first 3) and remove duplicates (so it will take you 2 clicks in Excel).

And also which version are you talking about...

I would say the ' = ' isn't the right operator when dealing with a set of values... Did you try to use a IN and add your filter in the filter part of the Criteria tab of your analysis using the UI?

And how do you use it as a filter in analysis?

As row wise variables works in 11.1.1.7 would be easier if you post more details as you maybe have an issue in your init block. So how does the init block looks like? If you test the variable in the RPD you get all your values?

Of course it is, and all the answers to that kind of questions are easy to find in the certification matrix: http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html More in detail, for RCU it's certified with 12.1.0.1+ and 11.2.0.4+ , as a data source it accepts many more versions.

Enterprise Manager, if configured correctly, display all of them it isn't a formal report. As said it's based on your authentication providers and that's why EM is the only one able to give you the best list from the OBIEE side.

938767 wrote:At this point I'm considering exporting the RPD XML and just adding the content levels with a script. Honestly I would say you are safer if you still spend 1h doing it by hand. The XML manage content level by reference IDs, you get it wrong and you screw up your RPD. So if you aren't extremely comfortable (and…

Ok, so keeping it short: not really. And for sure not setting itself as "total" (as in general it's more the other way round and a normal default value would be the most detailed level of the hierarchy.

938767 wrote:... is quite time consuming. Well, knowing the RPD is a one-shot activity and so you have to do it only once I would not say it's wasted time but it just takes the time it's supposed to take. As you set it by default to TOTAL it means that most of the time your "new" dimension are non conformed dimensions. So…

Did you read the link posted by @rmoff ? Did you "debug" a bit your error? For example replace one of the 2 arguments with a different value to find out which one give you the error? But I guess it's the date... Because you write '1/1/1970 05:30:00 AM' assuming it's a date while that is just a varchar ... The link show a…

Hi Kumar, Please do not start adding random things like an index here or there because you are desperate, you will only make things worse and unpredictable for the future. First you must be sure of where the time is spent, as you post a SQL Developer screenshot I assume your analysis (…

Hi, The currently running queries can be viewed in the "Administration" page when you look at "Manage sessions". S_NQ_ACCT is for usage tracking (so stats) and data is inserted not only at the end of queries but in an asynchronous way, so a line can be inserted after some time the query was over.

Hi, If you create the dashboard by hand again in 12.2.1.2.0 I imagine everything works fine, right? Can you do that for one of your dashboard with the problem and then compare the "dashboard layout" file between the upgraded version and the one you created by hand? It's the file that exist inside the dashboard folder for…