ETL Hour Period

[gzooby]

Hi Everyone!

Iīm having the following trouble. Client want to generate Historical Report in CCPulse. The report is "hourly", and for a period of a month.
As they work only 6 hours per day, the report is very long and with a 18 hours all zero values.
Client asked if itīs possible just to keep information of their working hours.
Is it possible to establish a time period for DataMart, so only within that period the information will be stored? Or is it possible to establish an hour range for historical reports in CCPulse, hiding columns, etc?

Regards

Z

[Kubig]

I have arrange similiar need from customer site and done it within database. I have created triggers which "copied" the unnecessary data to some custom table (with same structure as current table) and afterward delete rows which are not necessary to report. May be, there are other - easy way how to achieve it, but this way seems to be easy to maintenance and have not any other negative depends on reporting solution for current or future needs.

[Adam G]

You might want to take a look at the difference between "Time Periods" and "Time Slices" in your reporting documentation - and also how to apply a Filter which only records or returns non-null values.

AG

[gzooby]

Hi, Thank you for your responses. 

Kubig: Thank you, Yes, that idea was in my mind, i think i will give it a try, because in ETL Runtime and CCPulse documentation I couldnīt find anything.

Adamgill: Thank you, so yoou think itīs possible to filter this data, which documentation do you refer of?

Regards

Z

[Kubig]

Cannot imagine how to filter it on SS filter level, so I am wondering how to achieve this need through filter configuration.

As I wrote, there can be option through mentioned TimePeriod or TimeSlices (may be), but this part of configuration can "negative" depends on rest of collected statistics/data. So, from my point of view it is better to make it through own way. Just my opinion.

[cavagnaro]

I think he meant a SQL filter.

[Adam G]

I think I meant SQL, too...

If it is simply that you want to run an historical report through CCP+ for a particular time period, you should have no problem to constraint the hours of operation, through setting a TimePeriod for the Stats that you need.  As Kubig points out, using a TimePeriod can be difficult, if you have other Stats that you still need to run for 24 hours, but it is not impossible.

Isn't it nice to have options..?

[cavagnaro]

Lol
I meant that you (adam) meant a SQL filter and not a StatServer filter one.
I only see Kubig option as unique possibility but don't like to.delete data never. When it is needed to show a zero, that no interactions are there you will end blind. Doing this via a BI reporting tool is always the best

[Adam G]

True - and I realise we are rambling on without much input from the original poster!.  So...

Why use CCPulse+ as the basis for creating your historical report?  Is it so that the 2 "reports" match?  It would be much simpler to use CCA/Hyperion/Crystal/Whatever and simply filter out the dates, times and NULL Stats you don't want to see, historically.

Good point though, cav - NULL is [b]not [/b]ZERO - never was and never will be!

[gzooby]

The problem is the client is very acustomed to work with CCPulse, and they want to continue in this way. In addition to this, the y donīt wan t to spend more money either becuase they are a ver small client. Iīm going to try implementig what Kubig say, cloning the ETL database for storing all data, and removing from this one the information that itīs not of their interest

Thank you for your help


Z

[Adam G]

Understood - thanks for the clarification!