Serive level Target

building reports webintelligence
1

Hello All,

I have a requirement to display service level target for a particular month and this value is dynamic. Can any one help me with how to set it up. When ever I remove table level aggregation is displaying one row for each record, if I dont do that its accumalating all the targets and giving the total value.

Thanks In advance

Kasindula (BOB member since 2014-09-04)

2

[Moderator Note: Moved from General Discussion to WebIntelligence XI]

And welcome to B:bob:B!

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

how do you determine which one you want to display if there are multiple records?

erik.stenson :us: (BOB member since 2012-07-30)

4

I dont know which I month tarlget I need to set it up?
I want display for May. I have data for service level target upto 2014 May. Assuing I want to fix to this month, please let me know if you have any functionality?

Thanks in Advance

Kasindula (BOB member since 2014-09-04)

5

Hello All,

If I am not clear with my requirement above please see the table below if it make any sense to you all.

		Apr				Current	
		         Target------  Jan------Feb---------Mar --------Apr

M R01 Accuracy >99% 99.94% 99.88% 99.94% 99.93% Need to be achieved

		Jan-Apr Target  	Jan------Feb---------Mar --------Apr

M R01 Accuracy >396% 99.94% 99.88% 99.94% 99.93% Current Display

			With out Sum/Aggregation Display				
		Individual Month

M R01 Accuracy >99%----- 99.94%
M R01 Accuracy >99%----------------- 99.88%
M R01 Accuracy >99%---------------------------- 99.94%
M R01 Accuracy >99%----------------------------------- 99.93%

Another requirement is I have derived variables for last four months based on calender date and I want to display KPI for these and this I am not able to achieve in cross tab. If I take dimensions that are coming universe they are displaying respective KPI`s but not for my derived variable months.

Thanks In Advance

Kasindula (BOB member since 2014-09-04)