Morning,
newbie help please.
i have created a caller exit by inputs report and added in ‘session hour’ to get an hourly view of data. i would ideally like 15 min intervals if anyone knows if thats possible and what to add to my query.
many thanks in advance
Darren
dazhodgson (BOB member since 2015-12-16)
What are caller exit by inputs?
What sort of timescale are you looking at - just previous day for example?
‘caller exits by inputs’ is a report telling me how many caller exit’s occurred to specific agent group from an IVR.
ive set the report up and I can get the data per hour of day, but I’d like it per 15 min interval if you know what i need to add to my query please?
yes, just previous day.
Cheers,
Darren
dazhodgson (BOB member since 2015-12-16)
No idea what an IVR is in your organisation.
Remember that BO is an industry-agnostic tool so business terminology will vary considerably. I’m currently working in finance but have previously worked in the music and construction industries, all with Business Objects 
So, you have an exit date/time? What database are you working with, e.g. SQL Server 2012? Also, do you have the ability to add objects to the universe?
apologies yes, that is very true.
sorry my knowledge is limited. the screen shot is what i currently have. i added ‘session hour’ to my query then added the column from that. that gave me ‘exits per hour’ on the table.
i had assumed (and we all know what assumed did!) that there would be a ‘per 15 mins’ data identifier i could add to my query, but i just cant find one.
do you know of one or is it simply not that easy?
dazhodgson (BOB member since 2015-12-16)
The formula below will convert the current minute to one of 0, 15, 30 or 45
=Floor(ToNumber(FormatDate(CurrentDate();"mm"))/15)*15Take that a step further to tag the floored minute back on to current date and you get:
=ToDate(FormatNumber(ToNumber(FormatDate(CurrentDate();"yyyyMMddHH"))*100 +(Floor(ToNumber(FormatDate(CurrentDate();"mm"))/15)*15);"0");"yyyyMMddHHmm")For your solution, you’d then replace CurrentDate() with [Session Hour] or whatever your date/time object is called. You’d then need to format the date (right click, Format Number, pick the appropriate one out of the date/time section).
That should put you on the right path but will only give you dimension values where there are calls in that 15-minute period.
thank you very much, that gives me something to work on certainly, although i much preferred a drag and drop!
thank you for your help, its very much appreciated
dazhodgson (BOB member since 2015-12-16)
Drag and drop helps but you’d need your universe developer to help you with it. Perhaps if you create the solution at report level, they may be able to take a look and develop similar at the universe level for you, especially if you can crack it today.
makes sense, thanks for the advice…
dazhodgson (BOB member since 2015-12-16)
I have to do something similar like this where I need to created the buckets on the top like 9:00…9:15…12:00
each bucket containing sales
But I would like to set this up within an object in the universe
di652 (BOB member since 2005-02-24)
Well, then add it to the universe. Or get your universe developer to add it to the universe. The primary thing to keep in mind is that universe objects need to be built with the flavor of SQL peculiar to the database (especially important with dates).
Lugh (BOB member since 2009-07-16)
Creating buckets in the universe I the direction but should I go with just 4 … 0-15, 16-30, 30-45, 45-59; something like this
But how can I use this… bring into report and concatenate the hour somehow that it would make sense or…
Sorry, I like to talk things out loud to help me think, sometimes I draw blanks…
di652 (BOB member since 2005-02-24)
Create a dimension with the buckets.
The SQL code (presumably a case expression) will sort out which transaction goes in which bucket, so you don’t have to.
I think I am same predicament as di652 but I am looking to spread out the buckets within each quarter of the hour of the day!.
I came up with a SQL to decipher between the quarter hour just need to 
and see if I can figure out slicing it into individual buckets I plan on bringing in to a report(thinking Crosstab as the structure for these buckets)
toscajo (BOB member since 2002-09-04)
What’s your requirement, fifteen minute buckets throughout the day?
For example, you’d want to see 12:13 as 12:00, 12:16 as 12:15 etc., where each time slice represents 15 minutes?
If so, you could build the following in Webi:
=RelativeDate([Transaction Date Time];-(Mod(ToNumber(FormatDate([Transaction Date Time];"mm"));15)/1440))That would take any time that is not hh:00, hh:15, hh:30 or hh:45 and round them down to the nearest one.
So if you had 6 transactions as follows:
13:13, 13:14, 13:44, 13:45, 13:59, 14:01
They’d output as:
13:00, 13:00, 13:30, 13:45, 13:45, 14:00
You’ve then got a full sortable set of data, rather than worrying about text-based time buckets.
This works great !!
Wondering how to do it with missing or if it can be done; I think they would like to display the other buckets even when there is no data available.
so
Date…9:00…9:15…9:30…9:45…23:45
01/01/16…9…2…
01/02/16…5…3…10
…
…
toscajo (BOB member since 2002-09-04)
You’d need a separate data provider that brings in the time spans that you want.
Thanks Mark, as much as I didn’t want to do it I did it within WEBI as it was an urgent thing.
toscajo (BOB member since 2002-09-04)