Don't change the report criteria

[universal4]

I have some interesting things take place while looking at stats and once I realized it, I performed some tests and had interesting results.

I noticed that when I would run a report and choose ANY additional display criteria, such as disply at first by date, and the second query profile or brand that the results changed.

What I mean is if I run a report and display current month by date and brand, the top level revenue will be a zero, but if I only choose one query, date only it will give me the correct figure.

If I run the report from Jan 1, 2010 until today, and display by month only the report is correct and I see the accurate Top Level Revenue, but if I add a second query the rersults set the revenue back to zero.

Originally I thought the problem was the second query and thet it would only allow one query, but further testing disproved this.

If I run the report (for the year so far) and disply only by brand the revenue figure is zero, but if I display by month it's accurate.

This leads me to believe that any time the database is queried by ANYTHING other than the date, the query fails. Obviously more test queries using different scenarios should be run to verify this, I just don't have the time to put into this for a program that has had these kinds of problems for more than 10 months, and it's ironic that when I took the time to put in the effort as I did this morning, I discovered more than the developers probably know in 10 minutes and they have had 10 months.

Of course if the affiliates had been made part of the testing and beta development, this might have been discovered previously, since the softweare is being written for us, we should have been part of the development...

Rick
Universal4

[EP Relations]

Hi Rick,

I am looking into why this is happening an I will hopefully have an answer for you tomorrow.

Robin

[EP VPMarketing]

Hi All

Robin will update later in the day on this issue.

Thanks.

Marc

[EP Relations]

Hi Rick,

Thanks for bringing this issue up. We are aware of these problems in the reports with getting top level revenue share by using different search criteria and I can assure you this is one of our top issues that the new development team has been dealing with. Changes are expected to take affect really soon and we acknowledge the significance of the problem and we are treating it as top priority.

As soon as I know when you will be able to run reports in this way I will let you know.

Best,
Robin