How to validate the result from BO by writing SQL in toad

[devnaren]

Hi All,

Using BOXIR2

I Have a Question regarding how to write an SQL in toad to unit test my Data generated by WEBI.

I have two Queries(Query1 and Query2) and I used merge dimensions on the common dimensions. But i want to know how to write a SQL in Toad to validate my results.
Data is coming from One Universe

 

[hilfy]

Because this is a WebI question, you'll get a better response asking in the [link url="[URL unfurl="true"]http://www.tek-tips.com/threadminder.cfm?pid=393"[/URL]]Business Objects Solutions[/url] forum. This forum is specificall for Crystal Reports.

Having said that....

You need to have good knowledge of your table structure and how the tables relate to each other as well has strong SQL skills. I usually copy the two queries from the WebI, paste them into TOAD, and set up a union query from them to check the results.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.