Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling Specific Rows From Cube Based on List of Parameters

Status
Not open for further replies.

mfty

Programmer
Jan 9, 2008
2
US
I have a webservice that's going to take in an array of strings- each of these strings represents one row of my olap table, but the list is a subset of the total. These aren't logically ordered (so a range is out) and my question is how do I pull the rows I need based on this list using MDX?
Thanks in advance
 
depends on the structure of the cube and dimensions and the list that your query is going to be constrained by. The posibility that the Tuple Set for one datapoint may return no data for the dataset at another Tuple Set then you may want to look at multiple queries. A bit more detail may lead to a better answer.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top