Hello gurus,
I have done generic extraction on table OSMON,
the feild which i have included in are,
SERVER(Server name)
1,ADATE(Date of analysis)
2,CPUMAX(Max. CPU usage for 1 day (percent), av. value for 1 hour)
3,CPUAVG(Av. CPU usage in percent)
4,PAGEINMAX(Memory paged in (KB), maximum for 1 day, av. value 1 hour)
5,PAGINAVG(KB paged in, av. value for 1 day)
6,DRESPMAX(Max.disk response time (ms) for 1 day, av.value for 1 hour)
7,DRESPAVG(Av.disk response time (ms) for 1 day, av.value for 1 hour)
8,CPUUSRAVG(User CPU utilization in percent)
9,CPUSYSAVG(CPU system utilization in percent)
10,CPUIDEAVG(Idle CPU time in percent).
and I have to make it as delta,and for this have taken ADATE object for delta,
my question is am i right to take delta on Date object or should i go for another object and why.
as my requirement is to show in BW report how much USER are utilizing system.
Help me on this
Thanks & Regards,