cancel
Showing results for 
Search instead for 
Did you mean: 

Range Prompts

former_member402770
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

mhmohammed
Active Contributor
0 Kudos

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

former_member402770
Participant
0 Kudos

Hi Mohammed,

Thanks for your reply..I think i have not putup the question in the best way what i wanted to achieve.

Here is what i wanted to create the fiscal year/period prompt object with Single Value Selection range option.

Let me know if you still couldn't get my issue. I tried creating prompt for fiscal year/period object as Single Value selection range but doesnt result me  to show like the screen from my first post.

Thanks,

Dinya

mhmohammed
Active Contributor
0 Kudos

Hi Dinya,

If you created a single value selection prompt, how can you get that prompt screen to select a range? It has to be a prompt with BETWEEN clause, only then you can select a start and end value.

Where do you want to create the prompt? Universe or Webi report?

On a 2nd thought? Are you talking about how the prompt looks visually? Like, you should be able to select the start and end values from just one list? Like you are selecting 001.2015, click on the > icon for start value and again select the another value say, 003.2015 and click on the > icon for end value? Isnt it?

If yes, I think Crystal Reports has that feature, Webi might need Java SDK work to achieve that.


Thanks,
Mahboob Mohammed

former_member402770
Participant
0 Kudos

Hi Mohammed,

It is prompt with BETWEEN clause, only then you can select a start and end value.

Where do you want to create the prompt? Universe or Webi report?  Pls. write both options will be usefull..

Could you please help on this with an screenshot to achieve this.

Thanks,

Dinya

amitrathi239
Active Contributor
0 Kudos

Hi,

Benefit of creating the filter at universe level is reuse the filter in multiple webi reports without create prompts at webi query level.Other benefit  is when  requirement to filter the data in webi reports based on the single date/month year (without entering the range) and pull like last month data,year,week data.In this case user will enter only one date then webi report will pull the data based on the date upto 30 days/year data.

But in your case where you are defining date range then you can create universe filter or webi level prompt.both are same.it's upto you where you are more comfortable.

Universe filter:Right click on the universe class->new filter->select the filter type "Business"

Webi query prompt:Drag the object in the webi query filters panel and select the operator and select as prompt.

Amit

former_member402770
Participant
0 Kudos

Hi Amit,

  Thanks, Great it looks easy to me now, i shall try work towards on following this and let you know for any issues..

Thanks,

Dinya

former_member402770
Participant
0 Kudos

Hi Amit,

  Could you please put the result of webi snapshot showing the range prompts. Just wanted to ensure as this your ouput is same as like my first post to take it further.

Thanks,

Dinya.

amitrathi239
Active Contributor
0 Kudos

If you are getting desire results in webi then prompt screen doesn't matter.

Amit

Answers (0)