topic Re: Repeating RequestID and Repeating JobID :DataModel in QlikView

Repeating RequestID and Repeating JobID :DataModel

poonam_kulwal — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have attached a sample data. Here I need to calculate

· How often a job run/ frequency of job run (Hourly, Daily, Monthly…)?

· Which Source and Destination Engine has maximum load (Hourly, Daily, Monthly…)?

My point of difficulty is, I have repeating RequestID and Repeating JobID. I am planning to make RequestId and JobId as Key. I am not sure about this.

Also I am planning to create calendar based on Job Start time.

I need to perform all my analysis Hourly, Daily, Weekly, Monthly, Yearly.

Kindly guide me on how to go for creating data model.

Also formula for above two calculations.

Appreciate your help.

Thanks & Regards,

Poonam

Re: Repeating RequestID and Repeating JobID :DataModel

ahaahaaha — Fri, 07 Apr 2017 10:05:32 GMT

Hi Poonam,

Variant of the solution is shown in the attached file.

Comments:

1. If the analysis sections is not enough (hourly, daily, monthly ...), the missing ones just need to be added to autoCalendar.

2. Based on the initial data, the operating time is much shorter than the minimum analysis interval (hour). Therefore, any particular job is attributed to the hour of "StartTime" this work. A possible transition to the next hour or the next day was not taken into account, although it is not difficult to make a small modified encoding to add additional rows when loading the original data. However, does this make sense in your case?

3. For example, several charts are given. The rest can be built by analogy.

Regards,

Andrey

Re: Repeating RequestID and Repeating JobID :DataModel

poonam_kulwal — Tue, 11 Apr 2017 06:56:25 GMT

Thanks Andrey. THis is very helpful.