3257177 wrote:But I am sure formula is correct. 3257177 wrote:...but for previous Month MTD and previous year same month MTD is not working as expected. You are sure it is correct and you say it isn't working "as expected", but still you don't want to post the exact formulas you are using for the 3 cases...

So 29 Feb 2016 will never exist in your results as well as 29-31 Jan 2017. Define the full logic with the business first, covering all these weird cases first. Clearly challenging them on their decision, the technical solution for that logic could change based on the answers ...

Assuming you are talking about BI Publisher 11.1.1.9: https://docs.oracle.com/middleware/11119/bip/BIPAD/data_sources.htm#jdbc_ds

Publisher can't come with all the exist JDBC connections out of the box, just because there is a huge number of JDBC drivers for various random sources. But Publisher is supposed to be able to use your JDBC as long as it is a standard JDBC once you configure it properly, that's why the doc explain where to copy files and…

OrientDB seems to have a JDBC driver, BI Publisher can use your own JDBC drivers, you just need to connect the pieces together. Look at the BI Publisher doc on where to put the JDBC driver files and how to configure it. To get the JDBC for OrientDB you need to get it by yourself or ask them.

As a side question, let's say current date = 28 Feb 2017 What is your PMTD and PYMTD ? (keep in mind 2016 was a leap year, 29.02.2016 was a thing) Because the answer to your questions first depend on the business rules behind these things.

Not a problem and welcome Just post everything you have, even what seems obvious or useless to you (hiding sensible information like names etc.).

3921633 wrote:Thanks for being so warm and welcoming to a newbie. Just to be very direct: nobody is telling you to go away or that the question is stupid or anything. We are really trying to explain why there isn't enough in the thread to even just guess where to look for something. I have been in your own position: I…

3921633 wrote:It seems quite precise to me. There is a strict correlation between the effort put into asking a question (and the "quality" of the question) and the number and "quality" of answers. You are free to still believe it's quite precise, but based on the lack of replies I would maybe question that aspect. You…

Of course 2,147,483,647 and 4'294'967'295 are pretty famous numbers. But no thread is too simple or obvious to point out that a minimum of effort is required in asking a question, or why would somebody invest his time in providing an answer?

Yes, it will be confusing and you better document it more than usual. It's one of the sad issues you bring with you for long ...

Sorry but why did you call your folder "Oracle_Home_12.2.1.3.0" if it's OBIEE 12.2.1.4 ? The issue is your initial first 12c install didn't adopt the correct structure, when you start with the domain inside the product folder, this one will have to stay forever .... But it isn't a big deal, the oracle home isn't dual but…

The "suggested solution" given by Doc ID 2161550.1 is the issue ... That piece of information is accessible only to people having a valid support contract. So simply says you applied the solution of that Doc ID and still it isn't working.

Please remove copy/paste content from MOS documents. You can't post it in a public forum, if you want to post that content you would need to move your thread to

Way too much context provided Click the button there on top and it's fixed ... More seriously: Context, version, environment etc.

The more effort you do in asking the question, the more effort people do in providing answers...

Do you talk about analysis ( OBIEE Answers, dashboards and analysis) or report from BI Publisher?

As posted 10 days ago ...

As Joel said the certification matrix give you an info on what minimum version. Just worth adding that the export in PDF isn't done by Acrobat Reader or any other tool installed on your client, it's done by the server itself, therefore the export will always be successful from a client point of view. And I never heard of…

What you look for doesn't exist out of the box. There isn't any privilege that manage that. Catalog privileges define what you are allowed to see or not in the catalog and for every single object (the links to edit or expand or not). From a functional point of view I'm not sure what you try to achieve, sounds like a…