Skip to Content

Range Prompts

Hi,

Can this be possible to show in case of prompts at webi level like as below:

i tried with many options to show the fiscal year/period prompt to look like above, Could you please help to achieve this either at universe level or webi level.

Appreciate your help to achieve this.

Thanks,

Dinya.

Capture.JPG (28.5 kB)
Capture.JPG (28.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 22, 2015 at 03:18 PM

    Hey Din 44,

    First things first - what does Period mean here? the month number or 1st half or 2nd half in a year?

    If it means the month number, then - I've Sybase and I created this object in universe to show Year/Period as you wanted.

    case

         when

              month(reporting_date_dim.reporting_date) < 10

         then

              ('00' + cast(month(reporting_date_dim.reporting_date) as char(1)) + '.' +           cast(year(reporting_date_dim.reporting_date) as char(4)))

         else

              ('0' + cast(month(reporting_date_dim.reporting_date) as char(2)) + '.' +           cast(year(reporting_date_dim.reporting_date) as char(4)))

    end

    What this formula does is, if the month number is less that 10, then it concats with '00' in front of the month number, '.' in middle and year number at the end. Obviously, the Month and Year numbers are converted to a character. And if the month is 10/11/12 the concat with just '0'. Disadvantage of this formula is that the values are string now, so the sort order is messed up and sorting is messed up.

    This is what I get when I click on Show values in universe.

    Let me know if this helps.


    Thanks,

    Mahboob Mohammed


    Snap 04.PNG (11.7 kB)
    Add comment
    10|10000 characters needed characters exceeded