We need to create a standard report(with just one axis) from an OLAP
cube. In other words, the report requires multiple rows limited by
date and other criteria and does not have to show any measure fields.

The Cube is the only data source. We have to report from it. and hence
this problem. I know that MDX is built specifically for
accessing/manipulation of Multi-dimensional data...But...Can I use MDX
for the above requirement ?

Ryan

See Appendix F in the Analysis Services Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx
It shows you how to create a linked server to Analysis Services and return a
flattened rowset.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"peejay" <pj4u_73 (AT) hotmail (DOT) com> wrote