shakekalam

 Profile Answers by shakekalam 

• Apr 8th, 2009

 

Depending of the type of report, there can be numbers of areas it can be tested.
Few of them are like:

1) Report layout (Attributes/Metrics positions)
2) Naming conventions
3) Totals & Grand Totals
4) Validate the Sql query
5) Drilling options - Simple & Advanced
6) Prompts If any
7) Prompt ordering, Prompt Defaults (If any)
8) Metric Calculations
9) Drill Maps (Inc. Templates)
10) Security filters (If any)
11) Export/Print functionality
12) Formatting Properties like alignment, scroll bar, decimal places, etc

Hope this helps :-)

ashu_eureka

 Profile Answers by ashu_eureka 

• Jun 11th, 2009

 

Along with the above mentioned testings, you can also have
a. conditional formatting testing or threshold testing

Vivek Jain

 Profile Answers by Vivek Jain 

• Jan 17th, 2011

 

1. Report Data testing against wareHouse
2. Report formatting testing against requirement.
3. Drilling and hyperlinks testing
4. SQL generation Validation.
5. Performance Testing.

yanli

• Apr 22nd, 2015

 

more:
1. evaluation ordering
2. paging
3. Pivoting
4. prompt answers testing ( report level/prompt level/document level)
5. reprompt
6. drill map/drill path
7. integration testing (if MD upgrade involved)
8. OLAP testing (derived metric/derive elements)
9. graph/grid display per requirement
10. outline mode
and more

Nikhil

• Jul 28th, 2015

 

Tests like
Naming convention tests
Total calculations test
SQL query validations
Attribute and metric positions in the report
Drilling options tests
Prompts related verifications
Security filter tests
Formatting/export functionality tests
Threshold testing

Radomir

• Sep 21st, 2016

 

Hi. I was wondering which tools do you use to automate those tests. It would be of great healp. Thanks

Himanshu Masani

• Dec 14th, 2017

 

Can you please guide me on validating Report data against DataWarehouse.

souvik

• May 31st, 2018

 

Using selenium you can automate

Chetana

• Mar 8th, 2019

 

To validate your report data against data warehouse,please follow below some steps:
1.First write custom query(SQL) in database to get the required expected result
2.Compare no. of rows return by your MSTR report with the database custom SQL
3.If no of rows are same then check the data by comparing MSTR report result data with database SQL result data
4.For easier data testing pull main attribute in page by in MSTR report
5.If data is matching then check it for multiple selection using page by
Important test is to compare the report SQL vs database custom SQL