MrsJ wrote:Our issue is ... What's the issue? You describe what you did, but not really what the issue is ...

deahayes wrote:a report BI Answers An "analysis", a report would be a BI Publisher report, in Answer it's an analysis. deahayes wrote:...except for where the values of a field are empty . Particularly for Grand total option I set format values to Arial, however when export to Excel the blank fields are Calbri... Sorry but…

1005601 wrote:Any idea what I am missing here? Sure ... you are missing the right way of doing it The links Joel posted or additionally the EAR way of deploying a custom style will also allow you to deploy custom images, but deploying a custom folder is a lot more flexible for any future use.

Sure, same way as you would do for your user executing the analysis online.

To summarize the previous answers, which are globally all right and cover the few possible ways you did your prompt the situation is simple. Do you use the calendar-view prompt? (the one showing a real calendar) If YES then forget your requirement at the prompt level, this visualization of the prompt doesn't support any…

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 ...