Can I somehow auto-generate an MDX query based on current settings in the AS OWC cube browser? Why? If so, I will want to use the AS OWC cube browser to filter the data down to < 66K rows, then auto-generate an MDX query from the current browsed settings, copy and paste the MDX script into MS Excel's OLAP query, and use it. I'm trying to avoid the 66K row limitation in Excel 2002.
If this is innappropriate, is there another way, besides raw MDX hand-coding, to accomplish the same thing?
You can start a trace using the SQL Server Profiler, and see the MDX query created by OWC. Then use that query in Excel?Chris.
No comments:
Post a Comment