Did you try using a parameter instead of the filter functionality in the table object?

Try filtering after you apply a format ... seems like that isn't done given the picture: with the column selected:

One approach: Convert the column to text in your query first ...

Are you asking about the count of report runs by report/user/datetime?

BIP Auditing is what you want/need ... + to ​

What page size are you using?

Perhaps use the database to dump the data to a file and not rely on a reporting tool to do it - you'll skip steps, save bandwdth and simplify the management of the solution. OBIEE Foundation is not designed to be a data pump.

Term it a Running Quarter ... and see if they bite! 

Calendar picker won't work for you ... in that you can't drive the date from a query; so you can't specify a default of specific quarter start and end dates. Best you get is a dynamic range of dates: {$SYSDATE()-90$} to {$SYSDATE()$} or {$FIRST_DAY_OF_MONTH()-90$} to {$FIRST_DAY_OF_MONTH()$}

If I understand correctly ... you want the quarter start and end as your defaults and the user can change it or you want the report to automatically run for the most recently closed quarter? You won't be able to do it with the Date (Calandar) picker -- I don't think ... BUT using a drop down and list_of_values you can…

utl_raw.cast_to_varchar2(dbms_lob.substr(DELIVERY_PARAMETERS,2000,1)) DELIVERY_PARAMETERS_TXT

evaluate the date if less than or equal to your 'target' date do the sum else NULL ... don't sum a null OR sum it up for every date (and get the flat line like you have) then wrap that sql with a case when the date >= target then use the null and not the re-summed value wrapping a SQL: SELECT x.DATE, CASE WHEN x.DATE >=…

Then please close out this thread ...

Then you will have to use the Menu type and not the Date type ... refresh others shows up for Text and Menu types

'NULL' is not NULL ... and you really have a department where it's buyer is 'NULL'? Also ... your drop list is going to render as follows: SELECT PARAM_DISPLAY, PARAM_VALUE so this doesn't work: Dept select 'NULL' dept_name, -999999 dept from dual UNION select dept_name, dept dept from deps where :PM_BUYER = 'NULL' OR…

"How can I get the expenses by day in a BIP Data Set ? I would like to have the expenses of my projet from the data date to the end of the project." I gave you what you asked ... I have no idea what source you have - how the data is laid out, etc ...

replace the these bits with what you have ... with dts as ( SELECT LEVEL n, <date: 1 day before project start date> + level AS dt FROM DUAL CONNECT BY LEVEL <= (<project end date> - <project start date>)), num_days as ( select max(n) dys from dts) select x.*, (tot_exp/d) daily_avg_exp from ( select cal.*, (select dys from…

Do it in the/a query ... this will give you the dates for your project: SELECT LEVEL n, <date: 1 day before project start date> + level AS dt FROM DUAL CONNECT BY LEVEL <= (project end date - project start date) Then you can add in the daily average: Total expenses / number of days and put that on each row in the above…

Seems like you are trying to make the BIP tool into what it is not designed for ... take a look at : OBIEE Commenting & Annotation Tool | Collaborate with BITeamwork and see if this helps especially if you embed your BIP reports into an OBIEE dashboard ...

Not positive how you'd do it via a template, but if you know the max number of rows that will fit on your page (vertically), you could 'cut' the row set by that number and run the data in chunks sorted...