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…

First: search the forum, same topic coming every week ... The answer is always the same: where did you see that OBIEE run on Windows 10? Does the compatibility matrix confirm compatibility with Windows 10? No and no. OBIEE is a server product, Windows 10 is a consumer end-user workstation/laptop. So if it doesn't work ...…

Add a "filters" view to your analysis. In the same way as you add a chart, a table or a pivot in the "Results" tab you can add the "Filters" view.

The hierarchy is mandatory (I assume you have hierarchies for your other dimensions, right? So just add one for this new table as well: grand total and detail level right after, no need to use it or add it to the subject area). A business key can have as many column as you want (the max is all the column of the logical…

Yes you must add them into a logical table acting as a dimension. Worst case if you can't find a better business key just add all the columns to it...

Hi, I assume you have the attributes coming from the 2 fact tables in the logical fact table? If it's the case you have a problem with your model. In a dimension model the fact table must contains only measures, any attribute must be outside in a dimension. In your case it would be a degenerated dimension (that's how…

It would help if you posted at least your OBIEE version, things can be quite different if you are on a old 10g, a bit less old 11g or a current 12c. Look at SampleApp, it has examples for that (the code is provided) and it's the "best way to do it" (as it's Oracle telling you to do it like that ). Live example on Sample…

You must buy them! There is no free map officially from Oracle, all you have is the provided high level demo. As far as I know Oracle doesn't sell maps directly but other companies sell them (you can also use Google Map if you buy an API key). Look what Andrew posted... (or Google for it)