OR you could add the last day of the month column to your time dimension table ... so when you select year + month you can get the column for last day ...

Use of information/data drives your design ... you HAVE a design that doesn't line up with your USE ... here's another vote to stop and assess and align your design to the required use.

You could hide an analysis on your dashboard page that accepts the two visible prompts, calculates the last day of the month and then that is used as the filter criteria for your report's similar column - then you can use that column value in some of the views to achieve what you want.

I get the requirement ... I'm asking where is the relationship between the YEAR and the MONTHS to be displayed? That relationship is not in the time dimension, as all years have 12 months. So ... is the relationship arbitrary or is it from your knowledge of what is in the fact table (you know there is only data for January…

It matters if performance matters and performance always matters ... do it in a flattened hierarchy structure via ETL; simpler to model in the RPD; easy DB retrieval.

You need to determine whether or not the deleted records (from the source) are material to analysis or not ... they might not be for day-to-day operational/tactical reporting, but what about analytical/strategic reporting? A deletion of a dimensional record from the source HAS an impact on the warehouse star schema as you…

Where do you want to store and administer the rules of which months get shown for which years ... this doesn't seem like the appropriate place (in a prompt) to be driving that. You need a separate logical column in which your CASE is run - use that column in conjunction with the year to get the results you want.

+10,000 to @rmoff for this: http://www.rittmanmead.com/2014/04/bi-forum-2014-preview-no-silver-bullets-obiee-performance-in-the-real-world/

set up a second fact table that 'aggregates' the rate at the appropriate level ... then level-based the factors ...

Your Rank() ... are you ranking BY anything? going to try to recreate something similar ... On second thought if you only want the top 25 Ranked Agent IDs (independent of Dist ID) then apply a filter in Criteria tab to the rank(activations) to be less than or equal to 25 ...

Looks you've got a fact at various time levels, you just need to store and model your factors at the same levels ... then you can combine the fact column and the factor at the appropriate level. How do you have the physical model now? We'll start there...

no where clause? post the whole SQL statement ...

Take a read through here ... Managing Performance Tuning and Query Caching - 11g Release 1 (11.1.1) 7.6.3.4 Changes to Dynamic Repository Variables The values of dynamic repository variables are refreshed by data that is returned from queries. When you define a dynamic repository variable, you create an initialization…

does the physical SQL have the filter condition in the where clause or does it have the filter column included in the selected columns / group by clause? Post the SQL

Is the key to the lookup for the rate taking into account BOTH origin and convert-to currency codes in addition to the date? Typically when doing this type of work the ETL is used to baseline the currency at the time of recording then you have a single origin currency to start from ... so you have a configured local…

You can use the dense/sparse lookup functionality in the PHYSICAL mapping expression of the logical column as well as doing it in the logical expression. So You can decide to multiply IN the retrieval, or multiply AFTER the retrieval. in this blog entry (Oracle BI EE 11g - Lookup Tables - Sparse and Dense Lookups - Rittman…

As @Christian Berg has also pointed out ... [nQSError: 27005] Unresolved column is coming from the BI server (unrelated to your security implemented in the web catalog). You have selected columns in the Criteria tab that either 1) no longer exist in your subject area or 2) the user you are logged in as does not have…

Yes it is possible ... here's an example right to the point: Oracle BI EE 11g - Lookup Tables - Sparse and Dense Lookups - Rittman Mead Consulting You'll just have to change the date key going in to be a variable set by the prompt ... OBIEE - How and where can I set a Request variable (SET VARIABLE) ? [Gerardnico] note you…

if you have an RPD that has NO security in it, what is the result? Do you get different behavior on DEV vs TEST vs PROD?

What about a case statement that flags BU/Non-BU? then show the Total for each flag?