Selecting Children without knowing its parent

E

erdal akbulut

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
 
A

Alvin Bruney

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
 
Top