topic Re: how to validate reports and test reports in QlikView

how to validate reports and test reports

Sat, 08 Feb 2014 17:42:29 GMT

hi can anybody tell me how to test reports if we dont have db permissions to write query to check.

regards

Mahesh T

Re: how to validate reports and test reports

don_qlikview — Sat, 08 Feb 2014 18:53:06 GMT

I don't think you'll be able to test until you have permissions to access the database.

Re: how to validate reports and test reports

agilos_mla — Sat, 08 Feb 2014 19:46:24 GMT

I'd suggest :

- Validate the earliest possible and centralize the test (it's Lean SixSigma ! ) If you use use 2 or 3 tiered QVD architecture, please validate QVD content

- BI validation is not the same way as operational systems, what I do commonly : to identify particular, extreme case and validate QV results against these cases. If OK for them, we could reasonnably think it's OK for standard cases.

- Anyway is some case the expression used in QV app are so powerful (set analysis) that it will requires complex SQL queries

- Use JMeter Regression tools if you want some automation.

- look at third-party products such as QualityGates.com, that proposes now a connector to QV App that might allw to validate application againts business rules, expected results and much more...

Michael

Re: how to validate reports and test reports

IAMDV — Sat, 08 Feb 2014 20:09:23 GMT

Hi Mahesh,

Either you or someone must be running queries to extract the data from DB right? And I'm assuming that you have QVD layer where you have the extraction layer.... you can use it for now to test the data.

Cheers,