Is there an easy way to query something along the lines of "SELECT *"
from a cube? Or must one always define row/column members?

I need to "select *", on just one axis with a "where" slicer as well.

Thanks in advance,

Alex

"*" is easy in SQL, it just means all the columns of the table. But since
OLAP is 3 dimensional and not 2 dimensional like SQL, you have to tell it
what "*" is.

If what you mean by "*" is just the measures, you could write something like:

SELECT {[Measures].members} on columns
FROM [Your Cube]
WHERE whatever

This will work in the Sample app but some front ends (like Pro Clarity)
won't allow it because the "on rows" statement isn't provided. If you're
using ADOMD, or ADOMD.NET, it will work, though.

Good luck!

- Phil

"Alex" wrote:

Manager 4.0 client supports this syntax. More to the point, it generates
syntax for MDX queries you can look at. So if you design queries in GUI you
can always look at the syntax behind it. Demo should be downloadable from
www.softpro.hr



MC

"SQL McOLAP" <SQLMcOLAP (AT) discussions (DOT) microsoft.com> wrote

What if I'd like more than one dimension per row? (or all dimensions)


E.G. -


"select


[Measures].Members on columns,
{[Date].Members, [Product].members} on rows


from [KPI Warehouse]"

You can use CrossJoin function. Something like this:

select
[Measures].Members on columns,
CrossJoin
(
{[Date].Members},
{[Product].members}
) on rows

From .....


"Alex" <fwd_newsgroups (AT) hotmail (DOT) com> wrote