Difference in Querying MDX -
10-14-2004
, 02:13 AM
Hi All,
I need the diff between "select * from <cubename>" and
"select <dimension list> from <cubename>"
In .NET IDE, I have created a new report project.
Under the Data Tab,
when I create a data source and execute a query as
"select * from <cubename>", I am getting a list of fields like _uniquename,
_keys.
Similarly, when I execute a query using a MDX expression like
"Select {[dimension1].allmembers} on columns,
{[dimension2].allmembers} on rows
From <cubename>", it is giving a different set of fields.
what is the difference between the two queries.
And how to retrieve the field list of _uniquename and _keys
using the later query.
Thank in advance
Andrew |