Ability to Group results of a DMI query
Hi All,
Thought I should post it here before I submit an RFE for this.
A customer would like to be able to group the results of a DMI report.
ie: Browser Hardware dimension, would like to be able to report operations, operation times for iPhones and all other phones as All Other. As you can see this looks like a regular business reporting use case. Surprised that DMI does not have anything for this OOB.
I've tried creating user-defined metrics, capturing user-agent details, running around in circles, but none of them give me the above mentioned reporting flexibility. Given that we are trying to push customers to use DMI over EP, this look like a feature DMI must have, please let me know if anyone else managed to get this working in anyway.
Thanks,
Sid
Sid,
what you can do is to show two tables - one for iPhone and the other for the others.
Can you explain or show how can you create such a report in EP within one table? The reason I am asking is that EP actually calls DMI report queries, unless it taps on to BSM data which gives it certain capabilities which are not possible in DCRUM.
Best,
Sebastian
Sid,
I think we can do what your looking for in one report. Simple example that you can work with.
In the subject data section pick the dimension such as Client Hardware and make it filter and pick iPhone and add operations & operation time. Then in the benchmark section pick "Software Service, operation, and site data" as your benchmark data view, not "Software Service, operation, and site data baselines". Then in Client Hardware Filter pick Iphone but make it !=. and pick operations and operation time as the metrics. Then go to the result display section and make sure all the metrics will be shown, and then click on the metric icon metric name icon and select the table header tab and rename your metrics accordingly
Example for a table Report...
Operation Time = Operation Time - iPhone
Operations = Operations - iPhone
Operation Time Benchmark = Operation Time - All other Mobile Devices
Operations Benchmark = Operations - All Other Mobile Devices
If you add time that will work also, If you need a chart I think you would just General Alias which will only change the metric names for that report section.
Thanks,
Mike
Thanks for the input guys,
Unfortunately we need both of them on same table (comparison between iPhone and rest) AND we need to be able to display non iPhones as "All Other".
Getting the required data is not an issue but being able to display it to executives in a way they understand is.
Sebastian - I haven't tried this in EP, I was asked to encourage all customers to move away from EP given the flash issues we've had with it. Do you want me to make this an RFE?
Thanks,
Sid
Sid,
The approach I outlined allows you to have them in the same table unless I misunderstand what you mean the same table. Did you try it?
Regards,
Mike
Sid,
you will need to enter RFE for that.
When you do please make sure to give examples from the EP if the rationale behind this RFE would be to recreate existing EP reports in CAS.
As I'm responsible for handling use cases from customers transitioning from EP to CAS, please let me know if there are any other cases where EP reports can't be recreated in DMI.
S.
