Sorry, seeing you posted "checks" using localhost I thought it could be easy Did you try looking into the Actions log file as the error tell? (I guess it is bi_server1-diagnostic.log) Error in Action Framework configuration - please contact your system administrator and ask them to check the Actions log files for further…

I didn't do that integration myself (never had the need for it), but based on the blog post I would say that in the WSIL you better use the full domain / IP of the ODI server and not localhost. The blog post is based on ODI and OBIEE installed on the same server, so "localhost" works for reaching each other. In your case…

RMDR wrote:I have deployed ODI as java web in epm environment and trying to use the WSDL in OBIEE configuration but got error. What's the exact error? At which exact step of the blog post you linked are you blocked?

In the doc, via webservices, probably can also do something with runcat ... As you don't want to share more that all you will get (the more you give, the more you get ...).

What Christian meant with 1) is that you call "report" a BI Publisher report, if it's built in OBIEE Answers it's called "analysis" (by using the right names we all understand the same things). What you look for is just the security model. It's there out of the box but it's up to you to set it up. You maybe want to detail…

Well ... depends on what you really try to achieve as logic and behaviour ... As said your filter work as expected when a prompt isn't set, so the logic works fine which means you have to review the logic of what you try to achieve. And that's in your mind ... no idea what it is

Actually I will say it works as designed .... If you do not set "Termination Date" it's like saying any value of "Termination Date" is valid. And from a logical point of view (condition on "Processed Date") OR TRUE will always return TRUE for all the rows, which make the filter useless. So it just works as it's supposed to…

Hi Ivan, I honestly don't remember if there is something you can change/add in the import the wizard gives you. I would say not much for sure as the ADM driver isn't really powerful (at least what I saw with Planning). You can try to have a look at the webcast Oracle did few days/weeks ago as it was about integration of…

Robert Angel wrote:if CurrencyType is a dimension in your underlying Essbase cube If only ... HFM has no cube, just a fake "multi-dimensional" model fully in relational DB. So everything is on the ADM driver and HFM hands to make it looks like a cube... @2900201 : my sample HFM VM crashed badly (right before I started…

When you edited instanceconfig.xml did you restart the required component? Because that's a mandatory step every time you touch the config file if you expect to see the result.

Hi, The instanceconfig setting is required (and then restart OBIPS) but you also need the normal OBIEE privileges to use HTML. Did you check if your application roles have that privilege? (In the OBIEE front-end admin page)

You are talking about creating an analysis but in the same time describe tables and database structure and talk about SQL. Do you have a pre-built RPD and so you can only build analysis on top of it? You have to create the RPD first and then the analysis? It's a bit unclear what you exactly expect ... As Robert said, OBIEE…

The query is for sure not a simple 1 line query but a bit more, so it takes some time to read it but still ... Actually I have a hint for you on how to find the issue ... For the analysis with the monthly figures vs the same month 1 year ago, try to divide the year ago number by the real number you got (so Jan 2018 Year…

You are missing the point: do not expect OBIEE 12c to generate queries in the same way as 11g does. The product will always try to get smarter and smarter and generate the best query. So if your model isn't perfect the query can change over the versions. That's why I said to take the physical query, read it, understand it,…

Your analysis generate a physical query, take that query, read it and understand what kind of logic it's applying. You will probably find the error in the model or where it is ...

The XML you get it from Catalog Manager. As it's a migrated object it can also have pieces in the XML which aren't in the GUI anymore (because of the change of versions). If you delete that prompt entry and create it again do you still have the issue?

As Joel said: check the logs. Things generally do not happen without being logged. Is that prompt new or a migrated content? Do you see "2019" in the XML of the prompt? By the way: you know that 12.2.1.0.0 isn't supported anymore for some time and it's also the most bugged of 12c being the very first release?

Variable, aliases and few other possible things. Bu you aren't really providing anything to give you a better answer ....

Did you check permissions? Remove and add the analysis again if you want to make sure you are really pointing to the right path ...

I'm with Robert : not OBIEE fault if your SMTP refuse emails. Double check the SMTP settings and ask the mailserver admin to have a check ...