You telling that to the BI server if you want BI Server to act on this?!! You need to enclose the same in CASE statement.

this is fixed in Version 11.1.1.7.150120(Patch 20124371) whats your version?

You need to look into join and content level for fact with department.

How you are calling that variable?

Check this How to add custom font in Oracle BI 11 analysis

@ Christian You allways there for us to correct us, thank you. My wording is wrong Group i mean case when "Time"."Year"<2005 then 'Year <2005' else 'Year>=2005' end this would show up as

Pull another ProductName column and use case statement for grouping required products. In the product hide this and set aggregation ie. sigma

Check this https://forums.oracle.com/forums/thread.jspa?messageID=10743192

Assuming everything is up there suggested above. Now doubting your model and data. Without looking your model and data granularity its hard to tell. If Post got more info then anybody can suggest something.

Try to get the BI Physical query and run in the database if you see data as expected then I would check rpd database properties for Null or config file if any.

Check this doc 2087801.1

you make sure all dims got a record with row_wid=0 or check joins

Use SQL for that prompt to include specific metric in where clause like select fiscalPeriod from TimeDim WHERE Metric>0

+1 Check this https://intelligentinsight.wordpress.com/2012/09/23/obiee-11g-dynamic-action-link-url-for-drilldown/

Check this Doc ID 1315685.1

assume you have date field in the report and selected current month from prompt Date would show some date within current date based on your data, you may use min(date by PromptMonth) this would give start date of selected month from prompt use datediff function to get previous month. Try to get an idea what I'm suggesting!…

In the report take the date column with expression min or max(date by SelectedMonth) you may get previous month using this date field for further calculations bla bla ...

Sorry for jumping in middle Did you cast to int after substring

CASE WHEN "Agreement Sent Date"."Date" IS NULL THEN 0 ELSE TIMESTAMPDIFF(SQL_TSI_MONTH, "Agreement Start Date"."Date", "Agreement Sent Date"."Date") END OR CASE WHEN "Agreement Sent Date"."Date" IS NOT NULL THEN TIMESTAMPDIFF(SQL_TSI_MONTH, "Agreement Start Date"."Date", "Agreement Sent Date"."Date") ELSE 0 END

Something like when PromptA='A1' and PromptB='B1' then 'None' when PromptA='A1' and PromptB!='B1' then 'B Prompt' when PromptA!='A1' and PromptB='B1' then 'A Prompt' condition value 'A Prompt' goes to PromptA field in report condition value 'B Prompt' goes to PromptB field in report