Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ComputerMike
Starting Member
18 Posts |
 Posted - 2009-08-13 : 12:15:36
|
| I have to write hundreds of small SQL statements for our QA department to check a cube. I am writting one SQL state for each intersection of measure and dimension. Then QA will look at pivot table and run query to verify it is calculating correctly. I am not sure, I would QA this way, but I was given assignment.Is there anyway for me to extract MDX statement from Pivot Table or Browser in BIDS and then convert to SQL. Maybe something I could automate? Otherwise I will be writting hundreds of tiny SQL scripts for the next week or so.Thanks so much for help |
|
|
|
|
|
Easy way to translate MDX to SQL???