Will not looks nice but ... Try with something like: TIMESTAMPDIFF(SQL_TSI_MONTH, TIMESTAMPADD( SQL_TSI_DAY, 1 - DAYOFMONTH(birth_date), TIMESTAMPADD(SQL_TSI_YEAR, age, birth_date) ) , TO_DATETIME(DateNumber,'YYYYMMDD') ) I imagine it will return only integers but in case you end up with a number with a decimal part add a…

Why do you want to keep it constrained with "All Prompts" ? Just select manually all the columns except for the 2 Top n giving you problems .... Or change the Top n prompts to be variables problems and not column based (this is just the value of "n" and not the value of the column itself, so a variable prompt would be fine…

Did you test the pieces of the formula independently starting by the one returning you the last day of the month? What is "DateNumber"? Is it a sysdate or something like that? Don't you have a real date next to it instead of having to transform your number in a date? The formula you wrote here has no chance to give you…

Hi, TRUNC = FLOOR : your trunc is to remove the decimal part of the number, so FLOOR is going to do the same thing MONTHS_BETWEEN = TIMESTAMPDIFF(SQL_TSI_MONTH, <date1>, <date2>) And I'm almost sure that your translation of LAST_DAY isn't returning you the right value .... To get the last day of a date in OBIEE you are…

On a 32bit Office 2013 it works (I have it in front of my eyes), that's for sure

Well .... I must admit I never test it on an Office 2016, but also on Office 64bit. And not sure which one (if not both) could be a problem ... Would be great if somebody else here around used it on Office 2016 or on an Office 64bit and can post a feedback.

Not sure publisher has the same logic as a connection pool (sharing the connection between the various users), so wouldn't be surprised if Publisher open a new connection every time it needs one and close it when the data are retrieved. And there are some server settings so there probably are some settings that can be set…

You must tell OBIEE that you would like the COUNT DISTINCT not at the row level but at the "US" level. So you can try by using the AGGREGATE(... AT ....) function if you have a hierarchy containing your "Action Performer" and its upper level, or try by adding a : by "The column name of the column with the US value" In this…

Actually any answer between 8Gb and 2Tb of RAM is right ... You must know what kind of usage you want to do (seems to be everything based on what you said), but how many users? Total and concurrent? Of course if you can get an Exalytics box with 2Tb of RAM go for it ! You will always find something to do with it ... For…

answer 1: no connection pool .... If you create a connection in the Publisher admin page it doesn't use any connection pool but connect by JDBC based on the provided info answer 2: look at answer 1, there is no connection at all between Publisher JDBC sources and RPD connection pools.

A quick reminder: backup your catalog before to play with search / replace, mainly if you never did it before !!!

It's not supposed to be in the SYS schema but in the BIPLATFORM one ... It's not important at all, Thomas gave you a piece of code to generate one if you prefer. I have the feeling the question isn't really about a time dimension but more about how OBIEE works. An employee count by month? Join the time dimension with your…

Don't you have in your Start menu a folder called "Oracle BI Publisher Desktop" ? There inside there is a shortcut "Enable or Disable Template Builder". (at least these are the names in 11g, don't have one available in 12c, but I'm optimist they didn't change too much ...

Hi, Are you sure your Office is 64bit as well? Because for Office most of the install are still 32bit (the 64bit version of Office is really only for some special needs with huge files etc.). So you need the 64bit version of the Admintool because this one goes with your OS (so Win10 64bit), but the publisher plugin is…

Please don't double post: Installation of OBIEE 12c in linux centos vm Because now you have 2 threads for the same issue and instead of having the benefits of the community work you split resources in 2 ...

Well, there are many ways to do what you describe, and you also don't need a table with all the dates if you don't mind the holes when nobody has been hired or terminated at a given date... And you must also have a table named S_ETL_DAY in the system schema the rcu created when you did the install and that one is quite a…

Hi, Are you asking how to do it in practice (add a logical table, add an hierarchy, make it a calendar dimension) or you just ask for a table containing .... dates?

Yeah, they skipped the first 12c releases for OBIEE .... If you got all you were looking for you can maybe close the thread? Actually it's still This question is Not Answered.

Hi, OBIEE 12c require FMWH 12.2.1.0.0 at least and comes with Weblogic 12.2.1.0.0 by default. So 12.1.3 isn't supported ...

Hi, Did you try to just get your time as a varchar? Because to achieve what you look for you must get rid of the date component and keep only the time (or transform the date to always be the same date), so in OBIEE you have the HOUR function returning you a number between 0 and 23 and you can then format it looks like the…