To be more specific: 1) I'm using Oracle Business Intelligence 11.1.1.7.140527 2) By "report" I meant Dashboard containing filterable Analysis (OBI Answers object). It has nothing to do with BI Publisher. Thank you.

I've answered myself apparently. I was able to do what was required with the existing state of the physical layer (see pictures above). The only change I had to make was to change these two measures to level-based measures in business model. I set logical level of the dimension Time RP for Sale measure in table Sale SP to…

* "A_DWD_TIME_DAY"."DTD_DAY" = "A_DWF_SALE"."DTD_DAY" * "DWD_TIME_DAY"."DTD_DAY" = "DWF_SALE"."DTD_DAY" DTD_DAY column is Date data type. It is primary key of DWD_TIME_DAY table. Regading table DWF_SALE - it is foreign key representing date of sale. .... By the way I've noticed that if I specify only one time period in…

Thank you for your concern. I made this diagrams to explain current situation in my RPD and what I expect from the report. Hopefuly this will answer both questions (from Thomas and Christian). Physical layer: A_* means alias of the physical table Business model: My expectations are: Prompt: Select standard period: (select…