Hi all,

I am just trying to implement a search method in my OWC application. I am
using OWC 10 directly linked to a OLAP cube (MSSQL AS 2000)


The Question Is: Is it possible to write an MDX of use Pivot table methods
to query cube for a children without knowing its parent.

Let say Have:

Item
Drink
Food
Diary
Deli
Meat
Side Dishes
Deli Salads
American
Cutting Edge
Cutting Edge Cole Slaw
Cutting Edge Low Fat Cole Slaw

Can I query for Cutting Edge Low Fat Cole Slaw with MDX or filter resultset
with Pivottable methods in a easy way. I am cheking the IncludedMembers
property but no luck so far.

Any Idea?

Thanks in advance

erdal

Yup, MDX can be used for this. However, you may want to purchase a suitable
MDX resource - there are several good ones out there online as well as in
bookstores.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

"erdal akbulut" <erdalim21@yahoo.com> wrote in message
news:OYBCHw3cGHA.3352@TK2MSFTNGP03.phx.gbl...
> Hi all,
>
> I am just trying to implement a search method in my OWC application. I am
> using OWC 10 directly linked to a OLAP cube (MSSQL AS 2000)
>
>
> The Question Is: Is it possible to write an MDX of use Pivot table methods
> to query cube for a children without knowing its parent.
>
> Let say Have:
>
> Item
> Drink
> Food
> Diary
> Deli
> Meat
> Side Dishes
> Deli Salads
> American
> Cutting Edge
> Cutting Edge Cole Slaw
> Cutting Edge Low Fat Cole Slaw
>
> Can I query for Cutting Edge Low Fat Cole Slaw with MDX or filter
> resultset
> with Pivottable methods in a easy way. I am cheking the IncludedMembers
> property but no luck so far.
>
> Any Idea?
>
> Thanks in advance
>
> erdal
>
>