I met with the requirement that the dashboard prompt to select the month, month values were shown descending from the current month, but that the default prompt is not the current month, but the month that precedes him bezprostřeně. The data for the current month is not yet definitive, but should also have access to it. For example - now in August 2010 - has to offer prompt months 2010/08, 2010/07, ..., but the default value, however, the 2008/07 . The solution is based on the use of two variables storage. In the repository I created two initialization blocks and aktualni_mesic aktualni_mesic_1. Each block contains one variable and mesic_aktual and mesic_aktual_1.SQL commands are used: select to_char (sysdate, 'YYYY / MM') from dual or select to_char (add_months (sysdate, -1), 'YYYY / MM') from dual Then was left alone to create a prompt in the "View" choose "SQL Results" and insert the following statement:SELECT TIME. "Month" saw_0 DWH FROM WHERE TIME. "Month" <= valueOf ("mesic_aktual ') ORDER BY DESC saw_0 In the "Default" again, choose "SQL Results" and insert the command SELECT TIME. "Month" saw_0 DWH FROM WHERE TIME. "Month" = valueOf ("mesic_aktual_1") It is obvious that DWH is the name of the presentation catalog. This solution ensures that that the selection of the month at the prompt to set the month immediately preceding the current month as the default value (ie in our example, 2010/07), but also allows the user to select the current month (2010/08). Because the solution uses the system date, the default value is automatically shifts each month.
Posts
