I would say Thomas already said most of it ... Your source isn't the best you can have, mixed granularity in a single table is the worse to use in an analytical tool like OBIEE generating queries on the fly if you don't model it right. So following Thomas advice you must model splitting the multiple granularity into…

+1 Christian But you can still edit the table opening it from the bottom-left part of your result tab screen where you have the list of all the views included in your analysis.

Hi, Just click on "Define Parameters" in your action link and set the parameter pointing to your column.

Try to replace DateNumber with CAST(DateNumber as VARCHAR(8)) or something like that making this number a varchar ...

You must manage the null : like adding a CASE WHEN all around to not execute that formula if any of the parameters are null, or manage it by setting a default value if null.

What is the type of your columns DateNumber, age and birth_date ? (the OBIEE type) And can these columns be null ?

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…