I have created a cube in Analysis Server and now I want to display it to
a user through a VB front end application. I am specifically trying to
do this through the select * from openquery(.... function in SQL as I
want to pass parameters to the "where" clause. Not only am I having
trouble with finding ANY but the most basic select statement examples,
but concatenating the string in order to pass proc parameters results in
syntax errors. Does anyone know of a good site that gives comprehensive
examples/help on running an MDX query within SQL?
What is the best way to display cube info, keeping in mind that my VB
app is responsible for user access security and I need to be able to
pass parameters for data retrieval to the cube?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

There should be no difference in the MDX execution between a SQL-oriented
application which understands rowsets (i.e. one using TSQL and OpenQuery --
see an example in the Analysis Services Operations Guide
(http://www.microsoft.com/technet/pro...n/anservog.msp
x) Appendix F where I use this techique to poll AS to determine if it is
still operational) or a MDX-oriented application which understands cellsets
(i.e. one using ADOMD or ADOMD.NET API) such as the MDX Sample Application.
The *only* difference is how the data is returned.

For a rowset application, the multidimensional data is flattened into a
table format by encoding the dimensionality into the column names. For a
cellset application, applications navigate the multidimensional space
directly using ordinals.

So, I think your *real* question is around "how do you write MDX"??
And for that, I'd recommend:
"Fast Track to MDX"
http://search.barnesandnoble.com/boo...sbn=1852336811
"MDX Solutions"
http://search.barnesandnoble.com/boo...sbn=0471400467
"SQL Server Analysis Services: Step-by-Step"
http://search.barnesandnoble.com/boo...sbn=0735609047

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Filia Fayard" <filia.fayard (AT) paxsal (DOT) com> wrote